Geospatial Data Engineer
Job Title: Geospatial Data Engineer
Salary: The starting salary is £53,459, which includes allowances totalling £2,928.
The salary is broken down as £50,531 basic salary, which will increase annually until you reach the top of the scale £55,103 Plus, a location allowance of £1,928 and a non-pensionable allowance of £1,000.
Location: The primary Met Location for this role is either Hendon, Lambeth, or Sidcup. Travel across the Met estate, to attend meetings as required by the business, is expected.
“Keep checking Oleeo/Met Careers on a daily basis for new and exciting opportunities being released to join DDaT!”
Policing London is a hugely complex challenge that evolves every day. To make sure the Met is up to the task, we need the right IT and systems across our organisation. As a Geospatial Data Engineer, you will help to enable us to do our best for the London area. Join us and play your part in making London the safest capital in the world and delivering ‘More Trust, Less Crime and High Standards’.
As a member of the Met, you will also enjoy great benefits including annual leave, civil service pension arrangements, maternity/paternity support, as well as being part of a continuous leaning culture.
Digital, Data and Technology (DDaT)
The mission of Digital, Data and Technology (DDaT) is to provide the Met with information (and specifically data), communications and technology to help frontline officers and Met staff do their jobs more efficiently, in order to deliver the New Met for London plan. In other words, DDaT is about “passionately delivering trusted technology for precise data driven policing”.
As well as keeping up to speed with developments in technology and making recommendations for new equipment and systems that will help modernise policing, DDaT also comprises the Data Office which:
- Owns and drives the data compliance and analytics agenda.
- Brings together the accountabilities that are currently dispersed across the Met business areas.
- Consolidates and further develops existing Met data and insight services.
- Enables data sharing and collaboration to serve the public and external partners.
DDaT is committed to creating an inclusive working environment. We support hybrid working, and the hiring manager will be happy to discuss arrangements for this role.
Job Purpose
The Geospatial Data Engineer provides ETL (Extract, Transform, Load) and ELT (Extract, Load, transform) capability on spatial technical data to deliver high-quality data, including automation, for onward processing and consumption. They are Geospatial data/tooling experts and use cutting-edge tools and systems to provide data pipelines that support Geospatial Data Scientists, Intelligence Analysts and MPS Performance Reporting.
Data Engineering is transitioning to Microsoft Azure in late 2024 and early 2025. Current on-premises tools include SQL Server, Python, Alteryx and FME.
Key Role Responsibilities
- Responsible for business liaison, requirements gathering, negotiating, and agreeing deliverables with other teams/units.
- Deal with and escalate incidents and problems related to technical infrastructure.
- Build and maintain data pipelines in Azure and/or on prem.
- Design, build and maintain geospatial ETL processes using FME/FME server/AlterYX or cloud-based equivalents.
- Maintains and refreshes the local repositories of map layers supplied by OS and other commercial partners.
- Supports the maintenance and development of the corporate crime mapping application providing expert user support and generating new data layers within it.
- Manage the development of Fact tables from data extracted from corporate MPS systems.
- Monitors performance of existing databases/data warehouses/data lakes to identify areas of improvement or optimisation opportunities.
- Provide the business with accurate, relevant, and timely data, research and performance information that contributes to a culture of continuous improvement, enhanced efficiency, and evidence-based decision-making in the police.
- Collaborative working to ensure an understanding of other units’ objectives and promote a joined-up approach to ensure an integrated service across.
- Work with companies specialising in geospatial tooling and datasets to ensure the MPS have access to the data they require.
- Occasional overtime to support Operational Policing.
Vetting
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
Hybrid Working
Hybrid Working available in line with the MPS Hybrid Working Policy.
How to apply
Click the apply now button below and start your career at the Met. Applications will be via a detailed CV, Personal Statement, and online application form. Your personal statement (1000 words maximum) should outline why you are interested in the role and how your skills, experience, and knowledge (see Essential and Desirable Criteria) demonstrate your suitability for the role.
Completed applications must be submitted by 23:55 on 14th March 2025.
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 20th March.
Successful candidates will then be invited to attend an AC SQL Test at a MET location.
Following the 1st test, successful candidates will be invited to interview and the 2nd AC test. Interview dates will commence 24th March.