ETL Developer II

Location: Birmingham, Alabama

Job Summary

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.

Key Responsibilities

• 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.

REQUIRED:

• 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