Data Engineer

Hollstadt & Associates; BLOOMINGTON (MN); Hybrid; USD 96,432 - 110,208; Full time

Benefits offered by this job

401(k) match

Longevity award

Referral bonus

Job summary

Hollstadt Consulting seeks a Data Engineer to build foundational data capabilities supporting BI, analytics, AI, and security in a complex semiconductor environment. You will join a growing data organization and work with AI engineers, analysts, manufacturing teams, and IT to ingest, transform, and empower data usage across the company.

A major focus will be modernizing legacy data environments, including data warehouses, data pipelines, and metadata ownership.

Qualifications

• Professional experience designing and building production data pipelines.
• Strong SQL skills with experience in relational databases.
• Experience ingesting and transforming data from multiple sources.
• Understanding of data warehouses, data lakes, data marts, and data modeling.
• Experience with legacy data, incomplete documentation, and disconnected systems.
• Ability to investigate data issues and identify root causes across source systems and transformations.
• US citizenship required for Bloomington facility.

Responsibilities

• Design, develop, and maintain pipelines ingesting data from enterprise, manufacturing, customer-facing, and legacy systems.
• Bring data into data lake, warehouse, analytics, and AI environments.
• Profile legacy data for structure, quality, ownership, and downstream use.
• Develop transformations adding classifications, metadata, ownership, and security attributes.
• Support AI-assisted approaches for identifying sensitive or regulated data.
• Collaborate with analysts and stakeholders to translate data requirements into scalable solutions.
• Help design data lakes, warehouses, and data marts; support modernization of legacy systems.
• Prepare data structures for row-level security and access controls.
• Build reliable data flows for BI, analytics, and AI use cases.
• Monitor data quality and pipeline performance.
• Document source-to-target mappings and dependencies.
• Collaborate with AI team on manufacturing use cases.

Skills

Production data pipelines

SQL

Data ingestion

Data warehouses

Data lakes

Legacy data

Data modeling

Documentation

Independent work

US citizenship

Job description

Hollstadt Consulting is a management and technology consulting firm dedicated to placing professionals at engagements where they will excel. When you work with us, you'll work with a refreshingly real company led and staffed by seasoned experts who are also down-to-earth, good people. We're committed to treating you with respect and helping you achieve your career aspirations.

Since 1990, Hollstadt has been a trusted partner to more than 150 domestic and global companies and has successfully completed over 3,000 projects. Our continued growth has created challenging and rewarding opportunities for accomplished IT and Business Consultants. Hollstadt Consulting is an equal opportunity employer including disability/veteran.

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Hollstadt Consulting and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel at any time.

Job Description

Role: Data Engineer

Location: Hybrid in Bloomington, MN preferred; approximately 1–2 days onsite per week

Employment Type: Six-month contract-to-hire

Citizenship Requirement: Must be a U.S. citizen

Target Start: Around 9/7/2026

Rate: $70-$80/hour W2

Position Overview

The Data Engineer will help build the foundational data capabilities needed to support business intelligence, manufacturing analytics, AI, security, and enterprise reporting across a complex semiconductor manufacturing environment.

The company currently has a dedicated AI team but is building out its broader data and BI capabilities. The Data Engineer will work with a newly forming data organization, technical leadership, AI engineers, business analysts, manufacturing teams, and enterprise IT to ingest, transform, organize, classify, and make data usable across the company.

A major initial focus will be reverse engineering and modernizing a legacy data environment that includes manufacturing systems, older databases, disconnected applications, data warehouses, data marts, and systems that currently lack sufficient metadata, ownership attribution, and security classifications.

Key Responsibilities

