> Markdown version of [/jobs/ext/2308284-systems-specialist-business-intelligence-bi](https://www.wearedevelopers.com/jobs/ext/2308284-systems-specialist-business-intelligence-bi). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Systems Specialist - Business Intelligence (BI) - **Company:** Transport for London - **Location:** London, UK - **Salary:** £65,000.0 - **Contract:** Permanent contract - **Skills:** 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, Data Processing, Scripting, Microsoft Power Automate, Powerquery, Information Technology, Data Analytics, Operational Systems, Tools for Reporting, Data Pipelines - **Published:** August 30, 2026 - **Apply:** https://www.collegerecruiter.com/job/2815439383-systems-specialist-business-intelligence-bi ## About the Role * 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. ## 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). ## Related Videos - [Why make use of an integration platform in today's software developments and infrastructure?](https://www.wearedevelopers.com/videos/758-why-make-use-of-an-integration-platform-in-today-s-software-developments-and-infrastructure) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java) - [A Brief History of Data Storage](https://www.wearedevelopers.com/videos/974-a-brief-history-of-data-storage) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Bitcoin transactions- embedding and using data for applications built on Bitcoin SV](https://www.wearedevelopers.com/videos/152-bitcoin-transactions-embedding-and-using-data-for-applications-built-on-bitcoin-sv) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [IT Salaries in UK](https://www.wearedevelopers.com/magazine/288-it-salaries-in-uk) - [UK Business Culture and Etiquette](https://www.wearedevelopers.com/magazine/326-uk-business-culture-and-etiquette) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)