Job Title: Data Engineer - Finance - Counter Terrorism Policing HQ
Salary: The starting salary is £63,409 which includes allowances totalling £3,009.
The salary is broken down as £60,400 basic salary, which will increase annually until you reach the top of the scale £65,886 Plus, a location allowance of £2,009 and a non-pensionable allowance of £1,000.
Location: West Brompton
Job Summary
Working within Counter Terrorism Policing Headquarters (CTPHQ), the Data Engineer will work within the Business Intelligence Function to provide ownership of the architecture, implementation, and ongoing optimisation of ART’s data pipelines and transformation processes. Working alongside a BI/Analytics Lead, the Data Engineer focuses on building efficient, robust systems that automate data validation, transformation, and delivery from source to output—powering dashboards, reports, and downstream analytical models.
The Data Engineer is an experienced hands-on engineering role that blends architecture, performance tuning, and process automation. The engineer will contribute significantly to both the backend design and the operational efficiency of the overall data infrastructure.
The role - in conjunction with the BI/Analytics Lead - will be jointly responsible for developing a BI strategy for CTPHQ corporate pillars, including a Roadmap/Plan to deliver it. This will require regular consultation and engagement with senior stakeholders to elicit requirements and translate them into BI initiatives.
Key Tasks
The post holder will be required to do the following:
Data Pipeline Maintenance and ongoing design
- Maintain current build and design future scalable, reusable ETL/ELT pipelines using tools such as Alteryx, Power Query, and batch scripting, with awareness and technical skill to adapt to changing data tooling landscape and availability. This includes modular workflows.
- Develop and enforce schema standards across the many user-input and back-end data layers.
Workflow Automation & Process Optimisation
- Enhance automation of complex tasks such as monthly cleansing, cross-validation, reporting and derived attribute creation.
- Drive improvements in processing time, memory efficiency, and refresh logic.
Collaboration with BI/Analytics Lead
- Translate analytical needs from the BI/Analytics Lead into reliable, performant data products.
- Build re-usable datasets and derived attributes to ensure front-end dashboards (e.g. in Power BI or Excel) are fed from stable, validated sources.
- Co-design validation layers that flag errors and anomalies early in the pipeline.
Data Quality & Governance
- Implement data validation checkpoints, unique key tests, and error-handling macros to ensure integrity.
- Maintain version control and change management for workflows and calculated attributes.
- Lead technical documentation of field definitions, transformation logic, and workflow dependencies.
Strategic Input
- Contribute to discussions on scalability, cloud migration, or development of current product.
- Translate complex technical challenges and data architecture decisions into clear, actionable insights for non-technical leaders, ensuring alignment with business goals and promoting confidence in Functional products.
Vetting and STRAP
This post requires access to the most sensitive intelligence material on a daily basis. Applicants must hold or be prepared to undergo National Security Vetting (NSV) Security Check (enhanced) (SC(e)) level before taking up the post; with a willingness to undergo Developed Vetting (DV) once in post, if required.
This post requires British nationality (some dual nationals may be ineligible) and an Enhanced Security Check (eSC).
As the post holder will have access to very sensitive information, there are limitations on travelling to a small number of countries and we will undertake additional security checks as part of the recruitment process. Applications from candidates with close connections to certain countries may take considerably longer to process, or in some cases result in a withdrawal of an offer of employment. Further details will be provided at the conditional offer stage.
Confidentiality Agreement
Applicants should also be aware of the need to sign a confidentiality agreement on taking up the post.
Our Employee Commitments
Counter Terrorism Policing aims to create an inclusive and welcoming atmosphere and culture and an environment where all our people feel a strong sense of belonging and are able to reach their full potential. Where any group or individual can be and feel respected, supported and valued to fully participate and contribute to our mission of “Working to keep people safe from Terrorism”.
Inclusion, diversity and equality is at the front and centre of our approach to make the composition of Counter Terrorism Policing more representative of the communities we serve. As Counter Terrorism is rooted in Local Policing, to tackle today’s complex policing challenges, applications from across all communities are therefore essential and encouraged. Counter Terrorism Policing as a network is committed to ensuring that disabled people and those with long-term health conditions have the opportunities to fulfil their potential and realise their aspirations’.
Counter Terrorism Policing is committed to creating an inclusive working environment. We welcome and encourage applications from candidates who are seeking flexible working arrangements, including part time working or job share. In addition, this role has been reviewed following learning from work during the Covid pandemic and may be done in an agile manner. In the first instance, please contact the vacancy holder to discuss how such arrangements could be accommodated (where applicable).
How to apply
To begin your career at the Met, please click the "apply button “. The application process requires a comprehensive CV, a Personal Statement, and an online application form. In your Personal Statement, you should explain your interest in the position and illustrate how your skills and experiences make you a suitable candidate. Please note that you should not submit two copies of your CV and ensure that your documents are saved in either PDF or Word format, clearly labelled as CV and/or Personal Statement.
Completed applications must be submitted by 23:55 on 17th March 2026.
Once received, your application will be reviewed against eligibility criteria, following this, your application will be reviewed by the hiring manager. The application review for this vacancy will commence 1-2 weeks after the vacancy has closed.
Following application review, successful candidates will be invited to interview. Interview dates will commence 1-2 weeks after hiring managers review.
