Data Engineer - Build & Optimize ETL Pipelines (Azure, dbt)

HMA Group Holdings, LLC; West Des Moines (IA); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Health, dental, and vision insurance

Paid parental leave

401(k) profit sharing

Paid volunteer time off

Job summary

HMA Group Holdings, LLC is seeking a Data Engineer to enhance our Information Technology team in West Des Moines, IA. The ideal candidate will design, build, and optimize ETL/ELT pipelines using Azure Data Factory, dbt, and Alteryx.

Responsibilities include implementing data transformations and mentoring junior engineers, while qualifications require a Bachelor’s degree and 3-5 years of relevant experience. The position offers comprehensive benefits including health insurance and a 401(k) profit-sharing plan.

Qualifications

• 3–5 years of professional experience in data, analytics, or platform engineering.
• Strong ability to work with diverse data sources (structured and unstructured).
• Knowledge of Salesforce is a plus.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines from multiple sources.
• Implement advanced data transformations and recommend storage solutions.
• Monitor pipelines and conduct root-cause analysis for performance issues.

Skills

ETL/ELT development

Data transformation

SQL

Azure Data Factory

Alteryx

dbt

Data modeling

APIs knowledge

Problem-solving skills

Education

Bachelor’s degree in computer science, data science, technology, information systems, or engineering

Tools

Microsoft Fabric

Snowflake

Job description

HMA Group Holdings, LLC is seeking a Data Engineer to enhance our Information Technology team in West Des Moines, IA. The ideal candidate will design, build, and optimize ETL/ELT pipelines using Azure Data Factory, dbt, and Alteryx.

Responsibilities include implementing data transformations and mentoring junior engineers, while qualifications require a Bachelor’s degree and 3-5 years of relevant experience. The position offers comprehensive benefits including health insurance and a 401(k) profit-sharing plan.