Country/Region:  GB

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

Location: Hybrid – London / Remote

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.