Data Engineer
Post Title: Data Engineer
Contract type: Permanent
Rank/grade: E
This role is open to all Police Staff / external candidates who meet the essential criteria of the person spec, regardless of current grade.
Salary: Starting Salary £40,910 plus £6,710 London weighting totalling £47,620 per annum
Directorate/department: Information Management Services
Vetting level required: MV/SC (or willingness to achieve)
Location: Bishopsgate Police Station / Hybrid
Who are we?
As City of London Police, we protect the people, businesses and infrastructure of the City of London, one of the most important and dynamic environments in the UK and globally. London City is the smallest borough in London, so does that make our job any less challenging? Absolutely not – because there’s so much going on.
City of London Police play a vital role in keeping the City of London diverse community safe. As a staff member you will be helping to making the city safer and deliver a valued service for those that live, work and visit the City.
The City of London Police is keen to promote flexible working and will, subject to operational policing requirements, proactively consider all applications to work flexibly.
The City of London Police is committed to equal opportunities and welcomes applications from all sections of the community.
About the team
The Information Management Services department has a strong, integrated information management vision in which data analytics plays a big part. The department is focused on supporting the various information needs of the Force and provides services to support public access to information, information security and assurance as well as records and data quality functions.
In addition, the department fosters a culture of specialism and support for front line policing systems, including national, regional and local systems. The unique nature of the Force and its diverse responsibilities make it a great place to work and a place to develop with likeminded people working together to keep our community safe from harm.
About the role
This is an exciting opportunity for a data exploitation specialist to join the City of London Police. The role of the data exploitation specialist is to understand and exploit the various data sources accessible to the force which include national, local and open-source data sets.
This role provides a focal point for supporting the various data requirements across the force. The Data Exploitation Specialist is expert in all aspects of data exploitation and is supported by Data Analysts to ensure they have the necessary resource to succeed.
The ideal Data Exploitation Specialist shall have a minimum of 5 years’ experience, and specialist knowledge of data analytics platforms and tooling, broad technical and IT skills are essential with demonstrable experience with complex data environments and data analytics systems.
Responsibilities
In this role, you will be:
• Responsible for the development of modern, efficient, robust data pipelines and products, making use of cloud native and best in class technologies as appropriate.
• Develop automated data ingest routines, workflows and mappings for structured and unstructured data.
• Development of complex data models for new and existing data sources to provide accessible and reusable data for the company, other Government Departments, and Private Sector Partners
• Data Modelling: Design and develop efficient data models to support the force data requirements and objectives. Collaborate with stakeholders to understand their data needs and translate them into scalable and robust data models.
• Power BI Development: Utilise Power BI to create visually appealing and interactive reports, dashboards, and data visualisations. Transform complex data into meaningful insights and present them to stakeholders in a clear and concise manner.
Requirements
For this role, we need you to have experience of:
• Degree in relevant subject (e.g. applied maths, statistics, computer science) or proven work experience as a data engineer.
• Proven ability to select and use appropriate statistical and analytical techniques to help draw insight from a wide range of data applications including data mining, AI/ machine learning, algorithm building, automation and predictive modelling.
• Demonstrable experience in creating and maintaining Power BI reports and dashboards.
• Excellent understanding of T-SQL queries, stored procedures, user-defined functions, views, indexes, and developer code associated with the database.
• Experience with data storage technologies such as azure data lakes, data warehouse and traditional SQL databases.
This vacancy is open only to those who have the right to work in the UK.
If you would like to discuss the role, please contact amarjeet.dhanjal@cityoflondon.police.uk
Selection Process
As part of the initial application process, you will be asked to evidence how your experience, skills, and knowledge demonstrate your ability to meet the person specification of the role.
The application and interview will be tested under Level 2 of the College of Policing Competency and Values Framework.
Applicants who fail to address the skills/knowledge/experience of the job description will not be considered.
The closing date for applications is 16/02/2025 at 23:59.
Following shortlisting, successful candidates will be invited to attend a competency-based interview, to be held week commencing 03/03/2025.
We strive to ensure all our information and services are accessible to and useable by everyone. If you would like to receive any information in a different way, would like us to do anything differently to help you apply for our roles, or have any other questions, please get in touch with HR via hrservices@cityoflondon.police.uk
Benefits:
A diverse workforce improves the service we provide to our public by making us more approachable and relevant within our communities. This is why it’s vitally important that we recruit people from a wide range of communities and backgrounds with an understanding of cultural issues and a wide range of skills. We therefore particularly encourage female and people from Black, Asian and other Minority Ethnic communities to join us.
The way we work is changing. With a few exceptions most roles will be able to accommodate part time, job share and flexible working patterns. We can also offer hybrid working patterns of home and office based shift patterns. Feel free to speak to us about any flexible working requirements.
The Force has a number of Staff Support Networks that can offer you support and advice. Applicants are very welcome to contact the networks directly if they need any support or ask any question before they apply. For further information on the networks and their contact details please visit: