At a Glance
- Tasks: Transform complex data into actionable insights and build reporting solutions.
- Company: Join TfL, a leading transport organisation with a rich heritage.
- Benefits: Enjoy free travel, 30 days leave, and a final salary pension scheme.
- Other info: Hybrid working model with excellent career growth opportunities.
- Why this job: Make a real impact on workforce decisions in a dynamic environment.
- Qualifications: Strong Power BI and SQL skills; analytical mindset required.
The predicted salary is between 23735 - 29009 £ per year.
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
- 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.
- 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
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.
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
- 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.
Data Modeller in London employer: Future of London
Transport for London (TfL) is an exceptional employer, offering a dynamic work environment that fosters innovation and inclusivity. With a strong commitment to employee growth, TfL provides opportunities for professional development while ensuring a healthy work-life balance through hybrid working arrangements. Employees enjoy generous benefits, including free travel on the TfL network, a final salary pension scheme, and a focus on equality, diversity, and inclusion, making it a rewarding place to build a meaningful career in the heart of London.
StudySmarter Expert Advice🤫
We think this is how you could land Data Modeller in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Future of London!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Modeller at Future of London.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Future of London.
✨Apply Directly through Our Website
When you find a suitable opening like Data Modeller at Future of London, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Modeller in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Future of London, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Future of London. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Future of London
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Future of London!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
