Systems Specialist - Business Intelligence (BI)

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

• Grade: Band 3
• Contract type: TFL
• Reference: 3814
• Team: PMO Project System
• Directorate: PMO
• 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.

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 day-to-day 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.

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.
• 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. Blocky, Jscript, Power BI and MS InfoPath. (essential)
• Delivery skills: 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.
• Expert and developer knowledge in working with specialist system e.g. Asite.
• Knowledge of Information Technology Infrastructure Library (ITIL) processes.
• Extensive understanding of systems development approaches.
• Extensive knowledge in developing and building Power BI reports.
• Expert knowledge in the use of coding relevant to a specialist application (e.g. Blocky for Asite).
• Expert knowledge in using Jscript.
• Expert knowledge in working with enabling technologies (e.g. MS InfoPath for Asite).

Experience

• Demonstrated experience within a PMO environment, with strong technical capability and the proven ability to translate 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 stakeholders in a complex matrix managed project environment.

Application Process

You will need to provide both an up‑to‑date CV and a one‑page covering letter as part of your application. Think carefully about the skills, knowledge and experience in the advert and cover this in your CV. PDF format preferred and do not include any photographs or images.

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.

Vetting Process

At Transport for London, safety, trust and fairness sit at the heart of how we recruit. Our Vetting Charter 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

• 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.