At a Glance
- Tasks: Design and develop enterprise-scale Power BI reports and dashboards for risk reporting.
- Company: Join a leading banking sector firm with a hybrid working model.
- Benefits: Competitive market rate, flexible working, and opportunities for professional growth.
- Other info: 6-month contract with potential for career advancement in a dynamic environment.
- Why this job: Make an impact in the banking sector using cutting-edge Power BI technologies.
- Qualifications: Expertise in Power BI, DAX, SQL, and Python scripting required.
The predicted salary is between 50000 - 65000 £ per year.
- 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 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
- 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.
- #J-18808-Ljbffr
Power BI Developer employer: Advanced Resource Managers Ltd
At Advanced Resource Managers Ltd, we pride ourselves on being an excellent employer, offering a dynamic work culture that fosters collaboration and innovation. Our Suffolk location provides a unique opportunity to engage in significant infrastructure projects while benefiting from professional growth through continuous training and development. We value our employees by providing competitive benefits and a supportive environment that encourages leadership and impactful contributions to major initiatives.
Contact Details:
Advanced Resource Managers Ltd Recruitment Team
