Data Engineer, Microsoft Fabric (Mid-Level) - Oak Brook IL - Hybrid Onsite

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

• 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