Log In
Sign Up
East Midlands (England), East of England, London (region), North East England, North West England, Scotland, South East England, South West England, Wales, West Midlands (England), Yorkshire and the HumberJob SummaryThis position is based NationallyJob DescriptionHM Courts and Tribunals ServiceDirectorate: Digital Technology Services (DTS)Pay Band: SEOJob Title: Power BI DeveloperLocation: NationalTravel 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 futureTerm: PermanentInterview: Video conference via TeamsImportant 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-serviceJob 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-serviceYou can find more information about our ways of working in the HMCTS Way: https://hmcts.github.ioTechnologies 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 sourcesAzure 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 gatewaysPower Platform (e.g. Power Automate) to enable alerts, workflow integration and operational insightMonitoring 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 SpecificationWe’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 InfluencingDeveloping self and othersWorking TogetherMaking Effective DecisionsTechnical – 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.HM Courts and Tribunals ServiceDirectorate: Digital Technology Services (DTS)Pay Band: SEOJob Title: Power BI DeveloperLocation: NationalTravel 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 futureTerm: PermanentInterview: Video conference via TeamsReserve 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.Person specificationPlease Refer To Job DescriptionBehavioursWe’ll assess you against these behaviours during the selection process:Communicating and InfluencingDeveloping Self and OthersWorking TogetherMaking Effective DecisionsTechnical skillsWe’ll assess you against these technical skills during the selection process:Capability Skill 1: Programming and build (data and analytics engineering)Alongside your salary of £42,914, HM Courts and Tribunals Service contributes £12,432 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.Access to learning and developmentA working environment that supports a range of flexible working options to enhance your work life balanceA working culture which encourages inclusion and diversityA Civil Service pension with an employer contribution of 28.97%Annual LeavePublic HolidaysSeason Ticket AdvanceFor more information about the recruitment process, benefits and allowances and answers to general queries, please click the below link which will direct you to our Candidate Information Page.Link: https://justicejobs.tal.net/vx/candidate/cms/About%20the%20MOJArtificial intelligenceArtificial intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, as your own) applications may be withdrawn and internal candidates may be subject to disciplinary action. Please see our candidate guidance (opens in a new window) for more information on appropriate and inappropriate use.Selection process detailsThis vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours, Experience and Technical skills.https://justicejobs.tal.net/vx/candidate/cms/About%20the%20MOJFeedback will only be provided if you attend an interview or assessment.This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours, Experience and Technical skills.SecuritySuccessful candidates must undergo a criminal record check.Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window).See our vetting charter (opens in a new window).People working with government assets must complete baseline personnel security standard (opens in new window) checks.Successful candidates must undergo a criminal record check.Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window).See our vetting charter (opens in a new window).People working with government assets must complete baseline personnel security standard (opens in new window) checks.Nationality requirementsThis Job Is Broadly Open To The Following Groups:UK nationalsnationals of the Republic of Irelandnationals of Commonwealth countries who have the right to work in the UKnationals 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)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 2020Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil ServiceFurther information on nationality requirements (opens in a new window)Working for the Civil ServiceThe Civil Service Code (opens in a new window) 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 (opens in a new window).The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.The Civil Service Code (opens in a new window) 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 (opens in a new window).The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.Diversity and InclusionThe 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 (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window).This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative.Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.Contact point for applicantsJob Contact :Name : SSCL Recruitment Enquiries TeamEmail : moj-recruitment-vetting-enquiries@resourcing.soprasteria.co.ukTelephone : 0345 241 5359Recruitment teamEmail : moj-recruitment-vetting-enquiries@resourcing.soprasteria.co.ukFurther informationAppointment to the Civil Service is governed by the Civil Service Commission’s Recruitment Principles. If you feel a department has breached the requirement of the Recruitment Principles and would like to raise this, please contact SSCL (Moj-recruitment-vetting-enquiries@gov.sscl.com) in the first instance. If the role has been advertised externally (outside of the Civil Service) and you are not satisfied with the response, you may bring your complaint to the Commission. For further information on bringing a complaint to the Civil Service Commission please visit their web pages: http://civilservicecommission.independent.gov.uk/civil-service-recruitment/complaints/https://jobs.justice.gov.uk/careers/JobDetail/16995?entityId=16995
