Power BI Consultant - SC cleared
Posted 3 days ago by Mastek
Negotiable
Undetermined
Hybrid
London Area, United Kingdom
Summary: The Power BI Consultant role involves a 3–4 month contract focused on advanced Paginated and SSRS reporting for the EDP project. The consultant will collaborate with engineering and data teams to create impactful reporting solutions that meet complex requirements. Expertise in Report Builder, Power BI Paginated Reports, and Azure Maps is essential for success in this position. Immediate contribution to project deliverables is expected from the ideal candidate.
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.
Key Skills:
- 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.
Salary (Rate): undetermined
City: London
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
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.