Senior ETL Developer II

Work Performed and Job Requirements

• ETL Development
• Translates business requirements into technical specifications, data mappings, and processing logic.
• Designs, develops, tests, and supports complex ETL processes using SQL Server, SSIS, and related technologies.
• Data Quality and Technical Support
• Troubleshoots data-processing, integration, and production issues and performs root-cause analysis.
• Supports data validation, quality assurance, performance improvement, automation, and maintenance of existing solutions.
• Technical Collaboration
• Provides technical design guidance, participates in code reviews, and mentors other developers on ETL design, SQL, and healthcare data.
• Promotes established software development lifecycle, documentation, testing, source-control, and quality-assurance practices.
• Contributes to improvements in automation, scalability, performance, data quality, and operational efficiency.
• Project and Stakeholder Support
• Works with stakeholders, analysts, and operations teams to define requirements, identify solution gaps, and develop effective data-processing solutions.
• Contributes to technical design reviews, project planning, effort estimates, and implementation activities.
• Serves as a subject matter resource for data integration, ETL development, and healthcare business rule implementation.
• All other duties as assigned.

Education/Training

A bachelor’s degree in computer science, information science, mathematics, or a related field is required.

Experience

Minimum of 8 years of professional experience in ETL, data integration, data warehousing, or data development roles using SQL Server and related technologies is required. Minimum of 3 years of experience in a lead, senior lead, or technical leadership capacity is required, including experience mentoring team members, coordinating technical work, and working with stakeholders to gather requirements. Experience with healthcare claims, encounter, enrollment, eligibility, financial, or regulatory-reporting data is preferred.

Knowledge, Skills and Abilities

• Advanced hands-on knowledge of SQL Server, SSIS, SQL development, and data transformation.
• Ability to translate business requirements into technical specifications, data mappings, and ETL solutions.
• Ability to troubleshoot complex data-processing issues and perform root-cause analysis.
• Knowledge of data validation, quality assurance, source control, testing, and documentation practices.
• Ability to provide technical guidance, conduct peer reviews, and mentor other developers.
• Ability to understand and apply complex healthcare data and business rules.
• Strong analytical, problem-solving, organizational, and time-management skills.
• Strong written, verbal, and interpersonal communication skills.
• Ability to manage multiple projects and priorities concurrently.
• Self-motivated with a commitment to continuous learning and process improvement.
• Ability to use technology and AI tools ethically and effectively to improve efficiency, quality, and processes while protecting confidential information and applying sound judgment.

EEO

The posted salary range for this role at HMA includes a range of factors that we consider when making compensation decisions. These factors include but are not limited to experience, education, training, skills, licensures, and certifications, along with other business and organizational needs. HMA may adjust the posted salary range estimate for applicable geographic differentials associated with the location where we may fill the position.

At HMA, we generally do not hire an individual at or near the top of the range for their role. All compensation decisions are dependent on the variables of each case. A reasonable estimate of the existing salary range for this position is $150,000 to $170,000.

HMA offers a robust benefits package for full-time colleagues. Benefits include health, dental, vision, group life/AD&D, voluntary life/AD&D, short-term disability, long-term disability, paid parental leave, paid time off, paid holidays, 401(k) employer match and safe harbor contribution, and our long-term equity incentive plan.