Reporting & Data Analyst - Transport Data

Opus Resourcing Ltd; Greater London; On-site; GBP 35,000 - 55,000; Full time

Job summary

Opus Resourcing Ltd in London is seeking a Reporting & Data Analyst to turn transport survey and monitoring data into clear, professional reports for councils and clients.

You will work in a collaborative Technology & Data Team, analyse datasets, build dashboards and maps, and present findings to non-technical stakeholders to inform decisions.

Qualifications

• Strong analytical and problem-solving skills with curiosity to interrogate data.
• Excellent Excel skills including Power Query for cleaning and structuring data.
• Ability to translate data findings into clear reports for non-technical audiences.
• Some knowledge of the UK transport sector via surveys, planning or local schemes.
• Experience creating dashboards and visualisations using Power BI is advantageous.
• Attention to detail and ability to manage multiple reports and deadlines.
• Comfortable working independently within a broader technical team.

Responsibilities

• Analyse traffic, transport and survey datasets to identify trends and patterns.
• Turn complex data into polished, client-facing reports and dashboards.
• Combine data with maps and visuals to communicate findings effectively.
• Use QGIS to create mapping outputs and spatial analyses for reports.
• Build and maintain dashboards and data visualisations with Power BI.
• Clean, structure and prepare datasets using Excel and Power Query.
• Validate data and translate technical findings into plain English.
• Develop reporting templates, processes and documentation to improve workflows.

Skills

Data analysis

Power Query

Excel

Power BI

Dashboards

Communication

GIS basics

QGIS familiarity

UK transport sector knowledge

Independent collaboration

Tools

QGIS

Power BI

InDesign

Illustrator

Canva

Inkscape

Job description

Reporting & Data Analyst

is required to turn transport survey and monitoring data into clear, insightful and professionally designed reports for councils and other clients for an innovative UK traffic data and transport consultancy based in London.

Working within a collaborative Technology & Data Team, you’ll analyse and interrogate datasets, identify the story behind the numbers, and communicate findings through reports, dashboards, maps and visualisations that help non-technical stakeholders make informed decisions.

This role would suit an analytically minded and naturally curious data professional who enjoys asking "why?", has a strong eye for detail and presentation, and can translate complex information into clear, accessible insights.

Key skills required for the Reporting & Data Analyst

• Strong analytical and problem-solving skills, with the curiosity to interrogate data rather than simply report the numbers.
• Excellent Excel skills, including Power Query, with experience cleaning, structuring and preparing datasets.
• Strong written communication skills, with the ability to translate data and technical findings into clear, well-structured reports for non-technical audiences.
• Some knowledge of the UK transport sector, gained through transport surveys, transport planning, highways, traffic data or exposure to local authority transport schemes.
• An understanding of schemes such as Low Traffic Neighbourhoods, School Streets, active travel, parking, highways or kerbside management would be valuable.
• Excellent attention to detail, particularly when validating data and producing client-facing reports.
• Strong organisational and time-management skills, with the ability to manage multiple reports, datasets and deadlines simultaneously.
• Confidence working independently while collaborating effectively as part of a wider technical team.
• Experience using QGIS for mapping or spatial analysis would be highly desirable.
• Experience creating dashboards and visualisations using Power BI would be advantageous.
• Exposure to Adobe InDesign, Illustrator, Canva or Inkscape for creating professional reports and visuals would be beneficial.
• Basic scripting or automation experience using Python would an advantage.
• Familiarity with transport planning terminology and guidance such as STATS19, Manual for Streets or LTN guidance would be beneficial.
• Experience undertaking more advanced GIS-based spatial analysis would also be advantageous.

What you’ll do as a Reporting & Data Analyst

• Analyse traffic, transport and survey datasets, investigating trends, anomalies and patterns to understand what the data is really showing.
• Turn complex datasets into polished, professional and accessible reports for local authorities and other clients.
• Combine data analysis with maps, visualisations and clear written narrative to communicate findings effectively.
• Use QGIS to create mapping outputs and undertake spatial analysis to support client reports.
• Build and maintain dashboards and data visualisations using Power BI.
• Work extensively with Excel and Power Query to clean, structure, manipulate and prepare datasets for analysis.
• Validate and quality-check data before it is incorporated into client-facing reports and dashboards.
• Translate technical findings into plain English, ensuring council officers, elected members and other non-technical stakeholders can understand and act on the information presented.
• Use tools such as InDesign, Illustrator, Canva or Inkscape to enhance report layouts, graphics and presentation where required.
• Work closely with survey and technology colleagues to understand the context behind datasets and ensure reporting accurately reflects each project.
• Support the development and maintenance of reporting templates, processes and documentation.
• Help improve and automate data preparation and reporting processes where opportunities are identified.
• Manage multiple reporting projects while maintaining high standards of accuracy, presentation and delivery.

Why this role?This is an excellent opportunity to develop your career at the intersection of data analysis, transport, GIS and data visualisation, producing work that directly supports decisions made by local authorities across the UK.

You’ll gain exposure to the full data-to-report lifecycle, from cleaning and interrogating raw survey data through to spatial analysis, dashboard creation, visualisation and client-facing narrative.

You’ll also have the opportunity to develop your skills across QGIS, Power BI, data storytelling and automation, while gaining a deeper understanding of how data supports highways, traffic engineering, parking, active travel and kerbside management projects.

You’ll be joining a collaborative technology team where mentoring and support are available, making this a strong opportunity for someone who wants to build broader analytical and reporting expertise while seeing their work have a tangible real-world impact.

#DataAnalyst #TransportJobs #PowerBI #QGIS #DataAnalytics