Analytics Engineer (2 roles available), Data Directorate, Ministry of Justice

This is a great opportunity to work with leading cloud technology and help change the way data is used in the public sector. Analytics engineers at MoJ play a critical role in our mission to put data at the heart of decision-making. We're looking for people with the drive to develop a deep understanding of data needs and data availability across specific areas of the Ministry of Justice. You will work in a team of Analytics Engineers, alongside Data Engineers, to bridge the gap between data producers and data users, developing analytical pipelines and self-service tools to acquire and transform data, making it available on our Analytical Platform.

As an Analytics Engineer, your work might involve:

• gathering requirements and translating these into clear deliverables


• working with data engineers and members of our data platform teams to prioritise, plan and deliver work


• turning needs and opportunities into flexible, quality-assured, dimensional models for use by analysts and data scientists and ensuring dimensions are conformed wherever possible


• ensuring content is complete and accurate, and producing summary outputs to demonstrate this completeness and accuracy


• providing tools to collect, store and present metadata and documentation that enable people to use data intelligently


• drawing attention to data quality / data governance issues


• acting as a key point of contact for our analytical user community, helping data users to automate their work, supporting them with tools like dbt and Airflow, There will be one interview, covered in two sections, which will include a technical exercise and assessment of civil service behaviours. The interview will take place via Microsoft Teams.


The purpose of the technical exercise is to test your technical skills. The exercise will last one hour and will involve completing some SQL code, and stating how you would design a data pipeline to solve a specific, given user need. More information on the exercise will be provided to candidates invited to interview.

In the second section of the interview, candidates will be assessed against the following civil service behaviours:

• Working Together


• Changing and Improving


You can find out more about behaviours via the Civil Service Success Profiles.

We recommend that you use the STAR approach - situation, task, action, and result - when structuring your answers. Further information can be found on the National Careers Service website.

Interviews are likely to take place in October 2024. The highest scoring candidates who pass the interview will be offered a role. If you do well at the interview but we don't offer you a role right now, we'll keep your details for a year and let you know if other opportunities come up. The whole process can take up to a month., 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.,
• 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

We welcome applications from anyone with the skills we consider to make a good analytics engineer. You may not currently be in an analytics engineering role and that's ok. Many of our team have a background in analysis, data science, software engineering, and much more.

Below, we list a number of skills we are looking for in candidates. If you don't have experience with all of these then that's all right, we get it, it's a long list! We encourage you to still apply and give us the chance to consider your application. A key attribute we're interested in is the willingness and ability to learn; learning and development is something we value and prioritise within our community.

There are some tips toward the end of this advert about how to apply - we strongly recommend you read these, especially if you're new to applying for roles in the Civil Service.

We are looking for people with experience in the following:

• SQL


• working with large relational databases


• testing and quality assuring data


It's a bonus if you also have experience of:

• Python, R or any other programming languages


• building data and analytical pipelines


• dimensional modelling including designing and populating star schemas


• working with business intelligence tools


• working to improve data quality


• working with data and analytics services in the cloud


• version control tools, such as git


• working in an agile environment, 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).

The national salary range is £32,827 - £35,678, London salary range is £37,174 - £40,403. Your salary will be dependent on your base location
Number of jobs available
2
Detail of reserve list
12 Months
Region
National
City/Town
National
Building/Site
NATIONAL, London: £37,174 - £40,403. National: £32,827 - £35,678.

You'll also get:

• a generous defined benefit pension, with employer contributions from 26% to 30%


• flexible working options, including part-year working, term-time working, reduced hours, compressed hours and job sharing


• 26 days leave (plus bank holidays), rising to 31 days after 5 years


• compassionate maternity, adoption, and shared parental leave, with up to 26 weeks leave at full pay, 13 weeks with partial pay, and 13 weeks further leave


• training and development opportunities, including access to Pluralsight, DataCamp and Civil Service Learning


• 5 days paid volunteering leave


• a cycle to work scheme


• season ticket loans, childcare vouchers and eyecare vouchers


• a quarterly reward and recognition scheme


• exclusive deals on travel, food, and entertainment


• secure bike parking and subsidised onsite gyms (subject to location), 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 (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.
Interview dates
Interviews are likely to take place in October 2024.
Closing Date, Behaviours
Working Together
Changing and Improving
Additional Assessment(s)
Technical Test

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