Geospatial data engineer

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’.

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

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 Met performance reporting.

Data engineering is transitioning to Microsoft Azure. 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 Met 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

Additional information

Hybrid working available in line with the Met hybrid working policy and the hiring manager will be happy to discuss arrangements for this role.

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.