ETL Developer II

The ETL Developer II is responsible for independently designing, developing, implementing, and supporting moderately complex to complex healthcare data integration solutions. This experienced individual has a strong understanding of enterprise data integration practices and healthcare data and works directly with technical and business stakeholders to translate requirements into reliable, scalable data solutions., * Independently design and develop complex ETL/ELT pipelines.

• Integrate data from multiple clinical, financial, operational, claims and third-party systems.
• Translate business requirements and source-system behavior into technical integration designs.
• Develop reusable integration patterns and components.
• Optimize ETL processes for performance, scalability and reliability.
• Design data validation, reconciliation, exception-handling, and recovery processes.
• Perform root-cause analysis of complex data-quality and production issues.
• Evaluate upstream and downstream impacts of data and system changes.
• Participate in solution design and technical design reviews.
• Conduct peer code reviews and reinforce development standards.
• Work directly with Data Governance, data owners, data stewards, analysts, architects, and application teams.
• Implement technical metadata and data-lineage requirements.
• Support implementation of business definitions and data-quality rules within integration processes.
• Mentor Level I developers on technical practices and healthcare data concepts.
• Lead small-to-medium data integration initiatives.
• Identify opportunities to automate or improve existing data pipelines.
• Support modernization of legacy ETL processes and migration to cloud or modern data platforms.

• Bachelor’s Degree
• 3 - 6 years relevant ETL, data engineering, database, or data integration experience with demonstrated experience independently delivering production data solutions
• 3 - 6 years’ experience with SQL Server
• SQL
• Excellent interpersonal skills for frequent interaction with many levels of employees
• Strong project management skills
• Knowledge of Microsoft SQL Server and all Microsoft Office applications

PREFERRED:

• Healthcare experience
• Relational databases
• ETL/ELT development
• Data transformation
• Data validation and reconciliation
• Source-to-target mapping
• Testing and debugging