89357 - Lead Data Engineer
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://youtu.be/3_xDMTQ6DJQ
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 reliable. 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 platforms.
- 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 assurance.
- 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 met.
- 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.
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.
Roles will be recruited using a combination of the Government Digital and Data (GDD) Profession Capability Framework and Success Profile Frameworks. Using GDD we will then determine if you will be paid an additional allowance on top of your basic salary.
Working Arrangements & Further Information
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 roles, the successful candidate(s) will be appointed to a MoJ office location, which may include their nearest Justice Collaboration Centre or Justice Satellite Office. This will be discussed and agreed on the completion of pre-employment checks.
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.
Benefits
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 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 Shared Service Connected Ltd (0845 241 5358 (Monday to Friday 8am - 6pm) or e mail Moj-recruitment-vetting-enquiries@gov.sscl.com);
- 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.
For more information on applying for a role as a candidate with a disability or long-term condition, please see our Disability Confident Scheme Frequently Asked Questions webpage.
You will be able to request reasonable adjustments to the recruitment process within the application form. If you need additional help completing the application form, please contact the SSCL Recruitment Enquiries Team.
Diversity & Inclusion
The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan and the Civil Service Diversity and Inclusion Strategy.
14/08/2024, 23:55 hours.
If you require any assistance please call 0345 241 5359 (Monday to Friday 8am - 6pm) or e mail Moj-recruitment-vetting-enquiries@gov.sscl.com
Please quote the job reference - 89357.
To apply for roles in MOJ you will need to confirm your employment history for at least 3 years prior to the date of application so that pre-employment checks (BPSS) can be undertaken. If you have spent significant time abroad (a total of 6 months in the past 3 years) you would be required to give a reasonable account of the reasons why.
For some roles you will be required to successfully complete National Security Vetting at Counter Terrorism (CTC), Security Clearance (SC) or Developed Vetting (DV) level as a condition of appointment. To meet CTC/SC/DV requirements you will normally need to have been resident in the UK for at least 3/5/10 years prior to the date of application (The level of checks that are required are stated in the advert).
If you do not meet the above requirements, you may still be considered if, for example:
- You've been serving overseas with HM Forces or in some other official capacity as a representative of HM Government
- You were studying abroad
- You were living overseas with parents
In such cases you will need to be able to provide referee cover for the period(s) of residence overseas. The duration of overseas residence and the country of abode will also be taken into account.
Success Profiles will enable a fairer and more inclusive method of recruitment by enabling us to assess the range of experiences, abilities, strengths, behaviours and technical/professional skills required for different roles. This flexible approach to recruitment focuses more on finding the right candidate for the specific role. To find out more about Success Profiles to support your application please click here for further guidance.
We have provided detail of the assessment stages and areas being assessed to help you prepare for completing your application form, and to advise of what will be assessed following this, if you successfully pass the application stage.
Application form stage assessments
Use of Artificial Intelligence (AI)
You must ensure that any evidence submitted as part of your application, including your CV, statement of suitability and behaviour examples, 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.
Interview stage assessments
https://ddat-capability-framework.service.gov.uk/role/data-engineer#senior-data-engineer
A Great Place to Work for Veterans
The "Making the Civil Service a Great Place to work for veterans" initiative includes a guaranteed interview scheme to those who meet the minimum criteria to provide eligible former members of the Armed Forces with opportunities to secure rewarding jobs. Allowing veterans to continue to serve their country, and to bring highly skilled individuals with a broad range of experience into the Civil Service in an environment, which recognises and values your previous service in the Armed Forces.
For further details about the initiative and eligibility requirements visit : https://www.gov.uk/government/news/making-the-civil-service-a-great-place-to-work-for-veterans
Redeployment Interview Scheme
Civil Service departments are expected to explore redeployment opportunities before making an individual redundant. The MoJ are committed, as part of the Redeployment Interview Scheme, to providing opportunities to those who are 'at risk of redundancy'.
MoJ are able to offer an interview to eligible candidates who meet the minimum selection criteria, except in a limited number of campaigns. Candidate's will not be eligible for the Redeployment Interview Scheme if they are applying on promotion.
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) https://www.gov.uk/settled-status-eu-citizens-families
· 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) https://www.gov.uk/government/publications/nationality-rules
This Vacancy is closed to applications.