Junior BI Analyst / Developer

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

Junior BI (Business Intelligence) Analyst / Developer (known as Report Running Assistant internally)

Grade/hay score: Band 1 - TFL

Contract: Permanent

Salary: Up to £32,500 (Based on Experience)

Location: Endeavour Square (Stratford) – Hybrid Working

Application closing date: Wednesday 15th October 2025 @ 23:59

Overview of Role

The role is responsible for the delivery of existing reporting through to the building and maintenance of dashboards / reports primarily in PowerBI, supplying high quality and prompt outputs for both the Business and the Reporting team. The role assesses report requests received from the business and applies the Reporting Policy to approve or escalate the requests as well as undertaking requirements gathering. The scope of the role includes supporting the Business and Reporting Team to deliver improvements in data quality and reporting efficiency, adopting a continuous improvement methodology and delivering a best-in-class service to the business.

Although the following should serve as an insight into the role there are plenty of areas to develop in technically (the ability to develop power automate routines, build powerapps and to develop skills in PowerBI, both in desktop and in Service) are just some examples. Equally, with time your knowledge of people and financial reporting within TfL will grow.

Main Accountabilities

• Running reports to the agreed quality standards to support the business
• Assisting with Report building as and when required
• Performing data reconciliation to ensure the quality of report outputs
• Gatekeeping requests for reports and amendments received from the business and escalating where necessary
• Holding discussions with requestors to understand requests and users’ needs
• Identifying opportunities for improvements within the reports and the team’s performance
• Communicating with stakeholders to resolve data issues and pro-actively seeking solutions to problems
• Maintaining internal team logs, business facing catalogues, and the team portal
• Updating internal trackers to ensure the prompt progression and escalation of requests

Skills, Knowledge & Experience

Skills

• High level of attention to detail and accuracy - Essential
• PowerBI or other visualisation software - Desirable
• Ideally advanced Excel (Macros, VBA, Power Query) - Essential
• Proficient user of Desktop Automate and/or Power Automate (Cloud) - Essential
• Familiar user in all standard MS (Microsoft) office Applications and/or Microsoft 365 - Essential
• Skilled at applying rules-based policy to situations and requests – Desirable
• Logical and methodical approach to problem solving - Essential

Knowledge

• Understanding of databases and ERP (Enterprise Resource Planning) systems, particularly SAP – Essential
• Aware of techniques to interpret, probe variances and present data – Essential
• Familiar with of analytical and reporting tools - Essential
• Good understanding of data protection considerations in a data analysis and reporting role - Essential

Experience

• Generating scheduled reports - Essential
• Using database systems - Essential
• Involved in regular reporting, including the collation of different information sources with excellent attention to detail – Essential
• Applying policy to requests – Desirable
• Experience of working in a Business Services or corporate environment - Desirable

Application Process

Please apply using your CV. Think carefully about the skills, knowledge and experience in the advert and cover this in your CV.

We may close this advert early if we receive a high volume of suitable applications.  

TfL is currently unable to provide sponsorship to candidates for this role as the Home Office’s eligibility criteria for sponsorship will not be met. TfL keeps its approach under review in line with changes to UK immigration rules. We are also unable to provide advice or guidance on individual immigration queries and advise candidates to check the Government’s website for further information. 

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