Senior Data Engineer (Ref: 15991)

Job summary

These positions are based Nationally.

Job description

Job title: Senior Data Engineer

Directorate: Strategy, Analysis and Change

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

Government Digital and Data (GDD) will be used to determine if you will be paid an additional allowance, on top of your basic salary.

This role aligns with Data engineerfrom 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.

You must be able to meet the minimum criteria to apply for or obtain Government Security Check (SC) clearance required to perform the role – this will be obtained once the successful candidate is in post.

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.

Your Statement of Suitability should be no more than 1000 words and should give us real life examples of how your skills and experience match those needed for this role. This is an opportunity to add depth to the best evidence in your CV. Consider addressing particular points in the person specification requirements and key responsibilities. We recommend following the STAR format.

Should we receive a high volume of applications, a pre-sift based on your experience of applying Data Warehouse techniques and data modelling will be conducted before the sift.

Candidates who pass the pre-sift will either:

• ⁠progress to a full sift where all application assessment criteria is then assessed.

• or progress straight to interview.

Interview

If successful at sift you will be invited to a formal interview which will be comprised of two parts:

Technical: You will be asked to provide a presentation of no more than 10 minutes providing technical evidence of your understanding of Dimensional Data Modelling and Data Engineering as aligned to the Government Digital and Data Profession Capability Framework (GDD). The full presentation brief will be sent prior to your interview.

Further information on GDD and the required standards for this post can be found at:

Data engineer - Government Digital and Data Profession Capability Framework

You will also be assessed against the following ‘success profiles’ Civil Service behaviours;

• Changing and Improving
• Delivering at Pace

Further information on Success Profiles and required standards for this post (HEO/SEO equivalent) can be found at: https://www.gov.uk/government/publications/success-profiles

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.

Technical Skills

You will be asked to provide a presentation of no more than 10 minutes providing technical evidence of your understanding of Dimensional Data Modelling and Data Engineering as aligned to the Government Digital and Data Profession Capability Framework (GDD). The full presentation brief will be sent prior to your interview.

Person specification

Please refer to job description.

Behaviours

We'll assess you against these behaviours during the selection process:

• Changing and Improving
• Delivering at Pace

Technical skills

We'll assess you against these technical skills during the selection process:

• Please refer to the Job Description

Benefits

Alongside your salary of £42,914, HM Courts and Tribunals Service contributes £12,432 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

• Access to learning and development
• A working environment that supports a range of flexible working options to enhance your work life balance
• A working culture which encourages inclusion and diversity
• A Civil Service pension with an employer contribution of 28.97%
• Annual Leave
• Public Holidays
• Season Ticket Advance

For more information about the recruitment process, benefits and allowances and answers to general queries, please click the below link which will direct you to our Candidate Information Page.

Link: https://justicejobs.tal.net/vx/candidate/cms/About%20the%20MOJ

Things you need to know

Artificial intelligence

Artificial intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, as your own) applications may be withdrawn and internal candidates may be subject to disciplinary action. Please see our candidate guidance (opens in a new window) for more information on appropriate and inappropriate use.

Selection process details

This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours, Experience and Technical skills.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.The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.

Diversity and Inclusion

The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see theCivil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window).

Apply and further information

This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative.Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Contact point for applicants

Job contact :

• Name : SSCL Recruitment Enquiries Team
• Email : moj-recruitment-vetting-enquiries@resourcing.soprasteria.co.uk
• Telephone : 0345 241 5359

Recruitment team

• Email : moj-recruitment-vetting-enquiries@resourcing.soprasteria.co.uk

Further information

Appointment to the Civil Service is governed by the Civil Service Commission’s Recruitment Principles. I you feel a department has breached the requirement of the Recruitment Principles and would like to raise this, please contact SSCL (Moj-recruitment-vetting-enquiries@gov.sscl.com) in the first instance. If the role has been advertised externally (outside of the Civil Service) and you are not satisfied with the response, you may bring your complaint to the Commission. For further information on bringing a complaint to the Civil Service Commission please visit their web pages: http://civilservicecommission.independent.gov.uk/civil-service-recruitm…

https://jobs.justice.gov.uk/careers/JobDetail/15991?entityId=15991