Azure Data Engineer Microsoft Fabric & Power BI

McKinsol Consulting Inc
Warrenville, IL, United States
13 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

Microsoft Online Services Continuous Delivery Extract Transform Load (ETL) DevOps Dimensional Modeling Python (Programming Language) Power BI Azure Data Lake SQL Databases Transact-SQL Microsoft Fabric Data Lakes
+5 more
Pyspark Data Analytics Star Schema Data Pipelines Databricks

Job description

This is a standard enterprise-grade Data & Analytics Engineer role with a heavy focus on the Microsoft Cloud Stack.

The ideal candidate manages the entire data lifecycle from raw ingestion to end-user semantic modeling in Power BI.

Core Technical Pillars:

Medallion Architecture & Storage: Architecting Bronze (raw), Silver (cleansed/conformed), and Gold (aggregated star schema) layers using Delta Lake on Microsoft Fabric (OneLake) or Azure Databricks (ADLS Gen2).

Pipeline Development: Building ETL/ELT pipelines with PySpark, SQL, and Microsoft Fabric Data Factory / Notebooks.

Hybrid BI Capabilities: Developing enterprise-grade Power BI semantic models (leveraging Direct Lake mode) and writing complex DAX measures.

DevOps & Governance: Implementing CI/CD pipelines for data workloads and Power BI assets, setting engineering standards, and writing technical documentation.

Requirements

Python, PySpark, SQL (T-SQL), DAX

Compute & Storage

Microsoft Fabric (OneLake, Data Factory, Lakehouse), Azure Databricks, ADLS Gen2, Delta Lake

Data Modeling

Kimball Dimensional Modeling, Star Schema, Fact Tables, Dimension Tables, Medallion Architecture

BI & Analytics

Power BI, Semantic Models (Direct Lake, Import, DirectQuery), DAX Measures

DevOps & Practices

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:17 min

Mapping the maturity roadmap for scaled devops adoption

Dominik Krichbaum Dominik Krichbaum · WWC Europe 2026

4:32 min

Harnessing Spark with Python using PySpark and Py4J

Ayon Roy · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

1:43 min

AWS infrastructure stack and data flow pipeline overview

Artem Volk Artem Volk +1 · WWC 2024

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

3:18 min

Scaling global network engineering through DevOps culture

Stuart Clark · LIVE

Videos

See all

Related articles

See all