• Design, develop, and maintain pipelines that ingest data from enterprise, manufacturing, customer-facing, and legacy systems.
• Bring data that is currently disconnected or inaccessible into the company’s data lake, warehouse, analytics, and AI environments.
• Profile legacy data to understand its structure, quality, business meaning, sensitivity, ownership, and downstream use.
• Develop transformation and enrichment processes that add necessary classifications, metadata, ownership, and security attributes.
• Support rule-based and AI-assisted approaches for identifying sensitive, customer-owned, regulated, or restricted data.
• Partner with business analysts and stakeholders to translate data requirements into scalable technical solutions.
• Help design and improve data lakes, data warehouses, data marts, and related data architecture.
• Support modernization initiatives involving legacy manufacturing systems and databases, including movement from older platforms into SQL-based environments.
• Prepare data structures that allow infrastructure and security teams to implement row-level security and role-based access.
• Build and maintain reliable data flows supporting business intelligence, reporting, advanced analytics, and AI use cases.
• Monitor data quality, pipeline reliability, job performance, exceptions, and processing failures.
• Identify systems or datasets that cannot be effectively remediated and provide technical input into migration or replacement decisions.
• Document source-to-target mappings, transformations, technical dependencies, data models, and operational support procedures.
• Collaborate with the AI team on manufacturing use cases such as pattern recognition, defect identification, yield improvement, and earlier detection of production issues.
• Help create repeatable engineering standards and practices for a data organization that is being built from the ground up.

Required Qualifications

• Professional experience designing and building production data pipelines.
• Strong SQL skills and experience working with relational databases.
• Experience ingesting and transforming data from multiple structured or semi-structured sources.
• Understanding of data warehouses, data lakes, data marts, data modeling, and modern data-engineering practices.
• Experience working with legacy data, incomplete documentation, inconsistent schemas, or disconnected systems.
• Ability to investigate data issues and determine root causes across source systems, transformations, and downstream applications.
• Experience working with business analysts, architects, infrastructure teams, application teams, and business stakeholders.
• Strong documentation and communication skills.
• Ability to operate independently in an evolving environment without waiting for every process or requirement to be fully defined.
• U.S. citizenship, including the ability to enter the federally governed Bloomington facility.

Preferred Qualifications

• Semiconductor, high-tech manufacturing, precision manufacturing, aerospace, automotive, medical-device, or other regulated manufacturing experience.
• Experience with manufacturing data, production systems, equipment data, quality data, yield analytics, or operational technology.
• Experience with data classification, data security, metadata management, row-level security, access management, or customer-data segregation.
• Exposure to AI or machine-learning data pipelines.
• Experience modernizing older databases or applications into SQL-based or cloud-oriented data environments.
• Experience supporting organizations through acquisitions, system consolidation, or data‑separation initiatives.

Success Profile

This role requires an engineer who is resourceful, hands‑on, and comfortable working in an environment where the team may only be one or two people deep in a particular discipline. The ideal candidate will not stop when documentation is incomplete or when someone says data cannot be accessed. They will investigate, identify the real constraint, propose practical options, and help move the organization forward.

Why This Opportunity

The Data Engineer will support advanced semiconductor manufacturing and emerging quantum‑computing capabilities. The company is investing in AI initiatives designed to identify production problems earlier, reduce scrap, improve semiconductor yield, and generate substantial measurable returns. This position offers an opportunity to build foundational data capabilities rather than simply maintain an already mature platform.

Hollstadt offers medical, dental, vision, life insurance, short‑term disability, long‑term disability, paid sick leave, and retirement benefits to eligible employees. With three different medical plans to choose from, you can enroll in the coverage you need from individual to family, or anywhere in between!

Remarketing Process

Hollstadt is based on retention and relationships. We get to know your strengths and career wishes throughout your assignment and then start remarket discussions 6‑8 weeks prior to your end date. By being proactive, we are able to keep your down time between assignments as short as possible, unless you choose otherwise.

Professional Development

Hollstadt offers on‑demand training through our consultant portal. Trainings give our consultants the continuing education they need to excel on their projects. Many of our courses apply towards continuing education credits and we have an entire training hub dedicated to upskilling in Artificial Intelligence (AI).

401k + Matching

One popular benefit is our 401(k) match on the first 4% of your contributions. Hollstadt wants to help you reach your long‑term financial goals and understands that planning for your future is critical. Consultants also have access to support from a Financial Advisor.

We appreciate and reward loyalty. Join Hollstadt, stay for 5 years, and we’ll give you a $5,000 Longevity Award bonus! Additionally, we know great talent knows other great talent. If you are on contract with Hollstadt and refer one of your connections who gets placed, we’ll pay you $1,000!

Ongoing Support & Networking

We have made a significant investment in building a support program for our consultant team - so you never have to feel like you are going it alone. We also have a Consultant Coach program which acts like a 'work buddy' to provide a safe ear for questions or concerns at your client site.