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!
Job Title: Data Analyst – Business Intelligence
Grade: Band 2
Salary: Circa £37,500 (dependent on skill, knowledge and experience)
Contract Type: Permanent / Full Time / Hybrid
Reference: SF4355
Location: Southwark, SE1 8JZ
Hybrid working, within this role enables a balance of 50% of time split between the office and home over a 4-week period. Hybrid working arrangements can evolve subject to business requirements.
The closing date for applications is Sunday 17 May @ 23:59
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.
Overview of Role
Join TfL’s Asset Strategy team at the heart of London’s long‑term asset renewal and investment planning, where data directly shapes how we keep the network safe and reliable. As a Data Analyst, you’ll help build and evolve our Asset Investment Models within TfL’s Decision Support System, turning complex asset inventory and performance data into clear, evidence‑led investment plans. You’ll develop and maintain impactful reporting and analytics products using tools like Power BI. If you love combining data, problem‑solving and real‑world impact, this is a chance to see your work directly influence the future of London’s transport network.
Key Accountabilities
- Support the development of Asset Investment Models using TfL’s Decision Support System.
- Develop and maintain business reporting using standard tools and coding languages, e.g. Power BI, M, DAX, SQL, to investment decisions and capital programmes and.
- Support asset data quality improvements through identifying errors, gaps and omissions in various asset datasets.
- Interpret, manipulate and analyse data from multiple sources and databases to deliver greater insight and more value from our asset inventory data.
- Provide accurate and timely outputs that can be understood by stakeholders with varying technical knowledge.
- Provide analysis of multiple data sources using statistical and system tools/techniques.
- Develop supporting material and provide training and guidance when necessary for tools and reports created by the team.
Skills, Knowledge & Experience
Skills & Experience
- Experience in interpreting, analysing and manipulating complex datasets (including spatial) from multiple sources through applying statistical techniques, quantitative methodologies and system tools.
- Experience in developing and maintaining management reports using Microsoft tools and coding languages (e.g. Power BI, M, DAX, SQL, MS Excel).
- Experience in coding in R (Essential).
- Experience of document management systems (e.g. SharePoint).
- Experience in the use of GIS software such as QGIS.
- Experience in working and supporting asset management systems. You will have experience with engaging with a wide range of stakeholders to capture requirements for data (including spatial) analysis and reporting.
- Good written and oral communication skills, including the ability to present information to non-technical stakeholders.
Knowledge
- Degree in computer science, data analysis or information management; including Geographical Information Systems (GIS), or a similar area or equivalent business experience.
- Good understanding of broad range of information management systems; including asset management, GIS and workflow systems.
- Understanding of principles of asset management.
- Good understanding of reporting packages, databases and programming languages (e.g. SQL) for the querying, extracting and analysis of asset data.
- Good understanding of quantitative and statistical approaches for gaining insight into data.
- Good understanding of industry best practises, approaches and tools for data analytics and insight.
- Understanding of data visualisation tools (e.g. Power BI) together with dashboard and report design good practice.
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.
Application Process
Please apply using your most recent CV and mandatory 1 page Cover Letter (Word format only) explaining how you meet the criteria listed under the section ‘Role Requirements’, with reference to the skills, knowledge and experience you have gained at expert level.
You are encouraged to apply for the position that is most relevant to your existing skills, knowledge and experience as shortlisting is carried out on the basis of how well you meet the criteria for the role.
The closing date for applications is Sunday 17 May @ 23:59
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.
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.