Power BI Developer
6-Month contract - Inside IR35 - market rate
London based - hybrid working - 3 days a week onsite
Banking sector
Role:
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.
Responsibilities:
- 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.
Skills & 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 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 & administration.
- Experience implementing DevOps 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
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.