Summary :
The Senior ETL Developer is responsible for building and maintaining the district’s data infrastructure and data integration.
This includes ensuring high quality data is integrated both between internal applications as well as with our external partners.
Responsibilities :
- Maintain and Manage the existing Client’s Enterprise Data Warehouse and ODS builds.
- Model extensions to the existing Data Warehouse
- Builds ETL components according to ETL specifications.
- Code must address performance, dependency, auditing, error handling and data quality issues.
- Create REST API integrations with Clint’s vendors and Partners
- Support post deployment by debugging, fixing, and participating in maintenance.
- Create reports to meet business requirements and address data needs.
- Create Dashboard pages and metrics within Client custom dashboard solution.
- Responsible for data integrity as well as the quality of data within Dashboard presentation layer.
- Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify / troubleshoot code-related issues;
and review and provide feedback to the final user documentation.
Read and understand business requirements, write functional requirements, develop detailed technical designs, and build / unit / system test ETL code.
Qualifications :
- Bachelor’s degree in computer science or related field Type of Experience and Number of Years :
- years of Enterprise Data Warehouse experience
- years of experience with an ETL product (SSIS, Ab Initio, etc) in a development role (administrative knowledge a plus)
- Good knowledge of data modeling / Star Schema
- Strong ANSI SQL expertise
- REST API development experience
- Experience with C, Python, JavaScript
Knowledge, Skills, and Abilities :
- Strong written and oral communications skills.
- Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
- Strong systems / process orientation with demonstrated analytical thinking, organizational skills and problem solving skills.
- Ability to work in a team-oriented, collaborative environment.
- Ability to quickly pick up new tools and technologies.
Compensation :
The pay rate range above is the base hourly pay range that Aditi Consulting reasonably expects to pay someone for this position (compensation may vary outside of this range depending on several factors, including but not limited to, a candidate’s qualifications, skills, competencies, competencies, experience, location and end client requirements).
Benefits and Ancillaries :
Medical, dental, vision, PTO benefits and ancillaries may be available for eligible Aditi Consulting employees and vary based on the plan options selected by the employee.