Data Engineer (Microsoft Fabric)

MMD Services; 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

We are seeking a Data Engineer to build and maintain our enterprise data platform on Microsoft Fabric. You'll bring data from systems like Oracle Fusion, Workday, and Salesforce into a governed Lakehouse/Warehouse and deliver the trusted datasets and KPIs that finance, operations, and executive teams rely on. You'll work independently on defined projects and partner closely with analysts and business stakeholders.

What You'll Do

• Design, build, and maintain Microsoft Fabric pipelines that ingest data from Oracle Fusion, Workday, Salesforce, and other enterprise systems
• Develop and manage Lakehouse and Warehouse solutions using Medallion Architecture (Bronze, Silver, Gold)
• Create and maintain enterprise KPIs and metrics, including Revenue, EBITDA, Labor %, Food Cost %, Guest Count, and Same Store Sales
• Build semantic models and curated datasets that serve 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 team engineering standards

Required

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

Preferred

• Experience integrating ERP or HCM data (Oracle Fusion, Workday) and CRM data (Salesforce)
• Background in restaurant, hospitality, retail, or multi-location operations analytics
• Experience defining financial and operational metrics with finance teams
• Prior experience with Azure Synapse, Azure Data Factory, or Databricks that transfers to Fabric
• Microsoft certification such as DP-600 (Fabric Analytics Engineer) or DP-700 (Fabric Data Engineer)
• Bachelor's degree in Computer Science, Information Systems, or equivalent experience

---

MMD Services Inc. is an equal opportunity employer. All applicants are considered for all positions without regard to race, religion, color, sex, gender, sexual orientation, pregnancy, age, national origin, ancestry, physical/mental disability, medical condition, military/veteran status, genetic information, marital status, ethnicity, alienage or any other protected classification, in accordance with applicable federal, state, and local laws.