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: 50% office, 50% home over a 4-week period. Arrangements can evolve per business needs.
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 support investment decisions and capital programmes.
- 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 & 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 using GIS software such as QGIS.
- Experience in working and supporting asset management systems; engaging 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 a 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 practices, 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.
Benefits
- 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
#J-18808-Ljbffr