Power BI Consultant - SC cleared

Job Title: Power BI Consultant – Paginated/SSRS Reporting (Contractor)

Location: Hybrid – London / Remote

Reporting to: Data Architect – Data & Analytics – CDO – DDAT

Security Clearance: SC Clearance

Role Overview

We are seeking a highly capable Power BI Consultant for a 3–4 month contract engagement to support the EDP project through advanced Paginated and SSRS reporting capabilities. The consultant will work closely with engineering and data teams to deliver high-impact reporting solutions that meet complex formatting, parameterisation, and visualisation requirements.

This role demands hands-on expertise with Report Builder, Power BI Paginated Reports, and Azure Maps, along with a strong understanding of dynamic parameter handling and data-driven subscriptions. The ideal candidate will be able to hit the ground running and contribute immediately to project deliverables.

Key Responsibilities

• Design and implement paginated reports using Report Builder with advanced formatting and layout controls including:
• Pagination control, conditional visibility, repeat on page, page numbering, and conditional formatting.
• Configure dynamic parameter passing via URL to Power BI paginated reports.
• Implement M parameter handling with query folding for performance optimisation.
• Develop rich visualisations beyond tables, including:
• Charts with axes, scale breaks, strip lines, small multiples, gauge indicators, dynamic icons, and embedded images.
• Azure Maps integration for geospatial rendering within paginated reports.
• Design robust parameter frameworks including:
• Default values, cascading parameters, multi-select, 'All' options, and optional parameters.
• Set up and manage data-driven subscriptions and parameter scheduling patterns.

Essential Skills & Experience

• Proven experience with Power BI Paginated Reports and SSRS.
• Strong proficiency in Report Builder and advanced report formatting techniques.
• Deep understanding of Power BI parameterisation and query folding.
• Experience with Azure Maps and geospatial visualisation in reporting.
• Familiarity with data-driven subscriptions and scheduling strategies.
• Ability to work independently and deliver high-quality outputs under tight timelines.

Desirable Skills

• Experience in enterprise reporting environments.
• Knowledge of Azure Data Services and integration patterns.
• Awareness of accessibility and compliance standards in reporting.