Data Engineer Ii
interstates
Sioux Falls, SD
Data
Job Score
80 pts
On-site model (+70)
Data (+10)
Take Charge of Your Career at Interstates
At Interstates, we don’t just show up to work, we show up for each other. From our headquarters in Iowa to job sites across the country, we’re doing award-winning electrical, controls, automation, and OT work that powers industrial facilities for clients here in the U.S. and around the world. Whether you’re bending conduit, wiring panels, writing code, supporting projects, or helping things run behind the scenes, you’ll be part of a crew that works hard, shares laughs, and takes pride in doing quality work. We believe in building strong teams, doing the right thing, and making a difference in the communities where we live. If you want to grow and do meaningful work, you’ll feel at home here.
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.
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.
Preferred Skills
- 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.
Knowledge & Expertise
- 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.
Location: Sioux Falls, SD or Sioux Center, IA. This is an in person role and the selected candidate must be in one of the listed locations.
Travel:The amount of travel will vary according to business requirements - 10%.
Benefits You Can Depend On:
In addition to highly competitive pay and quality benefits, Interstates strives to offer opportunities for education and career development, empowering you to have a career that’s built to last. Some of our benefits include:
- Competitive pay
- Bonus incentives
- 401(k)
- Health, Vision, and Dental Insurance
- PTO and Holiday Pay
- Disability and Life Insurance
- Advancement Opportunities
What You Should Know Before You Apply
Interstates may collect personal information as part of your job application, such as your contact details, work history, education, and any information you provide. This information is used only for recruitment, to evaluate your candidacy, and to meet legal requirements. For details about our privacy practices and your rights under the California Consumer Privacy Act (CCPA), please see our Privacy Policy. By applying, you acknowledge that you have reviewed this notice.
Interstates is an EEO provider and offers a drug-free workplace. Employment at Interstates is at-will and may be terminated at any time with or without notice or cause, except as otherwise provided by law.
What did you think of this job?
Loading comments...
About Data
The Data field has undergone a radical transformation with the rise of Generative AI. Data professionals are fundamental for evidence-based decision-making across all industries.
Key specializations include Data Engineering, Data Science, Business Intelligence, Machine Learning Engineering, and Analytics. Tools like SQL, Python, Spark, dbt, and cloud platforms (AWS, GCP, Azure) are essential.
The data market continues with high demand and salaries among the most competitive in the technology sector, with many remote work opportunities.
Discover Other Areas
Understand the scope of work, key skills, and tools used in different career areas.
About Public Relations
The Public Relations (PR) area focuses on managing the reputation, image, and communication of an organization with its various stakeholders (such as clients, investors, employees, media, and the community). PR professionals develop corporate communication strategies, manage media relations (press relations), organize institutional events, and work in image crisis prevention and management.
About Ecommerce Manager
The Ecommerce Manager is the professional responsible for the entire strategic and operational management of online stores and marketplaces. They lead teams, define pricing, promotion, and catalog strategies, and monitor online sales performance across multiple platforms.
Key skills include catalog management, dynamic pricing, seasonal campaigns (Black Friday, Cyber Monday), marketplace management (Amazon, Mercado Livre, Shopee, Magalu), paid traffic, CRO, and team management. Knowledge of Shopify, VTEX, WooCommerce, Google Ads, Meta Ads, and performance metrics is a differentiator.
Ecommerce Managers in technology companies are highly valued, especially those who master multi-marketplace management, checkout optimization, and mobile commerce strategies. The field offers opportunities from ecommerce manager to head of ecommerce, with a focus on revenue, customer experience, and growth.
About Project Management
Project Management is essential to ensure strategic initiatives are delivered on time, within scope, and with quality. PM professionals coordinate teams, manage risks, and communicate with stakeholders.
Key methodologies include PMBOK, PRINCE2, Scrum, and Kanban. Tools like Jira, Asana, Monday, and MS Project are widely used in daily work.
Certifications like PMP and PgMP are important differentiators in the market, with growing demand in technology and consulting companies.
About Content Writer
The Content Writer is the professional responsible for creating quality written content for websites, blogs, social media, and other digital platforms. They combine writing skills with content strategy and SEO to attract, engage, and convert audiences.
Key skills include blog content creation, landing pages, newsletters, social media content, keyword research, content strategy, editorial calendar, and SEO writing. Knowledge of WordPress, Surfer SEO, Ahrefs, and analytics tools is a differentiator.
Content Writers in technology companies are highly valued, especially those who can create accessible technical content, evergreen content, and content that generates organic traffic. The field offers opportunities from junior content writer to head of content, with a focus on quality, strategy, and content performance.
About Administrative
The Administrative area is responsible for ensuring the efficient functioning of all organizational operations. Administrative professionals manage processes, human resources, procurement, and facility management.
Key skills include process management, Office 365, administrative ERPs, compliance, and people management. Knowledge of automation and AI tools is becoming increasingly relevant.
The digitization of administrative processes has created new opportunities for professionals who master technology and management.
Comments 0