20454 - Analytics Engineer x 2

Job title: HEO Analytics Engineer x 3

Location: National with occasional travel to London and other locations

Directorate: Strategy and Analysis Directorate

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.

This role will be recruited using a combination of Government Digital and Data (GDD) Profession Capability Framework and Success Profiles Frameworks during the sift and interview process. This role is within the Data job family and is a Analytics Engineer role.

About the role

The HMCTS Data 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 Analytics 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 an Analytics 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 visualization of metrics and the provision of insightful analysis for data science projects.

· Help in developing data models 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.

· 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

· Some 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 environment.

· An understanding of Data Warehouse techniques, including dimensional data modelling and relational database design and concepts (e.g. Kimball) or a willingness to learn.

· SQL skills and some experience working with databases.

Desirable

· Experience with parameterised coding in scripting/programming languages such as Python/Spark.

· Experience using cloud-based data services such as Azure Data Factory, Synapse or Fabric.

Further details

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.

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, taught courses, one-to-one coaching and access to a large peer-support network.

How to apply

Application Stage

Please submit:

• An anonymised CV. Please ensure your CV is uploaded in a simple format to prevent any formatting issues when it's downloaded or reviewed.

Your CV should:

· Be succinct and clear.

· Be factually accurate – You must ensure that any evidence submitted as part of your application, is 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 your knowledge, skills, and experience demonstrate the capabilities we are looking for in this role.

· Statement of suitability demonstrating how you meet the essential criteria (up to 750 words).

Your Statement of Suitability should be no more than 750 words and should give us real life examples of how your skills and experience match those needed for this role.

You must ensure that any evidence submitted as part of your application, 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.

We will aim to sift the CV, Statement of Suitability. In the event of a high number of applications, the panel will perform a preliminary sift on the Technical Understanding criteria.

Candidates who pass the initial sift of the Technical Understanding criteria will progress to a full sift where all application assessment criteria is then assessed.

Interview Stage

If successful at sift, you will be invited to attend a remote interview, via Microsoft teams. During your interview, you will be assessed against the following Civil Service Success Profiles which will include:

Assessment of the following ‘success profiles’ Civil Service behaviours

· Changing and Improving

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

· Technical – As demonstrated at interview. You will be expected to align your answers to the Government Digital and Data (GDD) Capability Framework Government Digital and Data (GDD)

· Capability Skill 1: Communicating between the technical and non-technical

· Capability Skill 2: Programming and build (data engineering)

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

Level of Clearance - To apply for this role, you will be required to successfully complete Security Clearance (SC) level as a condition of appointment. To meet these requirements, you will normally need to have been resident in the UK for at least 5 years.

https://www.gov.uk/government/publications/united-kingdom-security-vetting-clearance-levels/sc-guidance-pack-for-applicants

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 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.

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 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 [email protected]);
• To Ministry of Justice Resourcing team ([email protected]);
• 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 watch our animated videos.

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 TBS 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.

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 is committed, as part of the Redeployment Interview Scheme, to providing opportunities to those who are 'at risk of redundancy'.

MoJ is able to offer an interview to eligible candidates who meet the minimum selection criteria, except in a limited number of campaigns. Candidates will not be eligible for the Redeployment Interview Scheme if they are applying on promotion.

Civil Service Nationality Rules

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

Reserve list

A reserve list may be held for up to 12 months from which further appointments may be made for the same or similar roles.