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

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights (https://www.eeoc.gov/poster) notice from the Department of Labor.