Senior Data Analyst

The Senior Revenue Analysts provide high-level support for their line managers, analysing the patterns and nature of passenger travel and revenues and/or evaluating proposals for ticketing system developments, all of which underpins decisions in many areas such as: the allocation of revenue from multi-modal tickets; income forecasting; evaluation of fares options; assessment of future ticketing system changes. The job holders draw on a wide range of information ranging from internal data on ticket sales, revenues, Oyster 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. The job holders will also evaluate proposals for changes to the ticketing systems/models, in particular the development of a new Travelcard allocation model and expansion of Contactless Payment Cards, in relation to the above activities., * Analyse and interpret fares revenue and ridership data and the factors affecting them, together with development of the appropriate statistical models, in order to provide an explanation of trends for senior management across all the TfL modes and National Rail (NR), together with revenue and ridership forecasts.

• Evaluate the impact on revenue, ridership and customers of fares revision options and ticketing initiatives across all TfL public transport modes and NR in London, developing established computer models and creating ad-hoc new ones as required to do this, in order that the financial and other impacts of fares and ticketing changes are properly understood.

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

• Continuously monitor the operation of, and results from, the system for apportioning PAYG revenue operated by the Technology Strategy & Revenue team, to ensure that all revenue is apportioned in accordance with the PAYG and CPAY Agreements, that system upgrades are compliant with requirements, and that emerging issues affecting the National Rail companies are addressed and disputes avoided.

• Provide analytical support to the Technology Strategy & Revenue team regarding the expansion of CPCs as a new ticketing medium, to ensure that the new system supports the necessary back-office processes.

• Negotiate, develop and agree with London Councils, appropriate econometric models to assess the revenue losses and other costs of the Freedom Pass scheme to TfL to underpin TfL's claim for compensation from the London Boroughs.

• Develop, 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.

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

Do you have experience in SharePoint?, * Ability to apply advanced computer-based analytical knowledge/techniques, e.g. SQL, Power BI, Databricks, Excel, and to build appropriate computer models.

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

• Thorough Knowledge of TfL's fares structures and ticketing policies.

• Thorough Knowledge of TfL's systems for accounting for fares revenue, and an appreciation of equivalent systems for National Rail.

Skills

• First class 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 negotiate effectively over such issues.

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

• Proven ability to build strong relationships with people at all levels both internally and externally.

• The ability to generate original ideas and envision new possibilities or better ways to accomplish tasks.

Experience

• Experience of developing and managing large and complex data analysis and/or model building tasks.

• Track record of delivering results from systems involving high volumes of transactions and the analysis and summarising of data from such systems.

• Significant experience in at least one of the following areas: economic or statistical analysis, accounting, market research, business analysis.

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.

There has been a requirement for TfL to be clear on what is required. Kerry worked hard with CPO, Legal and others to get this created. My task was the easier bit of getting it on the external site and create some wording for our adverts. https://tfl.gov.uk/corporate/careers/our-vetting-process At Transport for London, safety, trust and fairness sit at the heart of how we recruit. Our Vetting Charter (link here) 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.   You must create an Indeed account before continuing to the company website to apply