Senior Finance Analyst - Reporting (3170)

GTR; United Kingdom; On-site; GBP 80,000 - 100,000; Full time

Job summary

A UK transport organization is seeking a Financial Analyst to provide comprehensive reporting and support for financial processes. The ideal candidate will have strong skills in Power BI and Excel, along with a degree and relevant qualifications. Responsibilities include maintaining reporting templates, managing ad-hoc requests, and ensuring accuracy in financial data. This role requires excellent analytical skills and commercial awareness.

Qualifications

• Educated to degree level or equivalent.
• ACA/ACCA/CIMA Qualified Accountant or equivalent.
• Good technical knowledge of IFRS.
• Excellent Power BI and financial system skills.
• Experience in preparing insight for stakeholders.

Responsibilities

• Maintain and update reporting templates for the DfT.
• Create and improve Power BI dashboards for reporting.
• Manage ad-hoc financial requests from stakeholders.
• Coordinate feedback on financial business cases.
• Troubleshoot ETL issues before escalation.

Skills

Power BI skills

Excel skills

IFRS knowledge

Data Analytics

Commercial awareness

Education

Degree level education

ACA/ACCA/CIMA Qualified Accountant

Tools

Power Query

Power Automate

Job description

Overview

Provides high quality and comprehensive reporting to DFT with focus on periodic management accounts, quarterly forecasts, and the annual business plan and address queries raised in a timely manner. Additionally, creating and supporting internal and board reporting views within Power BI and TM1. Furthermore, supports process improvement across the GTR Finance Community.

Responsibilities

• Maintain and update DfT reporting templates, including management accounts, assumptions records, and quarterly forecasts.
• Create and improve Power BI dashboards to support financial reporting, scoping requirements for new reports.
• Manage ad-hoc financial requests from key stakeholders, including Go-Ahead and the DfT.
• Own the period-end reporting file, ensuring the chart of accounts is accurately reflected.
• Provide financial support to projects across the business as needed.
• Drive greater use of Business Intelligence tools within the Finance team.
• Coordinate and provide feedback on financial business cases.
• Develop and manage automated processes (e.g., Power Automate).
• Act as Finance's data SME, working closely with the Data Analytics team.
• Document business use cases, scope model changes, and map data process flows.
• Troubleshoot first-level ETL issues before escalation to the DataHub team.
• Carry out data analysis and apply DAX formulas in Power BI to meet reporting needs.
• Manage report changes and permissions in collaboration with the central data team.
• Support data ingestion for approved datasets and ensure changes follow agreed pipelines.
• Stay up to date with data developments and complete training under GTR's 10-point data programme.

Skills, knowledge & experience

• Educated to degree level or equivalent
• ACA/ACCA/CIMA Qualified Accountant or equivalent
• Good technical knowledge of IFRS
• Data Analytics Qualification (desirable)
• Excellent Power BI and financial system skills
• Excellent Excel Skills
• Use of other tools such as Power Query and Power Automate
• Experience in preparing insight and concise commentary for internal or external stakeholders
• Experience of working within a finance team and a data driven role
• Evidence of commercial awareness and able to demonstrate a broad based view of issues, events and activities and a perception of their longer term impact or wider implications