HM Courts and Tribunals Service
Directorate: Digital Technology Services (DTS)
Pay Band: SEO
Job Title: Power BI Developer
Location: National
Travel between sites may be required and successful applicants will be expected to be office based 3 days per week in any HMCTS Office (subject to business availability). The 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 percent on the current base salary, whichever is higher (This is restricted to the pay maximum of the new band).
GDD:
Government Digital and Data (GDD) Profession Capability Framework and Success Profiles Frameworks. Using GDD we will then determine if you will be paid an additional allowance, on top of your basic salary. This role is aligned to the Data Roles Family, is a Data Engineer role at Senior level, but carries the title Power BI Developer within DTS.
Introduction:
These are exciting times at HM Court and Tribunals Service (HMCTS). As an agency of the MoJ, we support the judiciary across England and Wales to deliver justice by running courts and tribunals and processing outcomes, and we are looking for talented people to help us achieve our ambitions. It will be challenging, important and rewarding.
HMCTS Digital and Technology Services (DTS) is a specialist technology directorate which provides support to HMCTS in the use of IT and Digital.
DTS is creating a place in which it is great to do work and part of our offer is brilliant training opportunities and support from expert colleagues. As well as that you’ll find flexible working, an inclusive culture and a place where your opinion is valued.
Please follow the link below for further information about HMCTS. www.gov.uk/government/organisations/hm-courts-and-tribunals-service
Job Description:
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.
You can find more information about HMCTS and the services we deliver here:
www.gov.uk/government/organisations/hm-courts-and-tribunals-service
You can find more information about our ways of working in the HMCTS Way: https://hmcts.github.io
Technologies we rely heavily on (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)
In addition, we use a range of other tools and continue to evolve our approach to performance monitoring, insight and service optimisation to deliver better services to our users.
As a Power BI Developer in HMCTS you will:
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.
Skills & Experience:
Strong experience delivering Power BI dashboards, reports and datasets in a professional environment.
Strong knowledge of data modelling concepts (for example star schema, snowflake schema) and best practice for semantic models.
Strong knowledge of DAX, including performance optimisation, measure design and time intelligence patterns.
Experience using Power Query (M) and building reliable data transformation steps, with an understanding of query folding where applicable.
Good SQL skills and experience working with relational databases and/or data warehouses.
Experience implementing and managing access controls in Power BI (for example workspaces, permissions and row-level security).
Experience working with data refresh strategies (including incremental refresh), gateways and connectivity to multiple data sources.
Understanding of data quality, metadata and documentation, and a commitment to producing maintainable analytical products.
Experience of working in agile delivery teams and collaborating with multidisciplinary stakeholders.
An understanding of common security, privacy and ethical considerations when working with operational and performance data, and how to mitigate risks.
You thrive when you work as part of a team, enjoy learning and helping others, and hold yourself and others to a high standard.
You solve problems in a systematic way and are motivated by making a positive impact on the communities we serve.
Person Specification
We’re seeking a Power BI Developer with the ability to develop and support high-quality performance dashboards and metrics. The ideal candidate will have:
Experience designing and delivering dashboards for performance monitoring, operational insight and KPI reporting.
Strong Power BI skills, including DAX, Power Query and semantic modelling (datasets).
Experience working with SQL and integrating data from multiple sources (for example databases, APIs and files).
Experience of dashboard performance optimisation, including model design, measure optimisation and refresh strategies.
Experience of working with stakeholders to define metrics, validate definitions and ensure dashboards answer real user needs.
An understanding of common security and data handling requirements and how to apply them in reporting solutions.
Application process:
This role will be recruited using a combination of Government Digital and Data (GDD) Profession Capability Framework and Success Profiles Frameworks during the sift and interview process.
Experience - As demonstrated in your application form.
Behaviours - You will be required to provide evidence of the following key behaviours at SEO level. You will be expected to align your answers to the Government Digital and Data (GDD) Capability Framework Government Digital and Data (GDD)
Communicating and Influencing
Developing self and others
Working Together
Making Effective Decisions
Technical - As demonstrated at interview. During the interview, you will be assessed against the Government Digital and Data (GDD) Capability Framework.
Capability Skill 1 - Programming and build (data and analytics engineering)
Technical discussion - As part of the interview, you will be asked to talk through a recent example of your work (e.g. a dashboard/report, semantic model, or dataset design). Any examples should be anonymised and must not include sensitive information.
Use of Artificial Intelligence (AI)
You must ensure that any evidence submitted as part of your application, including your CV, statement of suitability and behaviour examples, are truthful and factually accurate. Please note that plagiarism can include presenting the ideas and experiences of others, or generated by artificial intelligence, as your own.
Level of Clearance - To apply for this role, you will be required to successfully complete Security Clearance (SC) level as a condition of appointment. To meet these requirements, you will normally need to have been resident in the UK for at least 5 years.
Reserve List:
HMCTS run a Reserve List, where candidates who are unsuccessful at interview by only a few points, can be offered other roles, at the same band, for up to 12 months. You will be able to view your status via the application screen. If you have been added to the Reserve List, your status will show either Merit or Reserve list.