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