Reporting and BI Developer - Power BI

Transport for London; City Of London; On-site; GBP 43,000 - 46,000; Full time

Benefits offered by this job

Final salary pension scheme

Free travel on TfL network

25% National Rail/28-day flexi ticket

30 days annual leave

Hybrid working

Private healthcare (optional)

Cycle-to-work

Discounted Eurostar travel

Job summary

Transport for London is seeking a Reporting & BI Developer to manage Power BI reporting and related Microsoft technologies. You will work with Finance, HR and the wider business to understand needs and deliver accurate, accessible insights.

You will maintain and evolve reporting, manage data extraction, transformation, modelling and calculations, and handle ad hoc requests including FOI while ensuring compliance and data quality.

Qualifications

• Understanding of BI, reporting and data analysis principles.
• End-to-end reporting lifecycle from source to presentation.
• Data modelling and data-quality principles and their impact on reporting.
• Validation, controls and documentation when producing business information.

Responsibilities

• Maintain and improve Power BI reports and reporting solutions.
• Develop understanding of end-to-end reporting lifecycle and data sources.
• Collaborate with stakeholders to understand requirements and data availability.
• Develop data extraction, transformation, data modelling and DAX for new reporting needs.
• Design, develop and maintain clear Power BI reports and dashboards for user insight.
• Investigate data quality issues and trace issues through reporting process.
• Respond to ad hoc requests (including FOI) using existing reporting or new data.

Skills

Power BI

Data analysis

DAX

Power Query

Data modelling

Stakeholder communication

FOI handling

Tools

Power BI Service

Job description

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

Reporting and BI Developer - Power BI (internally - Report Building Specialist)

Grade:

Pay Band 2

Contract:

Permanent

Location:

Endeavour Square, Stratford

Salary:

£43,000 - £46,000 Based on experience and current salary

Application Closing date:

Monday 26th October 2026 @ 23:59

Overview of Role

As a Reporting & BI Developer, you will help maintain, develop and continuously improve a portfolio of business reporting, primarily using Power BI and related Microsoft technologies.

You will work with stakeholders across Finance, HR and the wider business to understand their reporting and information needs and translate these into accurate, accessible and maintainable reporting solutions.

A significant part of the role involves supporting and evolving existing reporting. This requires an understanding of the complete reporting lifecycle, including where data comes from, how it is extracted and transformed, how it is modelled and calculated, and how information is ultimately presented to users.

Where new reporting requirements arise, you may work end-to-end to identify appropriate data sources, establish extraction and transformation processes, develop data models and calculations, and build reports and dashboards that enable users to understand and act on the information.

The role will also respond to ad hoc analytical and information requests, including Freedom of Information (FOI) requests, which may require investigation of existing reporting, extraction of additional data and analysis or manipulation of information to provide accurate and defensible responses.

Key Accountabilities

• Maintain, support and continuously improve existing Power BI reports and reporting solutions, ensuring they remain accurate, relevant and aligned with changing business requirements.


• Develop a thorough understanding of reporting solutions across the end-to-end lifecycle, including source data, extraction and transformation processes, data models, calculations and reporting outputs.


• Work with stakeholders to understand business questions and reporting requirements, assess feasibility and data availability, and determine the most appropriate approach to delivery.


• Identify and evaluate appropriate data sources and develop and maintain the extraction, transformation, data modelling and DAX required to support new and evolving reporting requirements.


• Design, develop and maintain clear, accessible and effective Power BI reports and dashboards that enable users to understand and act on information.


• Investigate discrepancies, anomalies and data quality issues, tracing information through the reporting process to identify underlying causes and escalating issues appropriately.


• Respond to ad hoc analytical and information requests, including FOI requests, using existing reporting or sourcing, extracting and analysing additional data where required.


• Validate and document reporting solutions and analytical outputs, ensuring appropriate accuracy, maintainability and compliance with relevant legal, organisational, information governance, security and accessibility requirements.

Knowledge, Skills & Experience

Knowledge

Essential

• Understanding of business intelligence, reporting and data analysis principles.


• Understanding of the end-to-end reporting lifecycle, from source and extraction through transformation, modelling and calculation to presentation.


• Understanding of data modelling and data-quality principles and their impact on effective reporting.


• Understanding of appropriate validation, controls and documentation when producing business information.

Desirable

• Knowledge of SAP ECC, SAP SuccessFactors or other enterprise business systems.


• Understanding of FOI and other statutory or corporate information requirements.

Essential Skills & Experience

Essential

• Strong Power BI development experience, including creating, maintaining and improving reports, data models, relationships, DAX calculations and measures.


• Experience of using Power Query, Power BI Service dataflows or comparable technologies to extract, transform and prepare data for reporting.


• Ability to investigate unfamiliar datasets and reporting solutions, understand their structure and trace issues through source data, transformations, models, calculations and presentation.


• Strong analytical and problem‑solving skills, with experience of using data from multiple sources to answer business questions and ad hoc information requests.


• Experience of gathering and interpreting stakeholder requirements and translating them into appropriate reporting or analytical solutions.


• Ability to communicate complex data and reporting concepts clearly to technical and non-technical stakeholders.


• Ability to manage competing reporting, maintenance and analytical requirements while working independently and collaboratively with data owners, subject matter experts and stakeholders.


• Experience of handling business‑critical or sensitive information with appropriate accuracy and control.

Desirable

• Experience of developing reporting solutions from initial requirement and data identification through to delivery and ongoing support.


• Experience of responding to FOI, statutory, audit or other formal information requests.


• Experience of SAP ECC, SAP SuccessFactors or other large enterprise data sources.


• Experience of working in a large or complex organisation.


• Experience of using Power Automate and Power Apps alongside Power BI to support reporting, data and workflow solutions.

Equality and Diversity

We are committed to equality, diversity and inclusion and aim to reflect the diverse communities we serve. We believe that a diverse workforce enables us to deliver better services and outcomes. Our goal is to make our recruitment as inclusive as possible. As a Disability Confident Leader, we actively encourage applications from disabled people. As part of the Disability Confident scheme, we aim to offer an assessment or interview to candidates who apply via the scheme where the minimum essential criteria for skills, knowledge and experience has been met. In some circumstances, it may not be practical to offer an interview or assessment to every candidate who applies through the scheme and meet the minimum essential criteria; in these situations, we select candidates who best meet the minimum criteria for the job rather than interviewing all who meet them.

Across all recruitment activity, we recognise that selection methods may vary depending on the nature and scale of the campaign and will be applied fairly, consistently and proportionately in line with our Disability Confident commitments.

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

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.

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

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.

We will make every effort to give you as much notice as possible, however some interviews/assessments could be organised at short notice.