DATA ENGINEER - ONSITE

Location: Whitehall, Michigan

Job Type: Contract to hire / Permanent

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.

• 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 • Bui