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