Senior Data Engineer: Fabric Lakehouse & BI Lead Chicago

Robotics Technologies

Chicago (IL)

On-site

USD 84,000 - 120,000

Full time

2 days ago
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Robotics Technologies LLC in Chicago, IL seeks a senior Data Engineer to design and deliver data pipelines on Microsoft Fabric. You will lead hands-on builds, mentor junior developers, and serve as the day-to-day technical liaison with business and IT stakeholders.

The ideal candidate owns solution design, drives migration from legacy workloads to Fabric, and defines governance, security, and CI/CD practices for production-ready lakehouse architectures.

Qualifications

  • Own design and delivery of data pipelines and analytics models on Microsoft Fabric.
  • Lead migration of workloads (SSIS, ADF, Synapse, on‑prem SQL Server) to Fabric.
  • Define security and governance: Purview integration.
  • Mentor junior and mid-level developers.
  • Set up CI/CD and deployment pipelines with Fabric Git integration.

Responsibilities

  • Lead design and build of ingestion and transformation pipelines using Fabric Data Factory (pipelines, Dataflows Gen2) and Spark notebooks (PySpark / Spark SQL).
  • Define Lakehouse vs Warehouse choices and the medallion (bronze/silver/gold) layering on One Lake with Delta tables, and document the rationale.
  • Design and optimize Power BI semantic models, including Direct Lake where appropriate, and guide report developers.
  • Lead migration of existing workloads (SSIS, ADF, Synapse, on‑prem SQL Server) to Fabric, including assessment, sequencing, and cutover.
  • Set up and own CI/CD using Fabric Git integration and deployment pipelines (Azure DevOps or GitHub), including branching strategy and promotion standards.
  • Define and enforce security and governance: workspace roles, row/column-level security, sensitivity labels, Purview integration.
  • Own performance and capacity management (CU consumption, throttling, SKU sizing inputs), and tune pipelines, Spark jobs, and queries.
  • Conduct code and design reviews, set engineering standards, and mentor junior and mid‑level developers.
  • Run requirement workshops and demos, estimate and break down work, flag risks early, and keep designs and runbooks current.

Skills

Senior data engineering
Mentoring junior developers
Stakeholder collaboration
Technical leadership

Tools

Microsoft Fabric Data Factory
PySpark
Spark SQL
Delta tables
Power BI
Azure DevOps
GitHub
Purview
One Lake

Job description

Robotics Technologies LLC in Chicago, IL seeks a senior Data Engineer to design and deliver data pipelines on Microsoft Fabric. You will lead hands-on builds, mentor junior developers, and serve as the day-to-day technical liaison with business and IT stakeholders.

The ideal candidate owns solution design, drives migration from legacy workloads to Fabric, and defines governance, security, and CI/CD practices for production-ready lakehouse architectures.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer: Lakehouse & Streaming Pipelines
Senior Data Engineer: Lakehouse & Streaming Pipelines

Robotics Technologies • Atlanta (GA)

On-site
USD 120,000 - 180,000
Senior Data Engineer: Microsoft Fabric Lakehouse
Senior Data Engineer: Microsoft Fabric Lakehouse

Quantum Technologies. LLC • Hartford (CT)

On-site
USD 82,000 - 117,000
Senior Data Engineer - Microsoft Fabric Lakehouse Lead
Senior Data Engineer - Microsoft Fabric Lakehouse Lead

Valiant Technologies LLC • Hartford (CT)

On-site
USD 82,000 - 117,000
Data Engineer: Fabric Lakehouse & Real-Time Analytics
Data Engineer: Fabric Lakehouse & Real-Time Analytics

ExlService Holdings, Inc. • United States

Hybrid
USD 94,000 - 145,000
Senior Data Platform Engineer: Microsoft Fabric & Lakehouse
Senior Data Platform Engineer: Microsoft Fabric & Lakehouse

DistantJob • United States

Remote
USD 120,000 - 160,000
Senior Data Engineer — Microsoft Fabric Lakehouse Lead
Senior Data Engineer — Microsoft Fabric Lakehouse Lead

Ethereum Technologies • Hartford (CT)

On-site
USD 99,000 - 114,000
Fabric Data Architect & Lakehouse Engineer
Fabric Data Architect & Lakehouse Engineer

Wall Street Consulting Services LLC • Center Square (PA)

On-site
USD 140,000 - 210,000
Enterprise Data Architect: Microsoft Fabric & Lakehouse
Enterprise Data Architect: Microsoft Fabric & Lakehouse

Robotic Process Automation LLC • Mount Laurel Township (NJ)

On-site
USD 89,000 - 126,000
ETL Data Platform Engineer - Azure Fabric & Lakehouse
ETL Data Platform Engineer - Azure Fabric & Lakehouse

Robotic Technologies Automation • Redmond (WA)

On-site
USD 140,000 - 190,000
Data Engineer: Microsoft Fabric & Lakehouse Builders
Data Engineer: Microsoft Fabric & Lakehouse Builders

Journeyteam • Draper (UT)

On-site
USD 100,000 - 120,000
Healthcare and dental coverage
401(k) with employer match
Flexible time off
+3