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., 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-specialist 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 life cycle, 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.

• 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 be 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.