Senior Data Engineer in London

Thank you for your interest in a role at the MOPAC. We are excited to hear about your experiences.

Join us to make London a safer city for everyone.

Help reduce violence in London, and take ownership of the data platform to do it

The Mayor’s Office for Policing and Crime (MOPAC) is the organisation through which the Mayor of London exercises his role as the Police and Crime Commissioner for London and is led by the Deputy Mayor for Policing and Crime. MOPAC undertakes a broad range of statutory duties and works closely with the Mayor of London, Deputy Mayor, and Metropolitan Police Service (MPS) to deliver the priorities that will create safer London communities.

London has a proud history of agencies sharing data to keep people safe. Police, health, local authority and partner data brought together and used well, helps analysts understand where violence is happening and where support is needed most.

Now we're building the next chapter.

PRISM (Partnership Resource for Insight and Safety Management) is MOPAC's new data platform. It brings police, health, local authority and partner datasets into one secure, modern, cloud-based environment, with automated pipelines, well-documented data and self-service access, and with mapping and forecasting tools planned to follow. It directly supports the Mayor's commitment to reducing violence and improving public safety, as set out in the Police and Crime Plan 2025-2029.

The build is getting started right now, with specialist consultants helping to kick-start it. You'd join as it takes shape, work alongside them from the start, and then take ownership of the data pipeline aspects of the platform as it grows.

Why you'll want this job

• Get in at the start. You'll join while PRISM is still taking shape, helping to influence how it's built and learning it from the inside. You won't be handed a finished system and told to keep it running.

• Take it on and make it yours. The platform will be yours to run, improve and expand. You'll lead on data architecture, governance and security, with a real say in how it evolves as more partners and datasets join.

• Work that matters. What you build will help local authorities and partners across London understand violence and target support where it's needed most.

• A team that's growing. You'll join an ambitious and growing data function on modern Azure infrastructure, with the freedom to bring new ideas and strong support for learning and development.

Beyond PRISM: your pipelines will power work across MOPAC

PRISM will be your main focus at first, but it's one part of a wider data science and engineering programme. MOPAC oversees the MPS, commissions support for victims and funds crime prevention, so the data work is varied. The data you engineer will feed:

• Measuring whether London is getting safer. The data behind how MOPAC tracks progress on violence, trust and confidence, victim satisfaction and the criminal justice system, through Power BI dashboards that help senior leaders hold the MPS to account and decide where to act.

• Forecasting and predictive modelling.Research that helps anticipate crime patterns and inform where resources go.

• AI and automation. Tools such as automated meeting transcription, analysis of large public consultations and chatbots, all of which depend on reliable, well-governed data.

• Products for the wider system. We build analytical tools and services that are shared with the wider GLA family and policing partners, so the quality of your pipelines shapes how useful they are.

You'll work side by side with data scientists and performance analysts, so you'll see your work used quickly.

If you want your data engineering to have a visible, real-world impact from day one, we'd love to hear from you.

Application Process

Candidates must submit their CV and must answer (around 1,500 characters per answer) to the supplementary questions which are:

1. Tell us about a time you had to bring together data from multiple sources with different formats, interfaces or quality issues. How did you design the ingestion and transformation process, and what challenges did you have to overcome?
2. Tell us about a data pipeline you have designed and delivered, for example using Azure Data Factory. What were the key architectural decisions you made, why did you make them, and how did you handle failures and monitoring?
3. Give us an example of when you have taken a data pipeline or platform from development into reliable production use. How did you build in data quality checks, security, maintainability and resilience, and how did you make sure users could trust the data?
4. Describe a situation where you had to make a significant technical decision while balancing the needs of non-technical stakeholders, delivery timescales and technical constraints. What did you decide, why, and what was the outcome?
5. What's your favourite Python package, and why?

Selection Process

Application for the role closes on 01 November 2026 at 23:59.

Want to find out what it’s like to work with MOPAC?

You can find out more about MOPAC by visiting our website

Please ensure you read the Candidate Frequently Asked Questions (FAQ) document attached to the vacancy as it contains key information regarding the recruitment process.

If you have a question about the role or the recruitment process, please contact a member of the HR team via email on HR@mopac.london.gov.uk.

Guaranteed Interview Scheme

If you are applying under the Disability Confident Scheme, you must email HR@mopac.london.gov.uk with the subject "MOPAC Application *JOB TITLE* DSC" and state your name within the email body. All candidates must type DSC in the relevant box within the application form to confirm their understanding of what is required (regardless of if they are applying under the scheme or not).

Applying for the Role

Please ensure you read the Candidate Frequently Asked Questions (FAQ) document attached to the vacancy as it contains key information regarding the recruitment process, security vetting clearance requirements, sponsorship, office location and attendance and others.

If you require any reasonable adjustments or assistance submitting your application, please email HR@mopac.london.gov.uk.

Guaranteed Interview Scheme

Please see information within main advert.

Security Vetting Clearance

The successful candidates will be expected to undergo the necessary security checks. Applicants must possess the legal right to work in the UK and have resided in the UK continuously for at least the last three years.

Reward and Benefits

For employment roles, in addition to an excellent salary and civil service pension with 28.97% employer contribution, we offer an attractive range of benefits including 32.5 days’ annual leave, interest free season ticket loan and flexible working arrangements.

Where are we based

Staff work at an office location for at least 40% of their working hours, which may differ depending on the role requirements. We are planning to move to a new office location 5-minute walk from our current office at Union Street. This will be towards the end of 2026.

We are a disability-confident employer. MOPAC guarantees an interview to any applicant that declares that they have a disability, providing they meet the minimum standards for the job role. These standards are defined in the job description and will often be listed as essential or desirable skills.

London's diversity is its biggest asset, and we strive to ensure our workforce reflects London's diversity at all levels. We welcome applications from everyone regardless of age, gender, ethnicity, sexual orientation, faith or disability.

Benefits

• 32.5 days annual leave, plus bank holidays
• Civil Service Pension Scheme
• Flexible Working
• Hybrid Working
• Corporate Benefits