Data Engineer Microsoft Fabric Oak Brook

Data Engineer, Microsoft Fabric (Mid-Level)

Location: Hybrid, 3-4 days a week onsite (2001 Spring Road, Suite 400, Oak Brook, IL 60523)

Employment type: Contract with plans to extend long-term.

Interview Process: 2 steps, first virtual, second in-person onsite

Position summary

We're seeking a mid-level 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.

Responsibilities

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 qualifications

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 qualifications

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

Success measures (first year)

Delivers pipelines from source to Gold layer end to end with minimal supervision

Owns a defined set of enterprise KPIs with documented definitions and reconciliation to source

Improves data quality and refresh reliability on existing workflows

Contributes to governance and CI/CD standards across the platform