Senior Data Engineer - Enterprise Data Warehouse Lead (Hybrid)

Coric Industries LLC; Southfield (MI); Hybrid; USD 145,000 - 155,000; Full time

Job summary

Coric Industries LLC seeks a Senior Data Engineer to design, build, and operate a layered, enterprise data warehouse consolidating multiple ERP systems across a nationwide organization.

You will develop automated nightly ingestion pipelines, map legacy schemas to a canonical model, and govern data with enterprise dictionaries and access controls. Collaboration with finance, sales, and ops is essential.

Qualifications

• Bachelor's degree in computer science, information systems, or a related field required, or equivalent practical experience.
• 5+ years of progressive data engineering experience, including at least one enterprise data warehouse.
• Experience with ERP data environments preferred; familiarity with Dynamics 365 Business Central or dealer management systems is a plus.
• Proficiency in SQL with ability to profile large schemas; strong dimensional modeling knowledge.
• Production experience with cloud data platforms and REST API integration.

Responsibilities

• Design and implement a layered enterprise data warehouse consolidating multiple ERP systems.
• Build and operate nightly ingestion pipelines from relational databases, vendor exports, REST APIs, and file feeds.
• Map legacy ERP schemas to a canonical, company-wide dimensional model.
• Develop conformed dimensions and fact tables with an enterprise data dictionary.
• Implement data access controls, data lineage, and SOX-aligned IT controls.
• Support BI visualization layer with Power BI and semantic models.

Skills

SQL

Dimensional modeling

Python

Cloud data platform

REST APIs

Power BI

Data governance

Education

Bachelor's degree in computer science or information systems

Tools

Microsoft Fabric

Azure Synapse

Databricks

Snowflake

Job description

Coric Industries LLC seeks a Senior Data Engineer to design, build, and operate a layered, enterprise data warehouse consolidating multiple ERP systems across a nationwide organization.

You will develop automated nightly ingestion pipelines, map legacy schemas to a canonical model, and govern data with enterprise dictionaries and access controls. Collaboration with finance, sales, and ops is essential.