Job Description:

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

Disclaimer:

This vacancy is being advertised by either Advanced Resource Managers Limited, Advanced Resource Managers IT Limited or Advanced Resource Managers Engineering Limited ("ARM"). ARM is a specialist talent acquisition and management consultancy. We provide technical contingency recruitment and a portfolio of more complex resource solutions. Our specialist recruitment divisions cover the entire technical arena, including some of the most economically and strategically important industries in the UK and the world today. We will never send your CV without your permission. Where the role is marked as Outside IR35 in the advertisement this is subject to receipt of a final Status Determination Statement from the end Client and may be subject to change.