Senior ETL Developer II

Wakely

Saint Paul (MN)

On-site

USD 150,000 - 170,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

HMA is seeking a Senior ETL Developer II to design, develop, test, and support complex data integration solutions using SQL Server and SSIS. The role focuses on translating business requirements into scalable data workflows supporting healthcare claims, encounters, eligibility, enrollment, and financial data processing.

The position requires 8+ years in ETL/data integration, with 3+ years in a lead or senior leadership capacity, and a bachelor’s degree in a related field.

Qualifications

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

Responsibilities

  • Translate business requirements into technical specifications, data mappings, and processing logic.
  • Designs, develops, tests, and supports ETL processes using SQL Server, SSIS, and related technologies.
  • Troubleshoots data-processing, integration, and production issues and performs root-cause analysis.
  • Provides technical design guidance, participates in code reviews, and mentors other developers on ETL design and healthcare data.
  • Works with stakeholders, analysts, and operations teams to define requirements and develop data-processing solutions.

Skills

SQL Server
SSIS
SQL development
Data transformation

Education

Bachelor's degree in Computer Science/Information Science/Mathematics

Job description

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

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.

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior ETL Developer II
Senior ETL Developer II

Wakely Consulting Group • Saint Paul (MN)

On-site
USD 150,000 - 170,000
Health, dental, vision benefits
401(k) employer match
Equity incentive plan
+1
Manager, Data Engineering & Integration
Manager, Data Engineering & Integration

Wakely • Saint Paul (MN)

On-site
USD 155,000 - 180,000
Health, dental, vision benefits
401(k) employer match
Paid time off
+1
Manager, Data Engineering & Integration
Manager, Data Engineering & Integration

Wakely Consulting Group • Saint Paul (MN)

On-site
USD 155,000 - 180,000
Health benefits
Dental & Vision insurance
401(k) matching
+3
Senior Data Scientist
Senior Data Scientist

Wakely • Saint Paul (MN)

On-site
USD 120,000 - 145,000
Senior Data Scientist
Senior Data Scientist

Wakely Consulting Group • Saint Paul (MN)

On-site
USD 120,000 - 145,000
Health benefits
Dental insurance
Vision insurance
+2
ETL Developer
ETL Developer

Ensure Data Solutions, LLC • United States

On-site
USD 85,000 - 120,000
Data Conversion Lead
Data Conversion Lead

HealthEdge Software, Inc. • United States

Hybrid
USD 150,000 - 170,000
Remote work
Senior ETL / Data Integration Developer
Senior ETL / Data Integration Developer

Optum • Eden Prairie (MN)

Remote
USD 92,000 - 164,000
Data Conversion Lead
Data Conversion Lead

Healthedge • United States

Remote
USD 150,000 - 170,000
Senior ETL Lead — Healthcare Data Integration
Senior ETL Lead — Healthcare Data Integration

Wakely • Saint Paul (MN)

On-site
USD 150,000 - 170,000