HM Courts and Tribunals Service – Power BI Developer
Directorate: Digital Technology Services (DTS)
Pay Band: SEO
Location: National – office based 3 days per week in any HMCTS Office (travel between sites may be required. Frequency may increase in the future)
Term: Permanent
Interview: Video conference via Teams
Important salary details – new recruits to the Civil Service joining HMCTS are expected to join at the band minimum. Existing Civil Servants applying on promotion will usually be appointed on the salary minimum of the new pay band, or receive an increase of 10 % on the current base salary, whichever is higher, up to the new band maximum. The role is aligned to the Data Roles Family and is a Data Engineer role at Senior level, but carries the title Power BI Developer within DTS.
Overview
These are exciting times at HM Court and Tribunals Service (HMCTS). We support the judiciary across England and Wales to deliver justice by running courts and tribunals and processing outcomes. We are looking for talented people to help us achieve our ambitions. The role will have challenging, important and rewarding aspects.
DTS is a specialist technology directorate that provides support to HMCTS in the use of IT and Digital. It offers a supportive environment with training opportunities, flexible working, an inclusive culture, and a place where your opinion is valued.
Responsibilities
As a Power BI Developer you will work with a wide range of stakeholders such as performance leads, service owners, product managers, delivery managers, analysts and engineering managers, all of whom share a vision for improving public services through better insight, monitoring and performance management. You will turn complex data into clear, actionable dashboards and metrics that support decision making and continuous improvement.
You will develop and support performance dashboards and reporting products that help teams understand service health, trends and outcomes. These dashboards will be used to monitor operational performance, track key performance indicators (KPIs) and highlight risks and opportunities for improvement.
Key Responsibilities
* Design, build and maintain Power BI dashboards and reports focused on service performance, operational metrics and monitoring.
* Work with stakeholders to understand performance questions, define KPIs and translate user needs into clear reporting requirements.
* Create and optimise semantic models and DAX measures that are accurate, performant and reusable across dashboards.
* Develop data transformations and refresh processes, ensuring data quality, lineage and appropriate documentation.
* Implement role‑based access control (RLS) and follow MoJ information security and data handling policies, including secure management of sensitive data.
* Monitor and improve the performance, reliability and usability of dashboards, including refresh performance and user adoption.
* Support and maintain reporting products in live environments, investigating issues and fixing faults using modern troubleshooting techniques.
* Apply user‑centred and accessibility‑minded design principles so dashboards are easy to interpret and usable by a broad range of colleagues.
* Work collaboratively in agile delivery teams, contributing to planning, estimation, prioritisation and continuous improvement.
* Guide and advise others on Power BI good practice (including modelling, DAX and visualisation standards) and mentor more junior colleagues.
* Work with engineers and analysts to integrate new data sources and improve end‑to‑end observability and performance monitoring.
* Contribute to procurement and assurance activities where required, and identify, record and escalate technical debt and risks.
Core Analytics Stack
* Power BI Desktop and Power BI Service to develop, publish and maintain performance dashboards and reports.
* DAX and Power Query (M) to create robust measures, calculations and data transformations.
* Data modelling & architecture using star schema design and well‑structured enterprise datasets.
* SQL to query, validate and optimise data from relational data sources.
* Azure Data Platform services (e.g. Azure SQL, Synapse, Data Lake).
* Data pipelines and orchestration tools (e.g. Azure Data Factory).
* Secure connectivity patterns including on‑premises data gateways.
* Power Platform (e.g. Power Automate) to enable alerts, workflow integration and operational insight.
* Monitoring and logging tools to track dataset refresh, report performance and service availability.
* Approved development environments (e.g. Windows or virtual desktop).
About HMCTS
HMCTS is part of the Ministry of Justice. For more information, visit www.gov.uk/government/organisations/hm-courts-and-tribunals-service. Our ways of working are described in the HMCTS Way: https://hmcts.github.io.
#J-18808-Ljbffr