Reporting & Data Analyst - Transport Data

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 In Design, 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

In Design, 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.

• #Data Analyst #Transport Jobs #Power BI #QGIS #Data Analytics
• #J-18808-Ljbffr