Data Engineer, Microsoft Fabric | Lakehouse & KPIs

MMD Services, Inc.; Chicago (IL); On-site; USD 110,000 - 140,000; Full time

Job summary

MMD Services, Inc. seeks a Data Engineer to build and maintain our enterprise data platform on Microsoft Fabric. You will ingest data from Oracle Fusion, Workday, Salesforce, and other sources, delivering trusted datasets and KPIs for finance, operations, and executives.

You will design pipelines, implement governance and security, and partner with analysts to translate business needs into scalable data solutions. This role requires hands-on Fabric experience and strong SQL/PySpark skills.

Qualifications

• 3–5 years of experience in data engineering or analytics engineering.
• Hands-on experience with Microsoft Fabric components (Data Factory, Lakehouse, Warehouse, Dataflows Gen2, Pipelines).
• Strong SQL, Spark SQL, PySpark, and Python abilities.
• Data modeling expertise: star schema, fact and dimension design, Kimball methodology.
• Power BI semantic models and DAX knowledge.
• Working knowledge of OneLake and Delta tables.
• ETL/ELT development and enterprise data integration experience.
• Governance and security: Microsoft Purview, RLS/CLS.
• Proficiency with Git, Azure DevOps, and CI/CD practices.

Responsibilities

• Design, build, and maintain Fabric pipelines ingesting data from Oracle Fusion, Workday, Salesforce, and other systems.
• Develop and manage Lakehouse and Warehouse solutions using Medallion Architecture (Bronze, Silver, Gold).
• Create and maintain enterprise KPIs and metrics (Revenue, EBITDA, Labor %, Food Cost %, Guest Count, Same Store Sales).
• Build semantic models and curated datasets serving as a single source of truth for reporting and analytics.
• Implement data quality, validation, reconciliation, security, and governance controls.
• Support Power BI reporting, self-service analytics, and AI/Copilot-ready data solutions.
• Participate in code reviews, document pipelines and models, and follow engineering standards.

Skills

SQL

Spark SQL

PySpark

Python

Data modeling

Kimball methodology

Power BI

DAX

Microsoft Fabric

OneLake

Delta tables

ETL/ELT

Data governance

Git

Azure DevOps

CI/CD

Education

Bachelor's degree

Tools

Microsoft Fabric

Job description

MMD Services, Inc. seeks a Data Engineer to build and maintain our enterprise data platform on Microsoft Fabric. You will ingest data from Oracle Fusion, Workday, Salesforce, and other sources, delivering trusted datasets and KPIs for finance, operations, and executives.

You will design pipelines, implement governance and security, and partner with analysts to translate business needs into scalable data solutions. This role requires hands-on Fabric experience and strong SQL/PySpark skills.