Data Engineer
Role details
Job location
Tech stack
Job description
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 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., 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., The MoJ offers Hybrid Working arrangements where business need allows. This is an informal, non-contractual form of flexible working that blends working from your base location, different MoJ sites and / or from home (please be aware that this role can only be worked in the UK and not overseas). All employees will be expected to spend a minimum of 60% of their working time in an office, subject to local estate capacity.
Some roles will not be suitable for Hybrid Working. Similarly, Hybrid Working will not suit everyone's circumstances. Arrangements will be discussed and agreed with the successful candidate(s) and subject to regular review.
For nationally advertised role: all successful candidates will be appointed to the nearest viable office nearest to their home postcode and on its respective pay scale. This will be at either a HQ building (subject to desk allocation, a Justice Collaboration Centre (JCC) or a Justice Satellite Office (JSO) - See Map. All employees will be expected to spend a minimum of 60% of their working time in an office, subject to local estate capacity).
For current MoJ employees, your base location will need to be changed to the nearest viable office (to your home postcode), either at a HQ building, JCC or JSO within the National Office Network and moved its location's respective pay scale (any legacy arrangements/locations will need to be amended).
Some of MoJ's terms and conditions of service are changing as part of Civil Service reform. The changes will apply to staff joining MoJ who are new to the Civil Service. Staff joining MoJ from other civil service employers will transfer onto the new MoJ terms if they are already on 'modernised' terms in their current post or onto 'unmodernised' MoJ terms if they are on 'unmodernised' terms at their current post. Details will be available if an offer is made.
MoJ candidates who are on a specialist grade, will be able to retain their grade on lateral transfer.
All candidates who are currently in receipt of Mark Time / Pay Protection should ensure they are familiar with the new policy on permanent and temporary promotion which can be found on the employee intranet.
Flexible working hours
The Ministry of Justice offers a flexible working system in many offices. Standard full time working hours are 37 hours per week. MoJ welcomes part-time, flexible and job-sharing working patterns, where they meet the demands of the role and business needs. All applications for part-time, flexible and job-sharing working patterns will be considered in accordance with the MoJ's Flexible Working policy., Interviews expected late April/Early May - subject to change Behaviours Changing and Improving Delivering at Pace 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.
Requirements
- 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.
Benefits & conditions
The national salary range is £42,914 - £46,182, London salary range is £49,325 - £53,081. Your salary will be dependent on your base location, * 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., 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., The MoJ offers a range of benefits:
Annual Leave
Annual leave is 25 days on appointment and will increase to 30 days after five years' service.
There is also a scheme to allow qualifying staff to buy or sell up to three days leave each year. Additional paid time off for public holidays and 1 privilege day. Leave for part-time and job share posts will be calculated on a pro-rata basis.
Pension
The Civil Service offers a choice of pension schemes, giving you the flexibility to choose the pension that suits you best.
Training
The Ministry of Justice is committed to staff development and offers an extensive range of training and development opportunities.
Networks
The opportunity to join employee-run networks that have been established to provide advice and support and to enable the views of employees from minority groups to be expressed direct to senior management. There are currently networks for employees of minority ethnic origin, employees with disabilities, employees with caring responsibilities, women employees, and lesbian, gay, bisexual and transgender employees.
Support
- A range of 'Family Friendly' policies such as opportunities to work reduced hours or job share.
- Access to flexible benefits such as voluntary benefits, retail vouchers and discounts on a range of goods and services.
- For moves to or from another employer or moves across the Civil Service this can have implications on your eligibility to carry on claiming childcare vouchers. You may however be eligible for alternative government childcare support schemes, including Tax Free Childcare. More information can be found on www.GOV.UK or Childcare Choices. You can determine your eligibility at https://www.childcarechoices.gov.uk/.
- Paid paternity, adoption and maternity leave.
- Free annual sight tests for employees who use computer screens.
Working for the Civil Service
The Civil Service Code 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. Should you feel that the recruitment process has breached the recruitment principles you are able to raise a formal complaint in the following order
- To Transformative Business Services (0345 241 5359 (Monday to Friday 8am - 6pm) or e mail moj-recruitment-vetting-enquiries@resourcing.soprasteria.co.uk);
- To Ministry of Justice Resourcing team (resourcing-management-office@justice.gov.uk);
- To the Civil Service Commission (details available here)
As a Disability Confident employer, MoJ are committed to providing everyone with the opportunity to demonstrate their skills, talent and abilities, by making adjustments throughout all elements of the recruitment process and in the workplace. MoJ are able to offer an interview to disabled candidates who meet the minimum selection criteria, except in a limited number of campaigns.
