Industrial Data Engineer - ETL, SQL & Dashboards (Hybrid)

Interstates; Cincinnati (OH); Hybrid; USD 110,000 - 150,000; Full time

Job summary

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

This in-person role supports OT and manufacturing data systems; hybrid work is available near listed offices.

Qualifications

• Experience in data engineering, analytics engineering, software development, or a related technical field.
• Strong SQL skills, including complex queries, joins, transformations, and data manipulation.
• Knowledge of ETL/ELT, data pipelines, data integration, and data modeling.
• Understanding of data quality, validation, governance, and lineage.
• Ability to work through ambiguous data and independently troubleshoot problems.
• Strong ownership of data quality and downstream usability.
• Ability to learn new systems and engage SMEs when needed.
• Strong communication and collaboration skills.

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

Manufacturing KPIs

Data orchestration

SQL

Tools

ETL tools

Job description

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

This in-person role supports OT and manufacturing data systems; hybrid work is available near listed offices.