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, DirectLake connectivity
• Build CI/CD pipelines using Azure DevOps (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 (OneLake, 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 DevOps 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
