← Back to jobs

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

 

Interstates. Let's Build Logo

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?

Comments 0

Want to leave a comment?
Sign in or create your account in seconds to join the discussion.
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 Talent Acquisition

Talent Acquisition is the strategic area responsible for attracting, selecting, and hiring the best professionals for the organization. Unlike traditional recruitment, TA acts as a strategic business partner, aligning talent acquisition with the company's long-term objectives.

Key skills include advanced sourcing, employer branding, labor market analysis, talent pipeline management, and candidate experience. Tools like LinkedIn Recruiter, ATS (Greenhouse, Lever, Ashby), and assessment platforms are essential.

TA professionals in technology companies are highly valued, especially those who master tech sourcing, workforce planning, and recruitment metrics like time-to-hire and cost-per-hire.

About Communications

The Communications area is strategic for building and maintaining a company's institutional image. It encompasses corporate, internal, and external communication, public relations, press office, and reputation management. Communications professionals are responsible for delivering consistent messages that strengthen the employer brand and market positioning.

Key skills include strategic writing, communication planning, crisis management, media relations, corporate content production, event organization, and digital communication. Knowledge of communication CRMs, press release distribution platforms, and media monitoring tools (Meltwater, Cision) is a differentiator.

Corporate communicators in technology companies are highly valued, especially those who master change communication, employee engagement, and digital communication. The field offers opportunities in startups, scale-ups, and large corporations, with a focus on storytelling, organizational culture, and innovation communication.

About Fullstack

Fullstack developers are versatile professionals capable of working on both frontend and backend of web and mobile applications. They master multiple technologies and can build complete products end-to-end, from the user interface to server infrastructure.

Key skills include proficiency in at least one complete stack (React/Vue/Angular + Node.js/PHP/Python/Java), databases (SQL and NoSQL), REST/GraphQL APIs, Git versioning, CI/CD, and basic infrastructure knowledge (Docker, cloud). Clean architecture, DDD, and testing are important differentiators.

Fullstack developers are highly valued in startups and companies that need versatile and autonomous professionals. The field offers opportunities from junior developer to software architect, with a focus on complete delivery, holistic product vision, and ability to work across multiple application layers.

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 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.

Career Guides

Technology Career Guide

Planning, skills, interviews, and professional growth in IT, Data Science, DevOps, and Product.

Read full guide →

Design Career Guide

UX/UI, Graphic Design, Product Design. Portfolio, tools, interviews, and growth in the Design field.

Read full guide →

Marketing Career Guide

SEO, Paid Media, Growth, Content Marketing. Certifications, tools, and strategies to grow in Digital Marketing.

Read full guide →

Finance Career Guide

Financial market, investments, corporate finance, certifications, and strategies to grow in the financial field.

Read full guide →

Communication Career Guide

Journalism, PR, Corporate Communication, Content Marketing, and Multimedia Production.

Read full guide →

Administration Career Guide

Business Management, HR, Logistics, Consulting, Project Management, and Entrepreneurship.

Read full guide →

Data Career Guide

Data Science, Data Engineering, BI, Machine Learning, and AI. From training to the job market.

Read full guide →

Product Career Guide

Product Management, Product Ownership, Agile, Scrum, and OKRs. From strategy to execution.

Read full guide →

Tech & Remote Glossary

Stop getting lost in interviews and job descriptions

The job market, especially within tech and global companies, has developed its own dialect. Not understanding these acronyms can make you lose valuable opportunities or poorly negotiate your contract. To end this problem, we created the Definitive Glossary for the Remote Professional.

🏢 Work Models & Routine

Async (Asynchronous Work)
A communication model where responses don't need to be immediate. Instead of back-to-back meetings, the team relies on well-structured documents, threads, and messages. It's the gold standard for global companies spanning multiple time zones.
Sync (Synchronous Work)
The opposite of Async. It requires the team to be online and available at the same time for meetings, live chats, and real-time collaboration.
Daily / Stand-up
A quick daily meeting (usually 15 minutes) common in Agile (Scrum) methodologies. The team answers three questions: What did I do yesterday? What will I do today? Are there any blockers?
All-Hands / Town Hall
A company-wide meeting involving all employees. Usually led by the founders (C-Levels) to present results, new goals, and answer team questions.
1:1 (One-on-One)
A recurring individual meeting between a professional and their direct manager. It is used for career alignment, feedback, and problem-solving, not just for project status updates.

💰 Contracts, Benefits & Compensation

