Senior Data Engineer

Contents Location Please note that this post can be based in any location within England and Wales, where a CPS office is located. Whilst it’s an expectation of the role to travel to CPS locations as per business needs, CPS is disability confident employer and all reasonable adjustments will be considered in line with Equality Act of 2010.

About The Job Job summary Join the Crown Prosecution Service (CPS) as a Senior Data Engineer and be a vital part of the criminal justice system in England and Wales. Operating independently, the CPS’ work upholds the rule of law and ensures that justice is served fairly and impartially for victims, witnesses, and defendants. This is a unique opportunity for you to contribute to the UK's justice system through the development and maintenance of a modern and robust data infrastructure predominantly in a Microsoft Azure environment. As part of the Data Platform team, you will engage with both technical colleagues and business stakeholders to understand requirements, advise on data solutions, and ensure that the systems you build are both functional and user focused. Your expertise as a senior data engineer will help shape a data-driven culture within the CPS, ensuring that the organisation remains responsive and effective in a rapidly evolving data landscape. The Crown Prosecution Service is based in England and Wales. If you’re applying for this role and live in Scotland or Northern Ireland, you must let us know when accepting this offer as you need permission to work from your home address if hybrid working is part of your role . There’s no guarantee that we will grant this approval. You must be aged 16 before starting in this role. The start date is expected to be 8-12 weeks after the application deadline.

As part of this role, you are expected to undertake direct line management responsibilities.

Job Description Your roles and responsibilities:

• Develop and maintain data products that meet the needs of stakeholders, ensuring they are user-friendly and accessible.
• Continuously monitor and optimise ETL processes and data flows to maintain high performance and efficiency, minimising downtime and errors.
• Implement rigorous data validation and quality checks to ensure the accuracy and reliability of data used for analytics and business intelligence.
• Mentor and support junior data engineers by sharing knowledge, best practices, and providing guidance on complex technical challenges.
• Foster a collaborative learning environment by encouraging team members to share insights, experiences, and innovative solutions to common problems.
• Regularly seek and provide constructive feedback to and from team members, promoting a culture of continuous improvement and personal growth.
• Apply critical thinking and problem-solving skills to address complex data engineering challenges, identifying the most effective solutions.
• Conduct thorough risk assessments for data projects, considering potential impacts and developing mitigation strategies to minimise risks.
• Engage with stakeholders to understand their needs and requirements, making informed decisions that align with business objectives and drive organisational success.

A copy of the full job description is available if requested from benjamin.ross-russell@cps.gov.uk

Person specification To be eligible to apply for this job you should have:

Essential Experience – Data Development Process (Build teams to complete data integration services) Programming and build for data engineering (Use agreed standards and tools to design, code, test, correct and document moderate-to-complex programs and scripts from agreed specifications and subsequent iterations) Proven experience as a Data Engineer Strong expertise in designing and implementing ETL processes Experience in data modelling Experience using SQL to query and manipulate data Strong communication and collaboration skills It is desirable that you have the below experience but this is not required to apply: Experience with Azure Data Factory, Python language and Databricks

Behaviours We'll assess you against these behaviours during the selection process: Managing a Quality Service Developing Self and Others

Benefits Alongside your salary of £42,530, Crown Prosecution Service contributes £12,320 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides. Join the Crown Prosecution Service and find your purpose. The Crown Prosecution Service is passionate about ensuring that we're a top performing organisation and a great place to work. We're a committed equal opportunities employer, creating a culture where you can bring your whole self to work, and individuality is truly appreciated. This culture of inclusion is underpinned by our staff networks covering disability, faith and belief, LGBTQI+, race, social mobility alongside our mental health first aiders programme and wellbeing sessions. The Crown Prosecution Service commits to offer its employees the following experience. You can do impactful, purposeful work that’s making a difference to your local communities. You are able to learn and grow, with access to the right opportunities and resources. We care about your wellbeing. We want you to feel valued, trusted and included. We also offer the following range of benefits: Civil Service contributory pension of up to 28.9% 25 days’ leave, increasing to 30 days after 5 years £350 each year to spend on personal development lawyer training programme for all new prosecutors an extra privilege day to mark the King's birthday competitive maternity, paternity and parental leave flexible working including flexitime, and a family friendly approach to work Cycle2Work scheme, employee savings.

Diversity at the Crown Prosecution Service is about inclusion, embracing differences and ensuring our workforce truly reflects the communities we serve. We want you to feel that you belong and can thrive, whatever your background, identity or culture. As a Disability Confident employer, we're happy to support requests for reasonable adjustments and improve your recruitment experience. If you'd like any reasonable adjustments made to our recruitment process, let us know within your application or contact benjamin.ross-russell@cps.gov.uk

We want to ensure our employees can thrive at work and home and offer a range of support to achieve a balance. This includes flexibility of working hours, flexibility to support caring responsibilities and a flexible approach to deployment. We offer a hybrid working policy. You must spend at least 40% of your contracted hours over a four-week period at court, in an office or another official workplace depending on business need and the kind of work you're doing. The Crown Prosecution Service also has a range of development programmes to support all aspiring, new and experienced managers with developing the skills, behaviours and knowledge to build their confidence and capability. Our Manager Induction Programme is mandatory for all newly appointed managers. This is a fantastic opportunity to support all our new Crown Prosecution Service managers with the tools required to perform effectively in their roles.