Power BI Developer

Inside IR35 - £630 - £660 P/DRole Title: Power BI DeveloperTeam: Risk ReportingMain 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 ResponsibilitiesDesign 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 ExperienceEssentialExpert 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.PreferredRisk 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.