Revenue Reporting Specialist

London Waterloo; Greater London; Hybrid; GBP 50,000 - 61,000; Full time

Benefits offered by this job

Annual leave 25–30 days

DC Pension Scheme 10% employer

Industry networking opportunities

Job summary

DFTO is seeking a Revenue Reporting Specialist to join the Customer & Revenue Growth team. You will build and maintain high-quality revenue reporting, analyse complex data, and provide senior stakeholders with clear insights to drive commercial decisions.

Based across London, Leeds or Birmingham with hybrid working, you will translate detailed analysis into concise messages and contribute to business cases and growth opportunities. The role supports the industry-wide revenue agenda.

Qualifications

• Detail-oriented analyst who works with large datasets to produce actionable insight.
• Strong technical skills with SQL, Python or equivalent for data manipulation and testing.
• Excel expert capable of robust, transparent, user-friendly models.
• Proficient in Power BI for clear data visualisation and trend communication.

Responsibilities

• Develop and maintain accurate, consistent revenue reporting across DfTO and the wider industry.
• Analyse complex revenue data, identify trends and explain implications for performance and risk.
• Build reporting frameworks, models and cross-tabulations to support business cases and decisions.
• Benchmark performance against internal and external indicators; identify areas needing action.
• Translate analysis into concise narratives, dashboards and briefing materials for senior stakeholders.
• Represent the team at industry forums, outlining reporting issues and trends to improve consistency.
• Collaborate with commercial, finance and analytical teams to improve data quality and processes.

Skills

Detail-oriented analyst

SQL

Python

Excel

Power BI

Tools

Power BI

Job description

About DFT Operator

Join Our Team at DFTO

DFTO is the government’s public sector rail owning group. Its purpose is to bring all currently privately-owned train operators into public ownership in advance of the creation of Great British Railways in 2027 - and deliver improvements in the here and now by unifying and integrating train operations under common public ownership.

DFTO has over 30,000 employees, runs over 11,000 services a day and delivers over 930 million customer journeys across its networks every year. 7,000 people joined the railway family in the last year

Major improvements are being delivered by DFTO train operators (TOCs) that are already under public ownership - these are LNER, Northern, TransPennine Express (TPE), Southeast, South Western Railway (SWR), c2c, Greater Anglia, WM Trains, GTR, and Chiltern.

We work closely with the DfT but operate independently with our own governance and leadership teams. Our priority is ensuring efficient, dependable rail services for everyone.

Primary Purpose of Job:

This is a chance to sit at the centre of how DfTO understands, explains and acts on revenue performance at a defining moment for the railway. As operators move into public ownership and the industry prepares for Great British Railways, the need for clear, trusted and consistent revenue insight has never been more important.

This role will help turn complex data into practical evidence that supports commercial decisions, strengthens business cases, and helps the organisation focus on the opportunities that will grow revenue and reduce subsidy.

The role:

The Revenue Reporting Specialist will help build the reporting discipline that sits behind DfTO’s commercial agenda. Working as part of the Customer & Revenue Growth team, you will develop and maintain high quality reporting, analyse complex revenue data, and make sure senior stakeholders have the insight they need to understand performance, spot trends and make better decisions.

You will be expected to bring rigour and curiosity to the numbers: testing assumptions, benchmarking performance, identifying what is changing, and translating detailed analysis into clear messages that can be used by commercial leads, finance colleagues and senior industry forums.

Key Responsibilities:

• Develop and maintain accurate, consistent and well-assured revenue reporting that supports commercial decision-making across DfTO and the wider industry.
• Analyse complex revenue datasets, identify trends and explain what they mean for performance, risk, opportunity and future growth.
• Build reporting frameworks, models and cross-tabulations that support business cases, investment decisions and senior-level performance conversations.
• Benchmark performance against internal and external indicators, helping teams understand where revenue is improving, where it is under pressure, and what action may be needed.
• Translate detailed analysis into clear, practical insight for senior stakeholders, including concise narratives, dashboards and briefing material.
• Represent the team at relevant industry forums, including PDFC, bringing a clear view of reporting issues, emerging trends and areas where greater consistency is needed.
• Work with colleagues across commercial, finance and analytical teams to improve data quality, reporting processes and the way insight is used.

Knowledge, Skills, Experience & Technical Qualifications:

• A detail-oriented analyst who enjoys working with large, complex datasets and turning them into insight people can use.
• Strong technically, with experience using tools such as SQL, Python or equivalent approaches to manipulate, analyse and test data.
• Expert in Excel, with the ability to design complex models that are robust, transparent and user-friendly.
• Confident using Power BI or similar tools to visualise data and communicate trends clearly.

Vacancy Details:

Duration: Fixed Term up to 31st March 2028 contract/secondmentLocation: We currently have officesin London Waterloo, Leeds, BirminghamSalary:up to £55,000
Closing date: 18th November 2026

DFTO Locations:

DFTO currently have office locations in London, Birmingham and Leeds and individuals can be based from any of the three locations. Whilst we do offer hybrid working there are sometimes demands to travel to the other office locations.

DFTO Benefits:

Annual Leave: Starting at 25 days and rising to an additional day per year of service completed within the first 5 completed years up to a maximum of 5 additional (30 days)

DC Pension Scheme: 10% Employer contribution, 5% Employee contribution

Opportunities to learn and network across the wider industry

Additional Information…

Disclaimer: Candidates applying for this position on a secondment basis must inform their line manager prior to submitting their application. This is to ensure transparency and facilitate any necessary discussions regarding workload and responsibilities.

About our people and the recruitment process - We're an inclusive employer of choice and we welcome applications from everyone! We encourage our colleagues to work flexibly, as we know traditional working patterns don't always fit. If you want to consider working flexibly, just let us know and we'll do our best to help and invest in your career with us, whilst you have a healthy work life balance.

Contact: If you have any questions or reasonable adjustments, please contact [e-mail].