Systems Specialist - Business Intelligence (BI)

Transport for London
London, UK
7 days ago
Apply on www.collegerecruiter.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Part-time (≤ 32 hours)
Compensation
£65,000.0
Working hours
Regular working hours

Tech stack

Application Programming Interfaces (APIs) Encodings Information Systems Computer Programming Database Queries Data Flow Control Information Management Microsoft Project Primavera Systems Development Life Cycle Power BI SQL Databases
+9 more
Data Processing Scripting Microsoft Power Automate Powerquery Information Technology Data Analytics Operational Systems Tools for Reporting Data Pipelines

Job description

Hybrid working allows a balance of 50 percent of time split between the office and home over a 4-week period. Arrangements can evolve subject to business requirements., We are seeking a proactive, technically skilled Business Intelligence (BI) specialist to join our PMO Systems Team. The role supports the development, maintenance, and optimisation of PMO systems, acting as a key interface between Specialist Information Managers, project delivery teams, and ensuring timely resolution of issues. You will also lead the creation, enhancement, and maintenance of BI reports and dashboards, collaborating with stakeholders to deliver actionable insights., * Provide expert support and development for specialist systems, enabling the Systems Manager to maximise system value.

  • Design and govern Power BI solutions using Power Query, Power Automate, and Dataflows for enterprise-grade analytics, automation, and integration.
  • Facilitate project set-up within PMO systems and ensure proper project close-out, migrating information into business records and operational systems.
  • Conduct data analytics tasks-data manipulation, transfer, and visualisation-using database query, scripting, and dashboard skills, delivering timely, accurate reporting to Information Managers and PMO Reporting Leads.
  • Support the development and implementation of the PMO information strategy.
  • Provide basic support for other PMO information systems (planning, business information and reporting tools).

Requirements

  • Strong influencing skills to manage and motivate teams across the directorate, embedding systems management methodology and process.
  • Expert/developer level experience in relevant systems (essential).
  • Essential coding experience in Power BI, SQL, and DAX.
  • Expertise in Power BI Development & Administration, Power Query, Power Automate, Power BI Dataflows, Data Modelling & Reporting, Dashboard & Visualisation Development, Automated Data Pipelines, and Information Management and Reporting.
  • Planning and implementation of technical changes; project planning and scheduling of work using Primavera, P6 or MS Project.
  • Extensive knowledge of capital projects and programmes, Integrated PMO systems, ITIL processes, DAX, Power Query, Power Automate, Power BI, Dataflow, systems development approaches, and building Power BI reports.
  • Experience within a PMO environment with strong technical capability, translating complex datasets into clear, concise information for diverse audiences.
  • Collaborative team contributor able to work independently across multiple business areas.
  • Proven ability to operate in an agile, fast-paced environment, managing multiple concurrent projects and adapting to evolving priorities.
  • Experience creating, adapting, and monitoring processes around Project Control and information management systems; implementing tools for change.
  • Experience in project-managing information technology/systems projects and managing IT vendors.
  • Experience with APIs and data mapping.Stakeholder management in a complex matrix-managed project environment.

Benefits & conditions

  • Final salary pension scheme
  • Free travel on the TfL network
  • 75 % reimbursement of standard class ticket for National Rail travel or 28-day flexi ticket
  • 30 days annual leave plus public and bank holidays
  • Hybrid working approach where business and role requirements allow
  • Optional private healthcare discounted scheme
  • Tax-efficient cycle-to-work programme
  • Retail, health, leisure and travel offers
  • Discounted Eurostar travel

J-18808-Ljbffr

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.collegerecruiter.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:06 min

Developer experience and project variety at scale

Alexandra Petri · World Congress 2023

1:04 min

Introduction to Bitcoin script parsing tools

Steve Shadders · LIVE

3:17 min

Optimizing character encoding with Kim variable byte encoding

Douglas Crockford Douglas Crockford · World Congress 2024

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

1:53 min

Evaluating traditional scripting languages for modern development tasks

Jens Knipper Jens Knipper · Europe 2026 Virtual

Videos

See all

Related articles

See all