Data Engineer II
Interstates•Sioux Center, IA
•Onsite
About The Position
The Data Engineer builds and maintains the data foundation that powers dashboards, analytics, and data products across Interstates. This role integrates, transforms, models, and validates data from multiple sources while partnering with analysts, developers, and operational teams to create reliable, reusable data solutions.
Requirements
- 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 or messy data and independently troubleshoot problems.
- Strong ownership of data quality and downstream usability.
- Ability to learn new systems and technologies and engage SMEs when needed.
- Strong communication and collaboration skills.
Nice To Haves
- Python or similar scripting experience.
- Experience with machine learning or AI/ML-ready datasets.
- Exposure to 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.
- 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.
Benefits
- Competitive pay
- Bonus incentives
- 401(k)
- Health, Vision, and Dental Insurance
- PTO and Holiday Pay
- Disability and Life Insurance
- Advancement Opportunities
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
