Power BI Consultant; SC cleared, SSRS, Azure Maps, Azure Data Services, Report Builder

Power BI Consultant; SSRS, Azure Maps, Azure Data Services, Report Builder

• Role: Contract
• Clearance Level: SC Cleared (Must be Active, used in the last one year)
• Contract rate: £450 per day Inside IR35
• Base Location: Hybrid, 2-3 days a week from London

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.
• Experience in enterprise reporting environments.
• Knowledge of Azure Data Services and integration patterns.
• Awareness of accessibility and compliance standards in reporting.

Desirable Skills

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

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.