Azure Data Engineer Microsoft Fabric & Power BI

McKinsol Consulting Inc
Warrenville, United States of America
11 days ago

Role details

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

Job location

Warrenville, United States of America

Tech stack

Microsoft Online Services
Continuous Delivery
ETL
DevOps
Dimensional Modeling
Python
Power BI
Azure
SQL Databases
T-SQL
Microsoft Fabric
Data Lake
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