Data Engineer II — ETL Pipelines & Analytics (Industrial)

Interstates Companies; Sioux Center (IA); On-site; USD 105,000 - 145,000; Full time

Benefits offered by this job

Competitive pay

401(k)

Health, Vision, and Dental Insurance

PTO and Holiday Pay

Disability and Life Insurance

Job summary

Interstates, headquartered in Iowa, is seeking a Data Engineer to build and maintain the data foundation powering dashboards, analytics, and data products across the company. You will integrate, transform, model, and validate data from multiple sources while partnering with analysts, developers, and operations teams to create reliable data solutions.

You will work with SQL, ETL/ELT, and modern data orchestration tools, ensure data quality, and support AI/ML initiatives.

Qualifications

• Experience in data engineering, analytics engineering, or related field.
• Strong SQL skills with complex queries, joins, and transformations.
• Familiarity with ETL/ELT, data pipelines, and data modeling.
• Ability to work with data quality, validation, governance, and lineage.

Responsibilities

• Design, develop, and maintain ETL/ELT processes and data pipelines.
• Integrate, clean, transform, and model data from multiple sources.
• Develop and optimize advanced SQL queries.
• Prepare data for dashboards, visualization, analytics, and data products.
• Monitor and improve data quality, validation, and reliability.
• Support data integrations, APIs, and data orchestration.
• Work with OT, manufacturing, and industrial data systems to understand data flows and requirements.
• Build reusable, scalable data solutions and document processes and data flows.
• Partner with analysts, developers, and operational SMEs to translate business needs into technical solutions.
• Support datasets and data foundations for advanced analytics and AI/ML initiatives.

Skills

Python

ML-ready datasets

Time-series data

Manufacturing KPIs

Data orchestration tools

Tools

SQL

ETL/ELT

Job description

Interstates, headquartered in Iowa, is seeking a Data Engineer to build and maintain the data foundation powering dashboards, analytics, and data products across the company. You will integrate, transform, model, and validate data from multiple sources while partnering with analysts, developers, and operations teams to create reliable data solutions.

You will work with SQL, ETL/ELT, and modern data orchestration tools, ensure data quality, and support AI/ML initiatives.