Data Engineer

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. #J-18808-Ljbffr