Power BI Developer

Power BI Developer

6-Month contract - Inside IR35 - market rate

London based - hybrid working - 3 days a week onsite

Banking sector

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

• Designing and developing enterprise-grade Power BI reports, dashboards and scorecards.
• Building and maintaining semantic models using dimensional modelling best practices.
• Developing advanced DAX calculations, calculation groups and optimisation techniques.
• Implementing Incremental Refresh and semantic model partitioning strategies.
• Managing large-scale datasets and optimising refresh and query performance.
• Developing and supporting Python-based processes used to trigger semantic model refreshes and processing.
• Integrating Power BI with orchestration and scheduling frameworks.
• Implementing Row-Level Security (RLS), governance controls and access management.
• Supporting Power BI Premium/Fabric capacity management.
• Troubleshooting refresh failures, gateway issues and performance bottlenecks.
• Implementing CI/CD pipelines and deployment automation for Power BI assets.

• 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 Verti Paq, 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 Power Shell, Power BI REST APIs & administration.
• Experience implementing Dev Ops and CI/CD pipelines.
• Knowledge of Power BI Premium and/or Microsoft Fabric.

• Excellent communication & 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, the ability to demonstrate sound judgement

• 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.