Data Engineer II: ETL & Analytics On-Site

Interstates Companies; Reppert Addition (SD); On-site; USD 100,000 - 160,000; Full time

Benefits offered by this job

401(k)

Health Insurance

Dental Insurance

Vision Insurance

PTO and Holidays

Disability and Life Insurance

Job summary

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

The role focuses on ETL/ELT processes, data pipelines, and advanced SQL; you will work with OT and manufacturing data to ensure data quality and actionable insights for AI/ML initiatives.

Qualifications

• Strong SQL skills including complex joins, transformations and data manipulation.
• Proficiency in Python or similar scripting languages.
• Experience with ML/AI-ready datasets and analytics-ready data.
• Familiarity with time-series, sensor, or industrial equipment data.
• Understanding of manufacturing KPIs and operational metrics.
• Experience with modern data orchestration and integration tools.

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.
• Collaborate with OT, manufacturing, and data SMEs to translate requirements.

Skills

SQL

Python

ML/AI

Time-series data

Industrial data

Data orchestration

Data modeling

Data quality

ETL/ELT

Data pipelines

Tools

Airflow

Job description

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

The role focuses on ETL/ELT processes, data pipelines, and advanced SQL; you will work with OT and manufacturing data to ensure data quality and actionable insights for AI/ML initiatives.