DATA ENGINEER - ONSITE

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