Are you OK with cookies?

We use small files called ‘cookies’ on Some are essential to make the site work, some help us to understand how we can improve your experience, and some are set by third parties. You can choose to turn off the non-essential cookies. Which cookies are you happy for us to use?


Senior Data Engineer – 67270
£37,683 – £48,067


We encourage applications from people from all backgrounds and aim to have a workforce that represents the wider society that we serve. We pride ourselves on being an employer of choice. We champion diversity, inclusion and wellbeing and aim to create a workplace where everyone feels valued and a sense of belonging. To find out more about how we do this visit:


Her Majesty’s Court and Tribunals Service is an agency of the Ministry of Justice and provides the supporting administration for the judiciary across England and Wales.  It delivers services to the public directly in court and tribunal buildings, remotely via business centres and some limited services via the internet. 

HMCTS has embarked on a challenging modernisation programme with the vision to modernise and upgrade our justice system so that it works even better for everyone, from judges and legal professionals, to witnesses, litigants, and the vulnerable victims of crime. This will help consolidate the UK’s position at the forefront of an increasingly competitive international legal market as well as ensuring access to justice for all. This is an exciting time to join the organization and be part of a programme making a real difference.

For more information about our digital transformation, watch the Justice Matters video to see the benefits this £1bn investment is delivering to our customers:

The Finance, Governance and Performance (FGP) directorate provides a pivotal role in supporting a whole range of senior leaders across the business through reporting, analysis and insights. Our work supports the organisation’s overall strategy and empowers senior leaders to make strategic, data driven business decisions.

Within FGP, the Analysis and Performance team plays a key role in making HMCTS a data driven organisation. We provide HMCTS, the Judiciary and external users with timely, accurate and accessible operational management information and analysis that underpins strategic and operational decisions and Reform activities. To support this, we are investing in moving our data and work to in a MS Azure cloud-based strategic data platform, scheduled for delivery by the end of March 2023, and an expansion of our data management and engineering team. This is an exciting opportunity to work with a modern set of data tools and transform our ways of working to enable us to add more value than ever to the organisation and the public.

Job Descriptions

·    Contribute to the delivery of physical data models and views required for data exploiters to enable visualization of metrics and the provision of insightful analysis for data science projects.
·    Develop data ingestion and transformation processes for new and existing data sources.
·    Work with subject matter experts to develop and implement the business rules and definitions underpinning measures, metrics and KPIs.
·    Collaborate effectively with the operational colleagues across the organisation, internal project teams and other stakeholders to gather, refine and deliver requirements to meet business needs.
·    Act as technical lead for one or more HMCTS jurisdictions and overall data management framework.
·    Embed improved ways of working with data across the wider team, including automation of manual tasks and data assurance.

Key responsibilities

Essential Criteria

Technical expertise

·    Experience of ETL and data integration, including exporting data from various source data systems, transforming data against required business rules and data models, or data storage and analysis requirements, and loading data in various storage platforms.
·    Experience of working with data and databases, ideally involving the development of new and existing data sources in a Data Warehouse environment.
·    Good understanding of Data Warehouse techniques, including dimensional data modelling and relational database design and concepts (e.g. Kimball). 
·    Strong SQL experience and technical database expertise using relational databases such as Oracle Database & PL-SQL or Microsoft T-SQL.

Desirable criteria

·    Experience of writing parameterised code in either a programming or scripting language such as PL-SQL or Python/Spark and experienced in delivering metadata driven development processes.
·    Experience of building pipelines in cloud technologies such as Azure Data Factory/Databricks.
·    Experience using Python and Apache Spark (Pyspark, Spark SQL).

Your Development

·    You will have access to a wide range of tools to continually develop and enhance your Data Engineering skills, such as: online training using DataCamp, webinars, taught courses, one-to-one coaching and access to a large peer-support network. 


We’ll assess you against these behaviours (Civil Service Behaviours) during the selection process: 

•    Changing and Improving
•    Working Together
•    Developing Self and Others
•    Delivering at Pace


We will assess on behaviours and technical skills as listed in the advertisment. 

CV giving details of your employment history and the role you have played in projects.
Statement of suitability (1,000 words max) outlining how you meet the Essential and Desirable criteria for the role as described in the Key Responsibilities section above.
For each of the Success Profile Behaviours please provide a 250-word statement of evidence on how your skills, knowledge and experience meet the behavior to Level 3 standard.

If we receive high volumes of applications, we will sift only on the lead behaviour of “Changing and Improving”.


The interview will involve a discussion around the strengths, behaviours & technical skills required for this role. Candidates will also need to prepare a 5-minute verbal presentation (no handouts needed). This will be followed by short follow-up questions. The presentation topic will be sent to candidates before the interview.  

At interview stage there will also be a technical test to assess candidates’ skills in using SQL.

Please note, we anticipate the need for more Data Engineers at this grade as our demands for our work increases. Successful candidates who are not initially appointed but pass the interview may be contacted within 12 months. 

Flexible working options 

HMCTS offers a flexible working system in its offices.

Job Sharing and Reduced Hours 

All applications for job sharing or reduced hours will be treated fairly and on a case by case basis in accordance with the MoJ’s flexible working policy and equality policy. 

Excess Fares and Relocation Allowances 

This job is not eligible for a relocation allowance, but excess fares may be considered in accordance with MoJ’s excess fares allowance policy. 


The national salary range is £37,683 - £41,506, London salary range is £43,647 - £48,067. Your salary will be dependent on your base location.

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). 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 roles, the successful candidate(s) will be appointed to a MoJ office location, which may include their nearest Justice Collaboration Centre or Justice Satellite Office. This will be discussed and agreed on the completion of pre-employment checks.

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.

Flexible working hours

The Ministry of Justice offers a flexible working system in many offices.


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.


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


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


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.


  • 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 GOV.UK or Childcare Choices. You can determine your eligibility at
  • 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

The Civil Service embraces diversity and promotes equal opportunities. 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.

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 SSCL Recruitment Enquiries Team.

We encourage applications from people from all backgrounds and aim to have a workforce that represents the wider society that we serve. We pride ourselves on being an employer of choice. We champion diversity, inclusion and wellbeing and aim to create a workplace where everyone feels valued and a sense of belonging. To find out more about how we do this visit: