About this role
Salary: £45,000 - 80,000 per year
Requirements: 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 optimisation.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.Excellent communication and interpersonal skills.A proactive, motivated approach.The ability to operate with urgency and prioritise work accordingly, managing large workloads and tight deadlines.Strong decision-making skills and the ability to demonstrate sound judgement.Risk Reporting or Financial Services experience is preferred.Familiarity with Snowflake data consumption from Power BI is preferred.Experience with Control-M or enterprise scheduling platforms is preferred.Exposure to Azure Data Platform technologies and dbt is preferred. Responsibilities: Design, develop and support enterprise-scale Power BI semantic models, dashboards and reporting solutions for Risk Reporting.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 optimisation techniques.Implement Incremental Refresh and semantic model partitioning strategies.Manage large-scale datasets and optimise 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. Technologies: AzureCI/CDDAXDevOpsFabricSupportPower BIPowerShellPythonRESTSQLSecuritySnowflakedbtCloudARM More:
We are offering a 6-month contract role inside IR35 at market rate, based in London with hybrid working and three days onsite each week. We work within the banking sector and are seeking someone to help us deliver enterprise-scale Power BI semantic models, dashboards and reporting solutions for Risk Reporting, with a strong focus on architecture, automated refresh processes, partitioning, governance and performance optimisation. Our team values strong communication, proactive delivery and sound judgement in a fast-paced environment.
last updated 30 week of 2026