Data Analyst - Supporting the Roads and Traffic Policing Command

The Digital & Innovation Business Group brings together technology, the effective use of data, and our capability to deliver change and reform to drive the Met forward: this is central to progressing delivery of New Met for London 2. It includes the Met's Transformation, Technology, Data and Analytics functions, as well as work underway to make the organisation more productive and efficient (referred to as Productivity & Efficiency or P&E). The Group was created in early 2026 and is led by Marie Heracleous, Chief Digital & Innovation Officer. It's an exciting time to be part of D&I, as it builds new capabilities and ways of working to support the frontline and make a real difference to London. D&I 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 Metropolitan Police Service owns unique datasets, unparalleled in size and complexity in law enforcement. These include calls to 999, recorded crime, stop & search, use of force, vetting and intelligence to name but a few. We are recruiting for Data Analysts who want to access these datasets to play a meaningful role in transforming the Met approach to data analysis and evidence-based policing. As a Data Analyst, you will be a key member of an agile multi-disciplinary analytics team, collaborating with Performance Analysts, Data Engineers and Data Scientists to model and deliver large datasets and analytical reports. A focus on modelling data in its rawest form, ensuring data/statistics are accurate and suitable to meet the reporting requirements of the wider Met stakeholders. Utilising a variety of applications to deliver the best outcome. You will be undertaking data modelling, cleansing and enrichment, building and reviewing data models, and using data integration tools and languages to integrate and store data. You will be working to our Data Standards and influence future best practices to present, communicate and disseminate data to inform and influence. At this level we expect you to be able to utilise multiple data visualisation tools and techniques including Advanced Excel, SQL, and either Power BI or Tableau. In 2024 we implemented a new CONNECT system, which is underpinned by a POLE (Person, Object, Location, Event) database, this gives us even more comprehensive datasets for our analysts to work with.

• BSc in STEM subject OR equivalent practical experience in data analysis or related field. Working experience of conducting descriptive, diagnostic, predictive and prescriptive analysis to identify what happened, why it happened, what might happen next and outline what action should be taken. Advanced working experience with Microsoft Excel, Word and PowerPoint and Business Intelligence tools (Power BI, Power Query, Tableau, etc). Experience of, or commitment to learn SQL to write and optimize SQL queries to extract and manipulate data from relational and/or POLE (Person, Object, Location, Event) databases, ensuring data accuracy and integrity. Create meaningful and engaging reports, and dashboards, using tools such as Tableau/Power BI and visualisations to effectively communicate data analysis results to non-technical stakeholders. Working experience of logging, analysing and managing problems independently in order to identify and implement appropriate solutions.
• Knowledge of Azure or other cloud platforms. Working experience of Office 365 tools including SharePoint and PowerApps. An understanding of Python/Java/Scala or other programming languages or statistical/Machine Learning or working in an Agile team using Version control (e.g. GIT).