Senior Data Engineer - Enterprise Data Platform

Coric Equipment; Southfield (MI); Hybrid; USD 120,000 - 190,000; Full time

Job summary

Coric Equipment is seeking a Senior Data Engineer to design, build, and operate our enterprise data warehouse, consolidating data from multiple ERP systems for nationwide operations. You will create robust ingestion pipelines, standardize data definitions, and support executive reporting and AI-ready analytics.

You will partner with finance, sales, and operations to implement governance, data lineage, and automated controls, enabling audit-ready datasets and scalable BI support.

Qualifications

• Bachelor's degree in computer science, information systems, or related field, or equivalent practical experience.
• 5+ years of progressive data engineering experience, with at least one enterprise data warehouse in production.
• Strong SQL, Python, and dimensional modeling skills; experience with ERP data is a plus.
• Experience with data governance, lineage, access controls, and SOX-aligned controls.
• Proficient BI capabilities (Power BI) and semantic modeling for dashboards.
• Excellent communication to document requirements and explain trade-offs to leadership.

Responsibilities

• Design and implement layered enterprise data warehouse consolidating multiple ERP systems.
• Build and operate nightly ingestion pipelines from relational databases, exports, APIs, and files.
• Document legacy ERP schemas and map to canonical dimensional model.
• Develop conformed dimensions and fact tables with enterprise data dictionary.
• Implement automated reconciliation with financial reporting systems and audit-ready data.
• Manage role-based access and data lineage; conduct access reviews.
• Enforce IT controls, change management, and data governance practices (SOX-aligned).
• Support audit activities and respond to inquiries on data controls and lineage.
• Collaborate on BI visualization layer with Power BI and semantic datasets.
• Evaluate new data platform technologies and justify platform choices.
• Integrate acquired companies into standardized data architecture as growth continues.
• Produce documentation for architecture, pipelines, controls, and procedures.

Skills

SQL

Python

Dimensional modeling

REST APIs

Power BI

SOX controls

Data governance

Education

Bachelor's in CS/IS

Tools

Azure Synapse

Snowflake

Databricks

Job description

Coric Equipment is seeking a Senior Data Engineer to design, build, and operate our enterprise data warehouse, consolidating data from multiple ERP systems for nationwide operations. You will create robust ingestion pipelines, standardize data definitions, and support executive reporting and AI-ready analytics.

You will partner with finance, sales, and operations to implement governance, data lineage, and automated controls, enabling audit-ready datasets and scalable BI support.