A.C. Coy

DATA ENGINEER - HYBRID

A.C. Coy Whitehall, Michigan, United States

Information Technology & Services · 51-200 employees

5 d ago
Remote data-engineer Mid (2-5 yrs) Contractor United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

Design, build, and optimize scalable data pipelines, integrations, and data platforms across cloud and hybrid environments to support enterprise analytics and AI initiatives. Ensure data quality and performance, support Power BI reporting and semantic models, and collaborate with technical teams and business stakeholders on analytics requirements.

What they look for

Python PySpark SQL ETL/ELT Data Warehousing Azure Data Factory Microsoft Fabric Azure Data Lake Storage Power BI DAX Power Query Semantic Models Data Modeling Git CI/CD Data Governance

Requirements

Requires a bachelor’s degree in a relevant technical field and at least three years of experience designing enterprise data, analytics, or BI solutions. Candidates must have experience developing data integration, ETL/ELT, and data warehousing solutions using Python and PySpark, along with experience in Azure data services, Microsoft Fabric, or similar platforms.

Full description

Overview

Location: Whitehall, Michigan or Witchita, Texas (Hybrid schedule- 3 in, 2 out)

Job Type: Contract to hire / Permanent

Work Authorization: No Sponsorship

The A.C.Coy Company has an immediate opening for a mid level Data Engineer. Ideal candidates must have 3-5 years of designing and developing enterprise data, analytics, or BI solutions and design. Key technical skills are Azure Synapse, Python/Pyspark, SQL.

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

Similar roles