Opus Resourcing Ltd
Reporting & Data Analyst - Transport Data
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Reporting & Data Analyst
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.
Hybrid role circa two days per week in Central 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 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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
Opus Resourcing acts as an employment agency with respect to permanent employment.
📩 Apply now or message us for more details. Referrals always welcome!
#DataAnalyst #TransportJobs #PowerBI #QGIS #DataAnalytics
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location