Data Analyst

Job title: Data Analyst 

Salary: £37.5k-38.5k
Grade: Band 2

Contract type: TfL                                           Reference: 4116

Contract details: Permanent                               Location: Pier Walk, London

Application closing date: 17/5/2026 at 23:59

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

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

Overview of project/role

The Revenue Analysts provide support for their line managers, analysing the patterns and nature of passenger travel and revenues which underpin decisions in many areas such as: the allocation of revenue from multi-modal tickets; income forecasting; evaluation of fares options. The job holders draw on a wide range of information ranging from internal data on ticket sales, revenues, Oyster and CPC usage data, etc., external data on inflation, economic activity, etc, and undertake a wide variety of analytical tasks, for example building econometric models to explain trends, estimating the usage of Travelcards on each mode to support revenue allocation, forecasting the effects of fares changes.

Key Accountabilities

1. Analyse and interpret fares revenue and ridership data and the factors affecting them, together with maintenance of the relevant statistical models, in order to provide an explanation of trends for senior management across all the TfL modes and National Rail, together with revenue and ridership forecasts.
2. Evaluate the impact on revenue, ridership and customers of fares revision options and ticketing initiatives across all TfL public transport modes and National Rail in London, developing established computer models as required to do this, in order that the financial and other impacts of fares and ticketing changes are properly understood.
3. Apply the various analytical processes set out in the ticketing agreements (Travelcard, Through Ticketing, PAYG etc.) in order to derive factors, percentages, payments amounts etc. which determine the shares of revenue from joint tickets to be allocated to each of the various TfL operators (LUL, Buses, DLR, Tramlink, Overground) and to the National Rail train operating companies (total revenue circa £4 billion per annum).
4. Monitor the operation of, and results from, the system for apportioning PAYG revenue operated by the Technology Development team, to ensure that all revenue is apportioned in accordance with the PAYG and/or CPAY Agreement, that system upgrades are compliant with requirements, and that emerging issues affecting the National Rail companies are addressed and disputes avoided.
5. Implement appropriate processes to obtain the passenger travel data necessary to support the above activities, principally through interrogation of the Oyster and contactless systems and through the commissioning of appropriate surveys of, e.g. Travelcard holders.
6. Populate and maintain a variety of major databases ranging from internal ticket sales, revenue and passenger usage information through to externally-sourced economic series, in order to support the multiplicity of analytical and modelling tasks as described in the accountabilities above.
7. Provide a wide range of ad-hoc analyses, as required, of Oyster, CPC and other ticketing data, and develop the necessary expertise and familiarity with the relevant databases in order that non-routine and novel data analyses can be readily produced.

Knowledge

• Ability to apply computer-based analytical techniques, e.g. SQL, Power BI, Excel, to build appropriate computer models.
• Good understanding of the Oyster ticketing system and the way in which ticket usage and sales data is held and can be interrogated.
• Good understanding of the various travel agreements and the provisions governing revenue sharing.
• Good knowledge of TfL’s fares structures and ticketing policies.
• Good knowledge of TfL’s systems for accounting for fares revenue, and an appreciation of equivalent systems for National Rail.

Skills

• Good analytical skills and the ability to apply this knowledge in a practical environment with high data volumes.
• Ability to present complex technical issues verbally and in writing, and to present a case to support a proposed course of action.
• Ability to deliver accurate results which are critical to the delivery of TfL/LUL revenue from joint ticketing products.
• Ability to communicate effectively, both orally and in writing, with people at all levels across the organisation and outside.
• Ability to build strong relationships with people at all levels both internally and externally.

Experience

• Experience of developing and managing large and complex data analysis and/or model building tasks.
• Some experience of delivering results from systems involving high volumes of transactions and the analysis and summarising of data from such systems is desirable. 
• Some experience in at least one of the following areas: economic or statistical analysis, accounting, market research, business analysis.

Application Process 

• Please apply using your CV only
• 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

Equality, diversity and inclusion

We are committed to equality, diversity and inclusion. We want to represent the city we serve, which will help us become a more innovative and efficient organisation. Our goal is to make our recruitment as inclusive as possible. We are a disability confident employer who guarantee an interview to any disabled candidate who meets all of the essential criteria. We also use anonymising software that removes identifying information from CVs and cover letters to make the process fair.
  
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
• 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

We will make every effort to give you as much notice as possible, however some interviews/assessments could be organised at short notice.

Vetting Process

At Transport for London, safety, trust and fairness sit at the heart of how we recruit. Our Vetting Charter (https://tfl.gov.uk/corporate/careers/our-vetting-process) explains the checks we carry out before you join us, helping ensure we create a safe, inclusive and reliable network for everyone who depends on our services. We simply ask that the information you provide is honest and accurate so we can progress your application smoothly. If something doesn’t match or can’t be verified, we may not be able to move forward with your application, but we’ll always treat you with transparency, respect, and clear communication throughout.

We may close this advert early if we receive a high volume of suitable applications.