About the job

Job summary

This position is based nationally

Job description

Directorate: HMCTS Strategy, Analysis and Planning

Team: Data, Analysis & Insight Team

Job Title: Lead Data Engineer

About HMCTS

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. If you’re interested in developing a career with a real purpose, please apply.

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://justicejobs.tal.net/vx/appcentre-1/brand-2/tmpwid-5767_a227cc78-1398-40fa-9942-75dd9f0f3974/candidate/so/pm/1/pl/3/opp/89236-89236-Lead-Data-Engineer/en-GB

Background

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.

Job Descriptions

• You will manage and lead a team of data engineering professionals to develop and deliver business-as-usual data, reporting and analytics output.
• You will enable operational data from case management systems to be appropriately shared and disseminated within operational reports, published Management Information or Official Statistics.
• Working closely with Data analysts and scientist colleagues to develop robust processes for managing and automating regular outputs.
• Communicating plans and timescales to enable onward management of key stakeholders and providing regular updates. Feeding into development priorities to understand potential efficiencies and savings in automated processes, to deploy and manage resources appropriately as the organization progresses towards its strategic data solution.
• Developing and implementing new technologies to support robust and accurate data management, ensuring documentation, data dictionaries, and data lineage information is readily available across a range of stakeholders.
• Manage and lead a team to provide robust data models to support required reporting and ensure data processes are efficient and This will include ensuring accuracy of data by implementing a robust quality assurance framework to guarantee decisions and actions are based upon reliable and accurate data.

Key responsibilities

Essential Criteria

• Understanding of managing teams and their priorities, setting expectations to meeting evolving customer needs and ensure BAU
• Lead on 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.
• Extensive working knowledge and experience with ETL (extract, transform and load) 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
• Experience of communicating effectively with operational business and analytical teams to define data requirements, analyse data, and develop data models and metrics that meet requirements.
• Technical lead for departmental work area, this could one or more HMCTS jurisdictions and overall data management framework.
• Demonstrate a passion for continuous improvement for working with data across the wider team, including automation of manual tasks and data
• Analytical skills in, defining, sourcing and capturing data across strategic business systems, processes and areas of an organisation. Confident in defining and documenting data workflows across systems and operations; capturing complex data definitions.
• Proficient in working with data and databases with understanding of Data Warehouse techniques, including dimensional data modelling and relational database design and concepts. (e.g Kimball)
• Exceptional SQL experience and technical database expertise using relational databases such as Oracle Database & PL/SQL or Microsoft T-SQL.
• Experience of code reviews and ensuring coding standards are applied and
• Knowledge of work management/collaboration tools such as MS Teams, Trello and JIRA etc.

Desirable criteria

• Experience of writing parameterised code in either a programming or scripting language such as SQL/PL-SQL and/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 of using CI/CD techniques and processes DevOps/Git repository code promotion and change management experience.

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.

Proud to Serve. Proud to keep justice going.

Person specification

Please refer to job description

Benefits

Alongside your salary of £54,358, HM Courts and Tribunals Service contributes £15,165 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

Things you need to know

Selection process details

This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours and Experience.https://justicejobs.tal.net/vx/candidate/cms/About%20the%20MOJ

Feedback will only be provided if you attend an interview or assessment.

Security

Successful candidates must undergo a criminal record check. People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Nationality requirements

This job is broadly open to the following groups:

• UK nationals
• nationals of the Republic of Ireland
• nationals of Commonwealth countries who have the right to work in the UK
• nationals 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 2020
• Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Further information on nationality requirements (opens in a new window)

Working for the Civil Service

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.