Power BI Lead

Summary:

Key Responsibilities

• Semantic models, star schemas, DAX frameworks, and composite models for enterprise Power BI solutions

• Design Microsoft Fabric workloads - Lakehouse, Warehouse, Dataflow Gen2, Direct Lake connectivity

• Build CI/CD pipelines using Azure Dev Ops (PBIP format) across Dev/QA/Prod tiers

• Implement RLS, OLS, and sensitivity label policies for compliance

• Lead discovery workshops and serve as senior BI advisor to CDO/CTO-level stakeholders

• Evaluate and recommend emerging BI tooling including Power BI MCP server, Fabric Data Agent, and AI-assisted analytics workflows

Qualifications

• Consulting or professional services background strongly preferred - client-facing delivery experience is a key differentiator for this role

• 6+ years in BI/analytics with a primary focus on Power BI; 3+ years architecting Power BI solutions at enterprise scale

• Deep expertise in DAX, M query, calculation groups, field parameters, and composite models

• Hands-on Microsoft Fabric experience (One Lake, Lakehouse, Data Warehouse)

• Experience managing Power BI Premium or Microsoft Fabric capacity (F-SKUs/P-SKUs), including performance tuning and capacity planning at scale

• Azure Dev Ops CI/CD, XMLA endpoints, REST API automation, PBIP format

• Azure data platform familiarity: ADF, Synapse, Azure SQL;
Databricks and Snowflake a plus

• Familiarity with Power BI MCP server and AI-assisted analytics workflows (e.g., Claude integration, Fabric Data Agent) is a plus

• Microsoft certifications preferred: DP-600, PL-300; SQLBI Mastering DAX/Tabular a plus