Rodeo
ResourcesPartnersSign in

Octavius Infrastructure

Junior Data Analyst

Reigate
Posted 1 day ago
Sign up to applySee more jobs like this

How your CV stacks up

1Upload CV
2Analyse CV
3Improve CV

Upload your CV to see how well it fits this job role

?%

We are recruiting for a Junior Data Analyst to join us here at Octavius.

We are a leading civil engineering organisation delivering safe, sustainable, and efficient transport solutions across the UK. Working within our Rail Services team, you'll play a key role in helping us make data-driven decisions that support the maintenance, upgrade and enhancement of railway assets across the network.

You'll be working on...

  • Supporting business users by analysing data requirements and delivering accurate, reliable reporting solutions.
  • Extracting, cleaning and transforming data from SQL databases, ERP systems and flat files.
  • Developing and maintaining repeatable data preparation and ETL processes.
  • Producing insightful reports and dashboards using Excel, Power BI and Power Query.
  • Identifying trends, patterns and performance insights to support operational decision-making.
  • Supporting KPI reporting and performance reporting for Network Rail.
  • Assisting with the mobilisation and implementation of our new operational management system, Total Mobile.
  • Working closely with operational, commercial and contract support teams to improve data quality and reporting capabilities.

You'll work with...

A team of highly motivated, dedicated professionals delivering critical rail infrastructure services across the UK. You'll collaborate closely with our Head of Strategic Projects, Operations, Commercial and Contract Support teams, as well as key stakeholders including Network Rail, helping to ensure data is used effectively to drive performance and improve decision-making.

Reasons to use Rodeo

I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?

Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.

Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.

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.

P

Graduate Consultant — 2026 Scheme

PwC·London, UK
£35,000/yr

Why you're a good match

Strong

Your economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.

See breakdown
Save jobNot relevant
View details

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.

Why you're a good match

You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.

See breakdown
Strong

Experience fit

Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.

See breakdown
Strong

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.

You'll receive...

  • A competitive rewards package, including Private Healthcare, Pension, Life Assurance cover, 25 days Annual Leave (and a day off for your birthday).
  • Access to Hybrid working where possible, an enhanced Paternity & Maternity package and the opportunity to develop yourself personally and professionally.

About You...

  • You have a strong eye for detail and take pride in producing accurate, high-quality work.
  • You're naturally analytical and enjoy solving problems using data.
  • You can communicate complex information clearly and effectively to a range of stakeholders.
  • You enjoy working collaboratively and building strong working relationships.
  • You're proactive, adaptable and keen to learn new skills, tools and technologies.
  • You have a genuine interest in using data to drive business improvement.

You'll bring...

  • Experience using Excel, including formulas, data manipulation and Power Query.
  • An understanding of relational databases and data structures.
  • Experience cleaning, validating and preparing data from multiple sources.
  • Strong analytical skills with the ability to identify trends and insights.
  • Experience supporting users with reporting from ERP systems or relational databases.
  • GCSE ICT or Computer Science (or equivalent).

Get help with your application

Your very own career expert that helps elevate your application to the next level.

Get help applying for this job

Desirable Experience

  • SQL knowledge and experience.
  • Power BI dashboard and report development.
  • Python, VBA or similar programming experience.
  • Experience with mobile forms or low-code platforms.
  • Knowledge of ETL processes, automation, SOAP/XML or REST/JSON integrations.
  • Experience within a helpdesk, support desk or customer service environment.
  • A-Level or Degree qualification in Computer Science, Statistics, Analytics or a related subject.

Why Octavius?

At Octavius, we're committed to creating a workplace where people can thrive. You'll join a supportive team, work on projects that make a real difference to the UK's transport infrastructure, and have opportunities to develop your technical skills while building a rewarding career in data and analytics.

Inclusion and diversity are important to us, we are an equal opportunities employer and value difference. We want and will continue to build an inclusive environment where our people thrive. We firmly believe constantly striving to build a truly diverse workforce is what makes us a strong business and will enable us to continue to solve important problems and deliver unrivalled value to both our customers and clients. If you need any specialist support throughout your application, we will work with you where we can to support your journey with us.

Junior Data Analyst - Rail Services - July 2026.docx

Trusted by 25,000+ job seekers

“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

Get help applying for this job

Skills

Excel
Power BI
Power Query
SQL
Data Cleaning
ETL Processes
Data Analysis
Reporting
Dashboard Development
Relational Databases
Python
VBA
Data Visualization
Data Transformation

Location

Reigate, England, United Kingdom

Sign up to applySee more jobs like this