Job title: Senior Data Engineer

Directorate: Strategy, Analysis and Change

Location: National, with occasional travel to London and other sites.

This post may be eligible for an allowance based on location. The allowance can be up to £9,743 per annum.

This role aligns with Data engineer from the Government Digital and Data Framework

Important Information

Occasional travel to London and other locations will be required.

Due to the nature of the role, part-time requests will be considered at a minimum of 30 hours. Flexible working will be considered on a case-by-case basis.

About us

HM Courts & Tribunals Service (HMCTS) is responsible for the administration of criminal, civil and family courts and tribunals in England and Wales. Our roles support our service users and colleagues, where people and businesses access potentially life-changing justice. We’re looking for individuals who are committed to public service and want to make a difference in people’s lives in delivering justice. You will contribute directly to the delivery of our ambitious Data Strategy, supporting efforts to modernise and enhance our data capabilities across the organisation.

About the role

The Data, Analysis and Insight team plays 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. In December 2021 we published our Data Strategy, setting out HMCTS’s commitment to becoming a data driven organisation.

HMCTS Data Strategy (publishing.service.gov.uk)

As part of this strategy, HMCTS has invested in a cloud-based strategic data platform to transform the ways in which we work with data and enable us to add more value than ever to the organisation and the public. This platform is now technically complete, and we are looking for enthusiastic and motivated individuals to join our team and help us exploit our new technology.

This role will be based in our Data Management and Engineering team responsible for holding, curating, and protecting our data to drive value for our organisation both now and into the future.

Your role as the Senior Data Engineer encompasses several key aspects (but not limited to):

Contribute to the delivery of physical data models and views required for data exploiters to enable visualisation 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.

Who are we looking for? (Person Specification)

The ideal candidate for this position should demonstrate:

Good understanding of Data Warehouse techniques, including dimensional data modelling and relational database design and concepts (e.g. Kimball).
Strong SQL skills and experience working with databases such as Oracle or Microsoft SQL Server.
A proactive and motivated approach to problem-solving, with strong skills in troubleshooting complex data issues and delivering effective, scalable solutions
Experience of 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.

What We Offer

At HMCTS, we are committed to investing in your professional development and wellbeing. Benefits include:

Competitive salary and Civil Service pension scheme.
Generous annual leave entitlement.
Flexible working arrangements and excellent parental leave policies.
Supportive, inclusive workplace culture with active staff networks and diversity initiatives.

Development opportunities

You will have access to a wide range of tools to continually develop and enhance your Data skills, such as access to Microsoft Azure training courses via our partnership with Microsoft, online training such as DataCamp or Pluralsight, webinars, courses, one-to-one coaching and access to a large peer-support network.

Application Process

To apply for this role, please submit a CV and Statement of Suitability of no more than 1000 words setting out evidence and examples of how you meet the person specification of the role.

Your CV should

Be succinct and clear
Be factually accurate – You must ensure that any evidence submitted as part of your application, including your CV and statement of suitability 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.
Include your qualifications, highlighting any modules or accreditation relevant to the role
Include your relevant experience, providing dates.
Provide detail – we are interested in how you have used different tools to solve problems.