Data Analyst - Business Intelligence

Transport for London; Greater London; Hybrid; GBP 32,000 - 43,000; Full time

Benefits offered by this job

Final salary pension

Free TfL travel

Rail travel reimbursement

30 days annual leave

Hybrid working

Private health care

Cycle-to-work

Discounted travel

Eurostar discount

Job summary

Transport for London is seeking a Data Analyst - Business Intelligence to join the Asset Strategy team in London. The role focuses on building Asset Investment Models and delivering data-driven insights that shape investment planning and asset renewal across the network.

You will develop reporting and analytics using Power BI, SQL, DAX and M, including spatial data, to support capital programmes. The role offers a hybrid working pattern and strong progression opportunities.

Qualifications

• Experience interpreting, analysing and manipulating complex datasets (including spatial) from multiple sources with statistics.

Responsibilities

• Develop and maintain Asset Investment Models within TfL's Decision Support System.
• Create and maintain management reports using Power BI, M, DAX, SQL and Excel.
• Improve data quality by identifying errors and gaps in asset datasets.
• Analyse data from multiple sources to provide insights for investment decisions.

Skills

Power BI

M

DAX

SQL

R

Excel

GIS

SharePoint

Education

CS degree

GIS knowledge

Tools

Power BI

QGIS

SharePoint

SQL

Job description

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.

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.

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.

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.