Senior Data Engineer (Ref: 11098)

HM Courts and Tribunals Service; Folly Gate; Hybrid; GBP 45,000 - 60,000; Part time

Job summary

A government service organization in England is seeking a Senior Data Engineer to focus on data models, ingestion, and business rules. Ideal candidates will have strong SQL skills, experience in data warehousing, and problem-solving abilities. Benefits include a competitive salary, flexible working arrangements, and development opportunities in a supportive environment.

Benefits

Competitive salary

Civil Service pension scheme

Generous annual leave

Flexible working arrangements

Development opportunities

Qualifications

• Good understanding of dimensional data modelling and relational database design.
• Strong SQL skills with relevant database experience.
• Experience transforming data and loading into various storage platforms.

Responsibilities

• Contribute to physical data models and visualization for data science projects.
• Develop data ingestion and transformation processes.
• Collaborate with stakeholders to gather and deliver requirements.

Skills

Data Warehouse techniques

SQL

Problem-solving

Data transformation

Collaboration

Tools

Oracle

Microsoft SQL Server

Job description

Overview

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.

The Data, Analysis and Insight team supports senior leaders across the business through reporting, analysis and insights. Our work underpins the organisation's strategy and enables data-driven decision making. The role sits in the Data Management and Engineering team responsible for holding, curating, and protecting data to drive value for the organisation now and in the future. This vacancy uses Success Profiles and will assess Behaviours, Experience and Technical skills.

Role: Senior Data Engineer – focus on data models, ingestion, transformations, business rules, collaboration, data governance and improvement of data ways of working.

Responsibilities

• Contribute to the delivery of physical data models and views to enable data visualization and 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 business rules and definitions underpinning measures, metrics and KPIs.
• Collaborate with operational colleagues, 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 the overall data management framework.
• Embed improved data practices across the wider team, including automation of manual tasks and data assurance.

Qualifications and Experience

• Good understanding of Data Warehouse techniques, including dimensional data modelling and relational database design (e.g., Kimball).
• Strong SQL skills and experience with databases such as Oracle or Microsoft SQL Server.
• Problem-solving orientation with ability to troubleshoot complex data issues and deliver scalable solutions.
• Experience transforming data against business rules and data models, and loading data in various storage platforms.
• Experience working with data and databases, ideally in a Data Warehouse environment and with new/existing data sources.

Security and Nationality

Security: Successful candidates must undergo a criminal record check. Baseline personnel security standard checks apply for those working with government assets.

Nationality requirements: This job is broadly open to UK nationals, Irish nationals, Commonwealth nationals with the right to work in the UK, EU/EEA/Swiss/Norwegian/Icelandic nationals and family members with settled or pre-settled status under the EU Settlement Scheme, those who have applied for settled or pre-settled status, and others eligible to work in the Civil Service. Further information is provided in official guidance.

Working for the Civil Service

The Civil Service Code sets out standards of behaviour for civil servants. We recruit on merit and have inclusive practices, including the Disability Confident Scheme and Redeployment Interview Scheme where applicable.

Diversity and Inclusion

The Civil Service is committed to attracting, retaining and investing in talent from diverse backgrounds. See Civil Service People Plan and Diversity and Inclusion Strategy for more information.

Benefits and Development

Benefits include competitive salary, Civil Service pension scheme, generous annual leave, flexible working arrangements, parental leave policies, and an inclusive workplace culture. Development opportunities include access to Microsoft Azure training, DataCamp or Pluralsight, webinars, courses, coaching and peer support networks.

Application Process

To apply, submit a CV and Statement of Suitability (up to 1000 words) outlining evidence and examples of how you meet the person specification. Your CV should be succinct, factually accurate, include qualifications (highlight relevant modules or accreditation) and relevant experience with dates. Your Statement should provide real-life examples aligned to the role; following the STAR format is recommended. A pre-sift may be conducted based on your experience with Data Warehouse techniques and data modelling. If shortlisted, you will undergo a two-part assessment: technical presentation (up to 10 minutes) and Civil Service behaviours (e.g., Changing and Improving; Delivering at Pace).

Interview: If you pass the sift, you will be invited to a formal interview with the presentation brief communicated in advance. Further information about the Government Digital and Data Profession Capability Framework and Success Profiles is available in official guidance.

Additional Information

HM Courts & Tribunals Service (HMCTS) administers criminal, civil and family courts and tribunals in England and Wales. We are looking for individuals committed to public service and improving justice. This role includes responsibilities to modernise and enhance data capabilities across the organisation. HMCTS supports development and wellbeing and offers flexible working policies and benefits such as a defined benefit pension and generous leave.