Transport for London
Data Analyst - Business Intelligence
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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 Tuesday 1 September @ 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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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 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 meet 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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
Application Process
Please apply using your most recent CV and optional 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 Tuesday 1 September @ 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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location