Data Engineer - Data Office

This job has now expired please search on the home page to find live IT Jobs.

Enhance policing with data

It's not just our thousands of staff and officers who keep London safe. These days, it's also data - a key strategic asset for the Met. That's why you'll be so important to our team as a Data Engineer. A skilled professional, you'll provide the information we need to protect a vast and vibrant city.

The Met is increasingly data-driven, with a well-established Data Office. We want you to improve the range, quality and usability of the information that our Data Office provides.

Day to day, you'll be designing, building and maintaining automated workflows that extract, process and present data from corporate systems to meet specific business requirements. This may take the form of a simple request for data, a workflow to look at data quality or a Tableau dashboard that presents performance information.

As the Data Office supplies geographic data, much of your work could involve dealing with location-based information. For example, you could be geocoding data sources so they can be viewed on a map, or maintaining the business data sources of map data from agencies such as the Ordnance Survey.

At the core of this work is the ability to write SQL script. You'll use it to transform, aggregate and normalise data, and to create reporting processes that are as efficient as possible. You'll also need experience of using SSIS, Alteryx or FME to create automated reporting solutions. And you should be able to re-engineer manual data flows to enable repeatable use.

Along with technical skills, you'll bring a gift for collaboration and communication. Teamwork is vital, and you'll be building strong working relationships.

Discover a fascinating role that's essential to the success of the Met. As part of our team, you can expect a range of benefits plus excellent training and the chance to develop.

Job Summary

As a Data Engineer within the Data Office you will be responsible for designing, building and maintaining automated workflows that extract, process and present data from corporate systems in order to meet specific business requirements. This may take the form of a simple request for data, a workflow to look at data quality or a Tableau dashboard that presents performance information. Data Office is also responsible for providing geographic data to the MPS and so much of your work could involve dealing with location based information and geocoding data sources to allow them to be viewed on a map or maintaining the business data sources of map data from agencies such as the Ordnance Survey.

Data Engineer work to improve the range, quality and usability of the information that the Data Office presents by the use of fact and dimension tables. At the core of this work is the ability to write SQL script to transform, aggregate and normalise data and to make reporting processes that are as efficient as possible by ensuring that data is processed once, is held in one place, is searchable, is held in a form that maximises usability and that facilitates matching against other datasets.

To apply, please visit our website. Applications will be via a detailed CV and online application form.

Completed applications must be submitted by 13/10/2021

We view diversity as fundamental to our success. To tackle today's complex policing challenges, we need a workforce made up from all of London's communities. Applications from across the community are therefore essential.

As a Disability Confident Committed Employer, the Met have committed to ensuring that disabled people and those with long-term health conditions have the opportunities to fulfil their potential and realise their aspirations.