
Posted 9 days ago
Data Engineer - Onsite
AI Summary
Designs, builds and optimizes ETL/ELT pipelines, data lakes and warehouses, and Power BI semantic models for a manufacturing enterprise's analytics and AI needs. Works closely with data scientists, analysts and IT stakeholders.
About this role
Overview
Location: Whitehall, Michigan
Job Type: Contract to hire / Permanent
Work Authorization: No Sponsorship
The A.C.Coy Company has an immediate opening for a Data Engineer. Ideal candidates must have 3+ years of designing and developing enterprise data, analytics, or BI solutions and design and development of data integration, ETL/ELT, and data warehousing using Python and PySpark.
Responsibilities
• Collaborating closely with data scientists, data analysts, and IT counterparts to design the data pipelines required to fulfill the AI and analytical needs of a large manufacturing enterprise• Modeling, building and optimizing complex scalable ETLs and data pipelines to grow and support on-premise and cloud based data warehouses and data lakes using SQL and Azure technologies• Implementing processes and systems to ensure data quality and optimal pipeline and model performance over time• Providing business analysts with support for data model and query design/tuning for tools such as Power BI and Python scripts• Design, develop, and support scalable Data Lake, Lakehouse, Data Warehouse, and AI-enabled data platforms across cloud and hybrid environments• Design and develop ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric, or similar technologies• Design scalable data models and integration patterns to support enterprise analytics and AI initiatives• Establish event-driven, streaming, batch, and API-based integration patterns across enterprise systems • Build and maintain data integration pipelines for plant, business unit, or enterprise applications• Implement data validation, monitoring, quality controls, and data governance best practices • Develop reusable semantic models, datasets, and data products that enable self-service analytics• Optimize Power BI performance, data refresh processes, and security, including Row-Level Security (RLS) and workspace governance• Collaborate with business stakeholders to define reporting requirements, KPIs, and analytics solutions• Optimize SQL queries and data processing performance to ensure scalable and efficient data solutions• Evaluate emerging data and AI technologies and recommend solutions that improve business processes and operational efficiency
Qualifications
Education:
- Bachelor’s degree in computer science, Information Systems, Data Analytics, Engineering, or a related technical field
Required Experience:
- Designing and developing enterprise data, analytics, or BI solutions - 3+ years
- Design and development of data integration, ETL/ELT, and data warehousing using Python and PySpark
- Experience with Microsoft Azure data services, Microsoft Fabric, or similar cloud data platforms Azure Data Factory/Synapse/Fabric Azure Data Lake Storage (ADLS)
- Demonstrated use of advanced SQL skills to build complex well-tuned queries to join and shape diverse datasets - Preferred
- Demonstrated experience using DevOps with GIT and CI/CD - Preferred
- Demonstrated experience using Power BI as well as DAX, Power Query, and Semantic models - Preferred
- Experience using the Azure GCC High environment for data ingestion, collection and analysis - Preferred
- Experience in Azure ML studio, Azure Foundry or AI enabled tools - Preferred
- Accomplishment of Azure Certifications DP-600 (Fabric Analytics Engineer Associate) or (DP-700 (Fabric Data Engineer Associate) - Preferred
Skills
Explore related jobs
More jobs at A.C. Coy
Similar ETL/ELT jobs
- T
Consultor/a Azure Data Factory & Power BITECDATA ENGINEERING · Barcelona, Spain - N
Expert (Azure Data Factory, Fabric and SQL preferred)Nielseniq · Chennai, TN - T
Ingeniero de datos / Azure Data Factory + Power BITECDATA ENGINEERING · Barcelona, Spain - I
Azure Data Factory Developer / 8 Months Rolling Contract / SunburyInternational Business Solutions Consult · Sunbury-On-Thames, United Kingdom - T
Data Engineer / BI Developer (Azure Data Factory + Power BITECDATA ENGINEERING · Barcelona, Spain - T
Data Engineer Azure Data Factory (ADF) - Argentina | 100% remotoTalent Connect · Buenos Aires, Argentina
Jobs in Whitehall
- D
General Manager(04833)-2601 MacArthur RdDomino's · Whitehall, PA - D
General Manager(04794) - 155 Mickley RoadDomino's · Whitehall, PA - D
Assistant Manager(04833)-2601 MacArthur Rd, Whitehall, PA 180522601 MacArthur RdDomino's · Whitehall, PA - D
Delivery Driver(04794) - 155 Mickley RoadDomino's · Whitehall, PA - D
Customer Service Rep(04833)-2601 MacArthur RdDomino's · Whitehall, PA - M
Seasonal Retail Commission Sales Associate - Fine Jewelry, Lehigh ValleyMacy's · Whitehall, PA
Browse these categories
Market data for data engineer roles
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.