Senior Data Engineer (Ref: 88647)
HM Courts and Tribunals Service
About the job
Job summary
These positions are based nationally.Job description
Directorate: HMCTS Strategy, Analysis and Planning
Job Title: Senior Data Engineer
About HMCTS
HM Courts & Tribunals Service (HMCTS) is responsible for the administration of Criminal, Civil and Camily 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/lang-en-GB/brand-2/user-24760/xf-483b3083a493/wid-2/ats/recruiter/opportunities/vacancy/88647
Background
The Analysis & Performance 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 Descriptio
What will the successful candidate be doing?
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.
What are we looking for? (Person Specification)
The ideal candidate for this position should demonstrate:
Essential
Technical expertise
Experience of 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 platforms.
Experience of working with data and databases, ideally involving the development of new and existing data sources in a Data Warehouse
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 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 skills, such as: access to Microsoft Azure training courses via our partnership with Microsoft, online training such as DataCamp or Pluralsight, webinars, taught courses, one-to-one coaching and access to a large peer-support network.
About our benefits
We reward our people for their hard work and commitment. We have a number of family friendly and flexible working polices that will help you achieve a healthy work- life balance. In addition, we offer a range of employee benefits which include generous annual leave, a highly competitive contributory pension scheme, childcare benefits, season ticket and bicycle loans.
Proud to Serve. Proud to keep justice going.
Person specification
Please refer to job description.Benefits
Alongside your salary of £39,868, HM Courts and Tribunals Service contributes £10,804 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
https://justicejobs.tal.net/vx/candidate/cms/About%20the%20MOJFeedback 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
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.