16995 - Power BI Developer - 16995 - Ministry of Justice

Descriptions & requirements

Job description

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.

Additional Information

Working Arrangements & Further Information

The MoJ offers Hybrid Working arrangements where business need allows. This is an informal, non-contractual form of flexible working that blends working from your base location, different MoJ sites and / or from home (please be aware that this role can only be worked in the UK and not overseas). All employees will be expected to spend a minimum of 60% of their working time in an office, subject to local estate capacity.

Some roles will not be suitable for Hybrid Working. Similarly, Hybrid Working will not suit everyone’s circumstances. Arrangements will be discussed and agreed with the successful candidate(s) and subject to regular review.

For nationally advertised role: all successful candidates will be appointed to the nearest viable office nearest to their home postcode and on its respective pay scale. This will be at either a HQ building (subject to desk allocation, a Justice Collaboration Centre (JCC) or a Justice Satellite Office (JSO) – See Map. All employees will be expected to spend a minimum of 60% of their working time in an office, subject to local estate capacity).

For current MoJ employees, your base location will need to be changed to the nearest viable office (to your home postcode), either at a HQ building, JCC or JSO within the National Office Network and moved its location’s respective pay scale (any legacy arrangements/locations will need to be amended).

Some of MoJ’s terms and conditions of service are changing as part of Civil Service reform. The changes will apply to staff joining MoJ who are new to the Civil Service. Staff joining MoJ from other civil service employers will transfer onto the new MoJ terms if they are already on 'modernised' terms in their current post or onto 'unmodernised' MoJ terms if they are on 'unmodernised' terms at their current post. Details will be available if an offer is made.

MoJ candidates who are on a specialist grade, will be able to retain their grade on lateral transfer.

All candidates who are currently in receipt of Mark Time / Pay Protection should ensure they are familiar with the new policy on permanent and temporary promotion which can be found on the employee intranet.

Flexible working hours

The Ministry of Justice offers a flexible working system in many offices. Standard full time working hours are 37 hours per week. MoJ welcomes part-time, flexible and job-sharing working patterns, where they meet the demands of the role and business needs. All applications for part-time, flexible and job-sharing working patterns will be considered in accordance with the MoJ’s Flexible Working policy.

Benefits

The MoJ offers a range of benefits:

Annual Leave

Annual leave is 25 days on appointment and will increase to 30 days after five years’ service.

There is also a scheme to allow qualifying staff to buy or sell up to three days leave each year. Additional paid time off for public holidays and 1 privilege day. Leave for part-time and job share posts will be calculated on a pro-rata basis.

Pension

The Civil Service offers a choice of pension schemes, giving you the flexibility to choose the pension that suits you best.

Training

The Ministry of Justice is committed to staff development and offers an extensive range of training and development opportunities.

Networks

The opportunity to join employee-run networks that have been established to provide advice and support and to enable the views of employees from minority groups to be expressed direct to senior management. There are currently networks for employees of minority ethnic origin, employees with disabilities, employees with caring responsibilities, women employees, and lesbian, gay, bisexual and transgender employees.

Support

A range of ‘Family Friendly’ policies such as opportunities to work reduced hours or job share.
Access to flexible benefits such as voluntary benefits, retail vouchers and discounts on a range of goods and services.
For moves to or from another employer or moves across the Civil Service this can have implications on your eligibility to carry on claiming childcare vouchers. You may however be eligible for alternative government childcare support schemes, including Tax Free Childcare. More information can be found on www.GOV.UK or Childcare Choices. You can determine your eligibility at https://www.childcarechoices.gov.uk/.
Paid paternity, adoption and maternity leave.
Free annual sight tests for employees who use computer screens.

Working for the Civil Service

The Civil Service Code sets out the standards of behaviour expected of civil servants.

We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles. Should you feel that the recruitment process has breached the recruitment principles you are able to raise a formal complaint in the following order

To Transformative Business Services (0345 241 5359 (Monday to Friday 8am - 6pm) or e mail moj-recruitment-vetting-enquiries@resourcing.soprasteria.co.uk);
To Ministry of Justice Resourcing team (resourcing-management-office@justice.gov.uk);
To the Civil Service Commission (details available here)

As a Disability Confident employer, MoJ are committed to providing everyone with the opportunity to demonstrate their skills, talent and abilities, by making adjustments throughout all elements of the recruitment process and in the workplace. MoJ are able to offer an interview to disabled candidates who meet the minimum selection criteria, except in a limited number of campaigns.

For more information on applying for a role as a candidate with a disability or long-term condition, please watch our animated videos.

You will be able to request reasonable adjustments to the recruitment process within the application form. If you need additional help completing the application form, please contact the TBS Recruitment Enquiries Team.

Diversity & Inclusion

The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan and the Civil Service Diversity and Inclusion Strategy.

A Great Place to Work for Veterans

The "Making the Civil Service a Great Place to work for veterans" initiative includes a guaranteed interview scheme to those who meet the minimum criteria to provide eligible former members of the Armed Forces with opportunities to secure rewarding jobs. Allowing veterans to continue to serve their country, and to bring highly skilled individuals with a broad range of experience into the Civil Service in an environment, which recognises and values your previous service in the Armed Forces.
For further details about the initiative and eligibility requirements visit: https://www.gov.uk/government/news/making-the-civil-service-a-great-place-to-work-for-veterans

Redeployment Interview Scheme

Civil Service departments are expected to explore redeployment opportunities before making an individual redundant. The MoJ is committed, as part of the Redeployment Interview Scheme, to providing opportunities to those who are 'at risk of redundancy'.

MoJ is able to offer an interview to eligible candidates who meet the minimum selection criteria, except in a limited number of campaigns. Candidates will not be eligible for the Redeployment Interview Scheme if they are applying on promotion.

Civil Service Nationality Rules

This job is broadly open to the following groups:

UK nationals
nationals of the Republic of Ireland
nationals of Commonwealth countries who have the right to work in the UK
nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window) https://www.gov.uk/settled-status-eu-citizens-families
nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Further information on nationality requirements (opens in a new window) https://www.gov.uk/government/publications/nationality-rules

Reserve list

A reserve list may be held for up to 12 months from which further appointments may be made for the same or similar roles.

Contact Information

MoJ:

If you require any assistance please call 0345 241 5359 (Monday to Friday 8am - 6pm) or e mail moj-recruitment-vetting-enquiries@resourcing.soprasteria.co.uk

Please quote the job reference 16995

HMPPS

If you require any assistance please call 0345 241 5358 (Monday to Friday 8am - 6pm) or e mail moj-recruitment-vetting-enquiries@resourcing.soprasteria.co.uk

Please quote the job reference

Allowance

Roles will be recruited using a combination of Government Digital and Data (GDD) Profession Capability Framework and Success Profile Frameworks. Using GDD we will then determine if you will be paid an additional allowance on top of your basic salary.

Ministry of Justice

16995 - Power BI Developer

General Information

Descriptions & requirements

Job Description Attachment

Select new file

Application form stage assessments

Interview stage assessments

Other Assessments