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.