Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and optimise data pipelines to support Counter Terrorism Policing initiatives.
- Company: Join the Met's Counter Terrorism Policing HQ, making a real difference.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Why this job: Be part of a mission-driven team protecting communities from terrorism.
- Qualifications: Experience in data engineering, strong problem-solving skills, and knowledge of BI tools.
- Other info: Inclusive workplace committed to diversity and supporting all backgrounds.
The predicted salary is between 63409 - 65886 £ per year.
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 TasksThe 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.
- 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.
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.
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.
Essential For The Role- Deep understanding of data modelling, schema design, and transformation logic.
- Strong Alteryx Designer and Power Query (M) development skills.
- Proven experience in data pipeline engineering within a BI or reporting context.
- Experience with hierarchical or dependency-based workflow orchestration.
- Excellent problem-solving skills and attention to data quality.
- Significant experience in data analysis, analytical modelling and data visualisation; Expertise in Excel and Power BI.
- Excellent time management and organisational skills; Ability to be proactive, problem solve and present new solutions.
- Awareness of Workforce data, Finance budgeting and annual planning cycles.
- Familiarity with PowerApps, Python, SQL, VBA and other complementary BI/ETL tooling.
- Experience working with structured controller processes and metadata-driven automation.
- Experience in SharePoint Development.
- Strong written and verbal communication skills with a range of audiences.
Data Engineer in London employer: Metropolitan Police.
Contact Detail:
Metropolitan Police. Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer in London
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, especially those already working in data engineering or at CTPHQ. A friendly chat can open doors and give you insights that job descriptions just can't.
✨Tip Number 2
Prepare for the interview by brushing up on your technical skills. Make sure you can talk confidently about data modelling, ETL processes, and tools like Alteryx and Power BI. We want to see your passion and expertise shine through!
✨Tip Number 3
Showcase your problem-solving skills during interviews. Be ready to discuss past challenges you've faced in data engineering and how you tackled them. Real-life examples will make you stand out!
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you're serious about joining the team at CTPHQ. Let's get you that dream job!
We think you need these skills to ace Data Engineer in London
Some tips for your application 🫡
Craft a Compelling Personal Statement: Your personal statement is your chance to shine! Make sure to express your genuine interest in the Data Engineer role and highlight how your skills align with what we're looking for. Be specific about your experiences and how they relate to the tasks mentioned in the job description.
Tailor Your CV: Don't just send a generic CV! Tailor it to reflect the essential and desirable criteria listed in the job description. Use keywords from the posting to show that you understand the role and have the relevant experience. This will help us see why you're the perfect fit!
Be Clear and Concise: When filling out the application form, clarity is key. Keep your answers concise but informative. Avoid jargon unless it's relevant, and make sure we can easily understand your points. This will help us get a clear picture of your qualifications and enthusiasm.
Submit on Time: Make sure to submit your application before the deadline! We can't wait to see what you bring to the table, so don’t leave it until the last minute. Double-check that all your documents are saved correctly and uploaded as PDF or Word files, labelled clearly.
How to prepare for a job interview at Metropolitan Police.
✨Know Your Data Inside Out
Make sure you have a solid understanding of data modelling, schema design, and transformation logic. Brush up on your Alteryx and Power Query skills, as these are crucial for the role. Be ready to discuss specific projects where you've successfully implemented data pipelines.
✨Showcase Your Problem-Solving Skills
Prepare examples that highlight your problem-solving abilities, especially in data quality and pipeline engineering. Think of scenarios where you faced challenges and how you overcame them. This will demonstrate your analytical mindset and attention to detail.
✨Communicate Clearly with Non-Technical Stakeholders
Since you'll be translating complex technical concepts for non-technical leaders, practice explaining your past projects in simple terms. Use analogies or visuals if necessary to make your points clear. This will show your ability to bridge the gap between technical and non-technical teams.
✨Be Ready for Technical Questions
Expect technical questions related to data pipeline maintenance, workflow automation, and data governance. Review common interview questions in these areas and prepare your answers. Being well-prepared will help you feel more confident during the interview.