Transport for London
Data Modeller

How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Welcome to Transport for London Careers
Take a look at job opportunities with us and you may be surprised at what you discover: a rich heritage, a commercial outlook, an iconic brand, a unique public service. It all adds up to make Transport for London a great place to develop your career. Here you can start your journey!
Key Information
- Job title: Data Modeller
- Salary: £65,682
- Location: Endeavour Square, Stratford, London - Hybrid
- Contract Type: 1 x Permanent Position
- Band: TFL Band 3
- Closing Date: Thursday 20th August 2026 @ 23:59
Job Overview
Shape workforce and organisational insight at TfL
We are looking for a talented Data Modeller to join our Business Services team and help turn complex organisational data into insight that supports decisions across Transport for London.
This is a varied modelling and analytics role, suited to someone who enjoys solving complex problems, working with business stakeholders and building reporting solutions that make data easier to understand and act on.
This role will focus primarily on Occupational Health, wellbeing and workforce-related analytics, helping to shape and mature a growing reporting and insight capability in this area. You will help improve management information, identify trends and support evidence-based decision making using data from SAP and a range of workforce systems, including Occupational Health and employee case management platforms, alongside other business systems and reporting sources. As the role develops, there will be opportunities to apply your modelling and analytical expertise across a wider range of workforce and business challenges.
What you will be doing
- Building data models, forecasts, scenario analysis and management information products.
- Developing Power BI dashboards and reporting solutions for business users and senior stakeholders.
- Working with SAP based ERP data and other enterprise data sources.
- Supporting Occupational Health, Employee Relations, workforce and attendance-related reporting and analysis.
- Helping stakeholders understand trends, risks, opportunities and data quality issues.
- Translating complex data into clear insight for technical and non-technical audiences.
- Improving reporting processes, automation and the consistency of business intelligence outputs.
- Supporting wider HR, financial, operational and organisational modelling as business priorities change.
What we are looking for
You will be naturally curious, analytical and comfortable working with large and complex datasets. You do not need to be an Occupational Health specialist, but you should be interested in using workforce and operational data to 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.
Graduate Consultant — 2026 Scheme
Why you're a good match
StrongYour 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 breakdownIt 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.
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.
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.
- Strong Power BI and SQL skills.
- Experience developing analytical models, dashboards or business intelligence solutions.
- Experience working with SAP based ERP data or comparable enterprise system data.
- Ability to work with data from multiple systems and turn it into clear, usable insight.
- Experience analysing workforce, HR, operational, case management, finance or organisational datasets.
- Strong attention to detail, with a good understanding of data quality and governance.
- Good stakeholder engagement skills and the ability to explain technical findings clearly.
- Ability to prioritise, manage competing demands and deliver accurate outputs to deadlines.
It would be beneficial if you also have
- Experience with SAP BW, SAP reporting or ERP reporting environments.
- Experience with Employee Relations, case management, Occupational Health, wellbeing or attendance-related data.
- Experience using or reporting from case management systems such as SAP EIC, Meddbase or similar platforms.
- Experience with Power Query, DAX, VBA, Python, R or similar analytical tools.
- Exposure to Databricks, cloud analytics platforms or modern data architecture approaches.
Who this role may suit
This opportunity may suit candidates currently working in roles such as:
- BI Developer or Power BI Developer
- Senior Data Analyst or Analytics Consultant
- Workforce Analyst or People Analytics Specialist
- HR Data Analyst or Management Information Analyst
- Finance, ERP or Operational Reporting Analyst
- Data Modeller with strong business-facing experience
Why join us?
You will work on data that supports real operational and workforce decisions in one of the UK's largest and most complex transport organisations. You will have the opportunity to improve how Business Services uses data, shape reporting across emerging priority areas and build analytical products that help colleagues make better, faster and more evidence-based decisions.
Equality and Diversity
We are committed to equality, diversity and inclusion and aim to reflect the diverse communities we serve. We believe that a diverse workforce enables us to deliver better services and outcomes. Our goal is to make our recruitment as inclusive as possible. As a Disability Confident Leader, we actively encourage applications from disabled people. As part of the Disability Confident scheme, we aim to offer an assessment or interview to candidates who apply via the scheme where the minimum essential criteria for skills, knowledge and experience has been met. In some circumstances, it may not be practical to offer an interview or assessment to every candidate who applies through the scheme and meets the minimum essential criteria; in these situations, we select candidates who best meet the minimum criteria for the job rather than interviewing all who meet them.


Get help with your application
Your very own career expert that helps elevate your application to the next level.
Across all recruitment activity, we recognise that selection methods may vary depending on the nature and scale of the campaign and will be applied fairly, consistently and proportionately in line with our Disability Confident commitments.
Application Process
Think carefully about the skills, knowledge and experience in the advert and cover this in your CV. PDF format preferred and do not include any photographs or images.
NPL Applications
Applications to internally advertised roles can only be accepted from temporary workers who are on PAYE terms via agency, or PAYE via Umbrella Companies. Temporary workers who are paid through their own limited companies are not covered by the Agency Worker Regulations and are ineligible to apply.
NPL members of staff are not eligible to apply to secondment opportunities.
All offers of employment are subject to satisfactory right-to-work checks, and candidates must be able to demonstrate their legal right to work in the UK. In certain circumstances, TfL may be able to sponsor Skilled Worker visas for roles and individuals that meet the required eligibility criteria, including those covered by transitional rules. Further details can be found here: Our response to visa sponsorship changes.
Benefits
In return for your commitment and expertise, you will enjoy excellent benefits and scope to grow.
Rewards vary according to the level of role but mostly include the below:
- Final salary pension scheme
- Free travel for you on the TfL network
- Reimbursement of 75% of the cost of a standard class Ticket for National Rail travel from home or 75% reimbursement on a 28-day flexi ticket
- 30 days annual leave plus public and bank holidays
- TfL is committed to work-life balance, operating a hybrid working approach where business and role requirements allow
- Private healthcare discounted scheme (optional)
- Tax-efficient cycle-to-work programme
- Retail, health, leisure and travel offers
- Discounted Eurostar travel
Hybrid working within this role enables a balance of 50 per cent of time split between the office and home over a 4 week period. Hybrid working arrangements can evolve subject to business requirements.
All offers of employment are subject to satisfactory right-to-work checks. Candidates must be able to demonstrate their right to work in the UK. At the present time TfL is unable to offer visa sponsorship for this role.
“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