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 Lead 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 lead technical colleagues and engage with business stakeholders to understand requirements, advise on data solutions, and ensure that the systems you build are both functional and user-focused. Your data engineering expertise 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: • you lead the implementation of rigorous data validation and quality checks to ensure the accuracy and reliability of data used for analytics and business intelligence. • you manage the monitoring and optimisation of ETL processes and data flows to maintain high performance and efficiency, minimising downtime and errors, ensuring clear communication channels with users and stakeholders, soliciting feedback and managing expectations throughout the data lifecycle. • you implement comprehensive and up-to-date documentation of data processes, source-to-target mappings, and system configurations to support transparency and ease of maintenance. • you manage the development and maintenance of data products that meet the needs of stakeholders, ensuring they are user-friendly and accessible. • you seek and act on feedback to improve own performance and stay updated with the latest trends and advancements in data engineering, and actively seek opportunities for professional development through training, certifications, and industry events. • you lead on the recognition and celebration of the achievements and contributions of self and others while fostering a collaborative learning environment by encouraging team members to share insights, experiences, and innovative solutions to common problems. • you are responsible for mentoring and supporting junior data engineers by sharing knowledge, best practices, and providing guidance on complex technical challenges. • you implement data analytics and business intelligence solutions to inform decision-making processes, ensuring that decisions are based on accurate and relevant data. • you explain decisions and apply critical thinking and problem-solving skills to address complex data engineering challenges, identifying the most effective solutions. 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, you need: • extensive hands-on experience designing and implementing complex data pipelines and architecture, ideally at enterprise scale. • to be an expert in SQL, ETL/ELT design patterns, data modelling and infrastructure as a code. • a strong grasp of data governance, privacy and security. • experience in team leadership and technical product delivery. • proven leadership in delivering data solutions in cloud environments. 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 • Making Effective Decisions Benefits Alongside your salary of £56,640, Crown Prosecution Service contributes £16,408 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.