Higher Data Engineer

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: https://www.gov.uk/government/organisations/ministry-of-justice/about/equality-and-diversity.

Directorate: HMCTS Finance, Governance and Performance (within Analysis and Performance)Job Title: Higher Data EngineerSalary: £31,265 to £38,373 (Depending on location and experience)

Number of Jobs: 1

Detail of Reserve List: 12 Months

Pay Band: Higher Executive Officer (HEO)

Post Type: Permanent

Working Pattern: Full Time

Location: National (with hubs in London, Manchester, Birmingham, Leeds); other major HMCTS locations will be considered;

Overview

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:

https://youtu.be/3_xDMTQ6DJQ

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 and the Judiciary with timely, accurate and accessible operational management information and analysis that underpins strategic and operational decisions and Reform activities. To support this, we are currently investing 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.

Job Descriptions

What will the successful candidate be doing?

Support the delivery of physical data models and views required for data exploiters to enable visualization of metrics Support the development of data ingestion and transformation processes for new and existing data sources. Work with subject matter experts to help develop and implement business rules. Assist in ensuring the effective collaboration and communication with colleagues from across the organisation, to gather and help deliver requirements to meet business needs. Support the technical lead for one or more HMCTS jurisdictions. Run regular production processes to enable the provision of data outputs.

Key responsibilities

Essential Criteria

Technical expertise

Some 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 new and existing data sources in a Data Warehouse environment.Understanding of Data Warehousing techniques, such as: dimensional data modelling and relational database design and concepts (e.g. Kimball). SQL coding experience.

Post available on level transfer or on promotion.

Desirable criteria

Some 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. Technical database expertise using relational databases such as Oracle Database & PL-SQL or Microsoft T-SQL.Some experience of building pipelines in cloud technologies such as Azure Data Factory/Databricks.Some 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.

Behaviours

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

Changing and Improving Delivering at Pace Working Together

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

CV giving details of your employment history and your role. Statement of suitability (500 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 three 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”.

Interview 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.