Job role: Data Engineer

Location: National with occasional travel to London and other locations

When you join HM Courts & Tribunals Service (HMCTS) as a Data Engineer you’ll play a pivotal role in supporting a diverse range of senior leaders as they make important, strategic decisions. You’ll be a key member of the Data, Analysis and Insight team, and support the organisation responsible for the administration of criminal, civil and family courts and tribunals in England and Wales.

You’re committed to public service and want to make a difference to people’s lives by supporting the professionals who deliver justice and are dedicated to supporting our service users and colleagues.

Work with modern technology as you build your career

As part of our Data Strategy, we’ve invested in a cloud-based strategic data platform to transform the way we work with data. It also allows us to add more value to our organisation and provide a more complete service to the public. This platform is now technically complete, so we’re looking for enthusiastic and motivated people to join our team and help us make the most of the new technology.

Help us deliver a fair and accessible justice system for all

As Data Engineer you’ll have a number of important responsibilities - these include contributing to the delivery of the physical data models and views that will enable data exploiters to visualise and enable metrics, and provide analysis for data science projects. You will assist in the development of data models and transformation processes for new and existing sources will be, as well as working with subject matter experts to develop and implement the business rules and definitions underpinning measures, metrics and KPIs.

You’ll collaborate with operational colleagues, internal project teams and other stakeholders to gather, refine and deliver requirements that meet our business needs. In addition, you’ll work alongside the technical lead for one or more of our jurisdictions to help embed improved ways of working with data across the wider team, work that will include the automation of manual tasks and data assurance. 

Apply all your skills as you increase your knowledge and expertise

To be a success in this vital role you’ll have some experience of ETL and data integration, including integrating data from various source systems, transforming data against required business rules, models and analysis requirements, and loading data in various storage platforms. You should also have an understanding of developing new and existing sources in a data warehouse environment and of working with dimensional modelling and relational database design and concepts such as Kimball, and be willing to deepen this understanding whilst undertaking the role. We’ll also look for SQL skills and some experience of working with databases.

Some experience with parameterised code in either a programming or scripting language such as Python/Spark, would be desirable. In addition, experience of using cloud-based technologies such as Azure Data Factory, Synapse or Fabric would be a bonus.

Enjoy a healthy work/life balance with our great range of benefits

When you join us, you’ll be making an important contribution to HM Courts and Tribunals Service - but how will we help you in return?

You’ll have access to a wide range of tools that will enable you to develop and enhance your data skills - these include Microsoft Azure training courses via our partnership with Microsoft, online training such as DataCamp and Pluralsight, webinars, taught courses, one-to-one coaching and access to a large peer-support network. And of course you’ll enjoy a generous holiday entitlement and a Civil Service pension. We also understand the importance of a healthy work/life balance and with this in mind we offer flexible working schemes, paid maternity and paternity leave and excellent childcare benefits.

The vital work we do takes a diverse community of colleagues with different skills and backgrounds, cultures and identities. We support every individual, so you’ll always know you’re welcome and valued. We have strong and proactive staff networks and reasonable adjustments for those who need them to help everyone achieve their potential.

Proud to Serve. Proud to keep justice going.