DATA ENGINEER - HYBRID
A.C. Coy Whitehall, Michigan, United States
Information Technology & Services · 51-200 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
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
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
-
Senior Data Engineer II
Oscar Health New York, New York, United States · $181K–$237K/yr
-
Data Engineer
AcuityMD $113K–$159K/yr
-
Staff Data Engineer, Analytics
Afresh San Francisco, California, United States · $168K–$250K/yr
-
Data Engineer - Agentic AI
Defense Unicorns Springfield, Virginia, United States · $149K–$201K/yr
-
Senior Data Engineer
Southend Pharmacy Houston, Texas, United States · €45K–€65K/yr
-
Senior Data Engineer (Talent Pool)
ioet San José de Alluriquín, Santo Domingo de los Tsáchilas, Ecuador