Senior Finance Analyst – Reporting

About the role :-

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.

Duties to include  :-

•    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