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!
Key Information
Job title: Systems Specialist- (Business Intelligence -BI)
Salary: Circa £65K + TFL Benefits
Grade: Band 3
Contract type: TFL Reference: 3814
Team: PMO Project System Directorate: PMO
Contract details: Permanent Location: Endeavour Square- London/Hybrid*
Application closing date: Wednesday 24/06/2026 at 23:59
- Hybrid working within this role enables a balance of 50 per cent of time split between the office and home over a 4-week period. Hybrid working arrangements can evolve subject to business requirements.
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 project/role
We are seeking a proactive and technically skilled Business Intelligence (BI) specialist to join our PMO Systems Team. This role is vital in ensuring that our project management community has the right tools, systems, and insights to deliver effectively—both now and in the future.
You will work closely with the Systems Manager to provide deep technical expertise, supporting the development, maintenance, and optimisation of PMO systems. Acting as a key interface between Specialist Information Managers, project delivery teams (including Project Managers, Engineers, and supply chain partners), you will help resolve issues promptly and translate emerging user needs into practical solutions that improve daytoday operations.
In addition to these core responsibilities, we are looking for a Business Intelligence (BI) Specialist who will lead the creation, enhancement, and maintenance of BI reports and dashboards. You will collaborate closely with stakeholders across the organisation to gather requirements, build robust data models, and deliver clear, accurate, and actionable insights that support evidence-based decision making.
A key part of the role also involves developing strong, collaborative relationships with central TfL Tech & Data teams, ensuring sustained system performance, ongoing service provision, and alignment with future technical developments.
If you’re passionate about solving technical challenges, delivering meaningful data insights, and shaping how systems evolve to support business needs, this is an exciting opportunity to make a significant impact.
Note - This role may also be referred to as: "Power BI Developer", "Business Intelligence (BI) Developer"
Key Accountabilities
- To ensure that the Systems Manager has the technical capability at their disposal to fully support and maximise the value of specialist systems by providing in depth expert/developer level of the defined tool.
- Expert in Power BI solution design and governance, leveraging Power Query, Power Automate, and Dataflows to deliver enterprise-grade analytics, automation, and data integration capabilities.
- To support the Systems Manager in facilitating project set-up within relevant PMO systems. Ensure projects are appropriately closed out in the relevant PMO systems upon completion, including migration of information into business records and operational information systems.
- Undertake data analytics tasks as required to provide performance insights including data, manipulation, transfer and visualisation activities using database query, scripting/ programming and dashboard skills ensuring Information Managers and PMO Reporting Leads are provided with timely, accurate, reporting and analysis.
- Provide expert knowledge and support to the development and setting of PMO information strategy.
- Develop personal capability to provide basic support for other PMO Information Systems, such as but not limited to, planning, business information and reporting tools.
Skills, Knowledge & Experience
Skills
- Good influencing skills to manage and motivate teams in and outside of directorate and embed Systems management methodology and process in support of delivery of high risk, value and complex project and programmes.
- Specific technical skills are expert/developer level experience in their relevant expert system. (essential)
- Relevant coding experience for application e.g. Power BI, SQL and DAX. (essential)
Expert in (essential)
- Power BI Development & Administration
- Power Query (Data Transformation)
- Power Automate (Workflow Automation)
- Power BI Dataflows (Data Integration & Orchestration)
- Data Modelling & Reporting
- Dashboard & Visualisation Development
- Automated Data Pipelines
- The provision Information Management and Reporting. (essential)
- Planning and implementation of technical changes.
- Project Planning and scheduling of work (Primavera, P6 or MS Project).
Knowledge
- Extensive knowledge and understanding of capital projects and programmes with an emphasis on system supporting Integrated PMO Systems.
- Systems management & benchmarking and how this supports and integrates with a wider high functioning environment.
- Knowledge of Information Technology Infrastructure Library (ITIL) processes.
- Expert knowledge in using DAX, Power query, Power automate, Power BI and Dataflow.
- Extensive understanding of systems development approaches.
- Extensive knowledge in developing and building Power BI reports.
Experience
- Demonstrated experience within a PMO environment, with strong technical capability and the proven ability to translate (essential)
- complex datasets into clear, concise, and accessible information for a wide range of audiences. (essential)
- A collaborative and dependable team contributor, able to work independently across multiple business areas to
- understand challenges, identify root causes, and support the development of effective solutions. (essential)
- Proven ability to operate successfully in an agile, fast paced environment, managing multiple concurrent projects and adapting to evolving organisational priorities. (essential)
- Experience of creating, adapting and monitoring process around Project Control and information management systems planning in major projects and experience of implementing tools to support changes.
- Experience of developing and implementing product development strategies for comparable organisations.
- Experience of project managing information technology/ systems projects and managing IT vendors.
- Experience in using and dealing with Application Programming Interfaces (APIs) and data mapping.
- Experience in managing stakeholder in a complex matrix managed project environment.
Application Process
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.
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 or 75% reimbursement on a 28-day flexi ticket
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.