Data Engineer - Onsite

A.C. Coy; Whitehall Township (MI); Presencial; USD 90 000 - 140 000; Tempo integral

Resumo da oferta

A.C. Coy in Whitehall, Michigan is seeking a Data Engineer to design and implement enterprise data pipelines for AI and analytics across on‑prem and cloud environments.

You will collaborate with data scientists, analysts, and IT to deliver scalable data platforms, optimize Power BI reports, and ensure data quality and governance. The role emphasizes Azure Data Factory/Synapse, Fabric, and advanced SQL with an opportunity for contract‑to‑hire permanence.

Qualificações

• Bachelor's degree in computer science, information systems, data analytics, engineering, or a related field.
• Design and development of enterprise data, analytics, or BI solutions.
• 3+ years of experience with data integration, ETL/ELT, and data warehousing.
• Experience with Azure data services and cloud data platforms.

Responsabilidades

• Collaborate with data scientists, analysts, and IT to design data pipelines for AI and analytics needs.
• Build and optimize ETLs/ELTs and data pipelines for on-premise and cloud warehouses/lakes using SQL and Azure tech.
• Ensure data quality, governance, and monitoring across pipelines.
• Support analysts with data models, queries, and BI tooling like Power BI.
• Develop scalable Data Lake, Lakehouse, and Data Warehouse platforms across cloud/hybrid environments.
• Create ETL/ELT pipelines using Azure Data Factory, Fabric, or similar tools.
• Design data models and integration patterns for enterprise analytics and AI initiatives.
• Establish streaming, batch, and API-based integration across enterprise systems.
• Build reusable data products and secure data refresh and RBAC controls.

Conhecimentos

Data modeling

SQL

Python

PySpark

Power BI

CI/CD

DevOps

Azure

Formação académica

Bachelor's degree in CS/IS/Engineering

Ferramentas

Azure Data Factory

Azure Synapse

Microsoft Fabric

Azure Data Lake Storage

Power BI

Git

Descrição da oferta de emprego

Overview

Location: Whitehall, Michigan

Job Type: Contract to hire / Permanent

Work Authorization: No Sponsorship

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