PTO (Paid Time Off)
Instead of strict, categorized leave policies, modern US companies usually offer a flexible pool of days (e.g., 20 days of PTO, or even "Unlimited PTO") that you can use for vacations, sick days, or personal matters, while receiving your regular compensation.
Equity / Stock Options
Company ownership. The startup offers you the right to buy shares at a heavily discounted strike price in the future. If the company grows, goes public, or is acquired, these shares can be highly lucrative.
Vesting (Vesting Schedule)
The rule that controls your Equity. It usually lasts 4 years. You don't get all the shares on day one; you "earn" them gradually as you stay with the company. A "1-year Cliff" means you must stay for at least one year to receive your first batch of shares.
RSUs (Restricted Stock Units)
Unlike Stock Options (where you have the right to buy the stock), RSUs are actual shares the company grants you as a bonus or part of your compensation package, following a strict Vesting schedule.
Independent Contractor (1099 / B2B)
The most common international hiring model for global talent working for US companies. You act as a service provider (business-to-business), receiving the gross salary (often six-figure compensation) without standard local payroll tax deductions at the source.

🤖 Recruitment & Hiring Process

ATS (Applicant Tracking System)
The "robot" that reads your resume. Software like Greenhouse, Ashby, and Workday are used to filter candidates by keywords before a human even looks at the document. (Pro tip: this is why your resume must be clean, semantic, and have the right keywords).
JD (Job Description)
The document that lists the responsibilities, technical requirements, and benefits of the open position.
Cultural Fit
The interview stage that evaluates if your core values, communication style, and worldview align with the company's culture. This is the ultimate test of your Soft Skills.
Onboarding
The integration process. It's the period of your first few weeks at the company, where you get your access credentials, learn about the culture, study the internal documentation, and understand how the product works.

🚀 How to use this to your advantage?

The secret isn't just knowing what these acronyms mean, but using them actively. If during an interview for a premium tech role you ask, "How does your PTO policy and Vesting schedule work?", the recruiter will immediately perceive you as a high-level professional, familiar with the global market standards.

The remote job market requires preparation. And having the right vocabulary is the first big step to securing six-figure proposals and standing out among thousands of applicants.

Expert Tip

Why the Data Era Has Never Been More Profitable

Discover how BI professionals are shaping the corporate future, driving strategic decision-making, and landing the best global remote jobs in the market.

Reading time: 5 minutes | Category: Data / BI

The Data Market Explosion

A decade ago, oil was considered the world's most valuable resource; today, that title indisputably belongs to data. However, raw data without interpretation is just noise. It is exactly at this turning point that the Business Intelligence (BI) market exploded in demand and financial valuation.

Companies of all sizes, from agile startups to global unicorns, have realized they can no longer base their decisions on guesswork. The BI professional has become the architect of financial and operational predictability. According to Gartner, in its annual reports on the Magic Quadrant for Analytics and BI, adopting business intelligence platforms is no longer a competitive advantage, but a matter of corporate survival.

The Required Profile: Way Beyond the Dashboard

The biggest mistake professionals make when trying to transition into Business Intelligence is believing the job comes down to creating pretty visual panels (Dashboards). Today's market, especially international companies paying six-figure salaries, requires a deep analytical mindset combined with solid technical skills.

Tech Recruiters are configuring their ATS systems (like Greenhouse and Ashby) to filter candidates who master the following verticals:

  • Data Modeling and ETL: The ability to Extract, Transform, and Load data from multiple sources into a Data Warehouse or Data Lake.
  • Query Languages: Advanced proficiency in SQL remains the backbone of any data operation.
  • Advanced Visualization: Tools like Microsoft Power BI (with deep knowledge in DAX), Tableau, and Looker are mandatory requirements.
  • Critical Thinking & Business Acumen: As highlighted by the Harvard Business Review, data professionals must translate technical complexity into clear answers for C-Level executives.

Compensation and the Global Job Route (US Remote)

The Business Intelligence market is perfectly adaptable to the Remote Worldwide model. Because the work essentially deals with cloud infrastructure and logical analysis, geographical barriers have been completely eliminated.

"The ability to analyze massive volumes of data and extract actionable insights is the most valued skill in the new digital economy. The global market is literally buying intelligence."

For global professionals, this represents a golden opportunity. North American and European startups are actively seeking Senior BI talent to work remotely, offering compensation in strong currencies (USD and EUR) through B2B contracts. Base salaries that easily surpass the $80,000 to $120,000+ range (six-figure compensation) are a common reality for Mid-level and Senior analysts who have fluent English and a robust analytical portfolio.

How to Stand Out in the Technical Interview

To break through the technical interview barrier for premium BI positions, candidates must prepare a problem-oriented portfolio. Instead of presenting a generic sales dashboard, showcase a documented case study. Show the data source, how the SQL was structured for cleansing, which predictive or statistical models were applied, and, most importantly, what was the financial impact (ROI) of that analysis.