Power BI Developer

Main Purpose

To design, develop, and support enterprise-scale Power BI semantic models, dashboards, and reporting solutions, with a particular focus on semantic model architecture, automated refresh processes, partitioning, governance, and performance optimization.

Key Responsibilities

• Design and develop enterprise-grade Power BI reports, dashboards, and scorecards.
• Build and maintain semantic models using dimensional modelling best practices.
• Develop advanced DAX calculations, calculation groups, and optimization techniques.
• Implement Incremental Refresh and semantic model partitioning strategies.
• Manage large-scale datasets and optimize refresh and query performance.
• Develop and support Python-based processes used to trigger semantic model refreshes and processing.
• Integrate Power BI with orchestration and scheduling frameworks.
• Implement Row-Level Security (RLS), governance controls, and access management.
• Support Power BI Premium/Fabric capacity management.
• Troubleshoot refresh failures, gateway issues, and performance bottlenecks.
• Implement CI/CD pipelines and deployment automation for Power BI assets.

Skills and Experience

• Essential Expert Power BI Desktop and Power BI Service experience.
• Extensive experience developing enterprise semantic models.
• Advanced DAX, semantic modelling, and performance tuning skills.
• Strong understanding of VertiPaq, composite models, aggregations, and query optimization.
• Hands-on experience implementing Incremental Refresh and dataset partitioning.
• Experience using XMLA endpoints, Tabular Editor, and DAX Studio.
• Strong SQL expertise and dimensional modelling knowledge.
• Experience with large-scale analytical platforms.
• Strong Python scripting experience supporting automated semantic model refresh processes.
• Experience with PowerShell, Power BI REST APIs, and administration.
• Experience implementing DevOps and CI/CD pipelines.
• Knowledge of Power BI Premium and/or Microsoft Fabric.
• Preferred Risk Reporting or Financial Services experience.
• Familiarity with Snowflake data consumption from Power BI.
• Experience with Control-M or enterprise scheduling platforms.
• Exposure to Azure Data Platform technologies and dbt.