Senior ETL Developer 2

Overview

Job Summary

The Senior ETL Developer II designs, develops, tests, and supports complex data integration and processing solutions using SQL Server, SSIS, and related technologies. This role translates complex business requirements into scalable, efficient, and maintainable data processing solutions. The Senior ETL Developer II collaborates with stakeholders and technical teams to refine requirements, design solutions and implement data workflows that support healthcare claims, encounter, eligibility, enrollment, and financial data processing.  The role troubleshoots data and production issues, contributes to improvements in data quality, automation, performance, and operational efficiency, participates in design and code reviews, mentors other developers, and supports established development standards and project delivery.

Responsibilities

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.

Qualifications

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

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

Additional Info

Salary:

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.