Financial Data Analyst FTC 6M
Rail Delivery Group
An application made for this job — a tailored resume and cover letter that speak straight to the posting.
Benefits offered by this job
Job summary
Rail Delivery Group is seeking an experienced Financial Data Analyst to design, build and operate data pipelines and a robust Power BI reporting layer across finance, people and projects. You will partner with Finance leadership to deliver automated insights and scalable dashboards supporting GBR transition decisions.
The role combines hands-on data engineering with governance, data modelling and stakeholder engagement, ensuring high-quality, timely information for Day One planning and ongoing
Qualifications
- Strong hands-on experience building Power BI reports and data models.
- Experience integrating data from multiple, disparate source systems.
- Solid SQL skills for data extraction, transformation and querying.
- Strong stakeholder management and data governance focus.
- Experience with data automation and ETL is desirable.
Responsibilities
- Design and own data pipelines from multiple systems to a central reporting layer.
- Build and maintain Power BI dashboards across finance, people and projects.
- Support ad hoc analytical deliverables and scenario modelling.
- Provide automation and governance to ensure reliable data.
Skills
Tools
Job description
Closing date: 30 September 2026
Salary range - £38,162 to £50,287
As the industry transitions to Great British Railways (GBR), bringing track and train together under a single guiding mind and moving towards public ownership, we are looking for an experienced Financial Data Analyst to join Rail Delivery Group (RDG) and play a pivotal role in preparing our organisation for this transition. Working across people, processes, culture and organisational design, you'll help ensure RDG is ready for Day One of GBR and the phased transition leading up to this.
If you thrive in complex environments, enjoy influencing senior stakeholders and want to be at the heart of one of the UK's most important transformation programmes, we'd love to hear from you.
Finance efficiency, transparency and automation. To build the reporting and data infrastructure that underpins finance, people and project decision-making across RDG. The role will design and own data pipelines from multiple business systems, creating a reliable reporting layer and a suite of Power BI dashboards used across the organisation. The role will also provide ad hoc analytical and automation support to the Commercial Finance team and wider Finance function.
This is a hands-on build-from-the-ground-up role, suited to someone who enjoys both finance, data modelling, ETL and source integration, as well as dashboard design and stakeholder-facing insight.
- Identify, connect and consolidate data from disparate business systems, including NetSuite, Cascade, Smartsheet and other operational sources.
- Design and set up robust ETL and data pipelines to ensure clean, reliable and timely data flows into a central reporting layer with low ongoing maintenance.
- Build a scalable data model, such as a star schema, to support fast, flexible reporting rather than one-off extracts.
- Establish data governance practices, including naming conventions, refresh schedules, version control and documentation, so the reporting suite remains maintainable as it grows.
- After dashboard go-live, troubleshoot data quality issues at source with Finance Business Partner teams and put checks in place to catch issues early.
- Design, build and maintain Power BI dashboards across finance, people and projects.
- For finance reporting, support insight across P&L, budget versus actuals, cash flow and cost centre performance.
- For people reporting, support headcount, attrition, hiring pipeline, pay and compa-ratio tracking.
- For project reporting, support delivery status, resourcing, budget burn and milestone tracking.
- Translate business questions into clear, intuitive visualisations that non-technical stakeholders can self-serve from.
- Own the end-to-end DAX and data modelling layer, balancing performance with flexibility.
- Roll out dashboards with appropriate access controls, including row-level security where needed, and train users on how to use them.
- Support the Head of Commercial Finance, Head of Settlement & Treasuryand wider Finance team with one-off analytical deliverables, including scenario modelling, automation, variance analysis and business case support.
- Respond flexibly to emerging data requests from across the business, prioritising requests against the core infrastructure roadmap.
- Finance leadership (Head of Commercial Finance,Head of Settlement & TreasuryandFinance Director)
- Wider Finance team, including Finance Business Partner teams.
- Non-technical business users and stakeholders who need self-serve insight from dashboards.
- Owners and users of finance, HR, projectmanagementand operational data sources, including NetSuite, Cascade and Smartsheet.
- Data Analytics team
- Strong hands-on experience building Power BI reports and data models, including Power Query,DAXand data modelling best practice.
- Experience integrating and structuring data from multiple, disparate source systems.
- Solid SQL skills for data extraction,transformationand querying.
- Comfortable working with finance,HRand project data simultaneously, with the ability to understand the underlying business logic of each area.
- Strong stakeholder management skills, including the ability to work with non-technical business users to scope requirements and explain outputs.
- High attention to detail and a strong instinct for data quality and governance.
- Experience with ETL or data pipeline tools, such as Power Automate, Azure Data Factory or Dataflows.
- Experience working within or alongside a finance function, such as FP&A or management accounts.
- Familiarity with Azure or cloud data platforms.
- Prior experience setting up a reporting function from scratch, rather thanmaintainingan existing one.
- A single sourceof truth for finance,peopleand project data, with reliable automated refreshes.
- A suite of dashboards that are actively used and trusted across the business, reducing manual reporting requests.
- Fast turnaround on ad hoc analytical requests, without compromising the integrity of the core reporting build.
We offer a highly competitive package, including:
- 75% discount on rail travel (for work and leisure), plus international rail discounts
- 30 Days annual leave (plus buy/sell options and additional leave for key life events)
- Two Personal Development Days are granted to employees annually
- Interest-free Season Ticket Loan for commuting costs
- Enhanced family leave – 30 weeks full pay for maternity, adoption, surrogacy, and shared parental leave
- Pension scheme – up to 8.64% employer contribution
- Subsidised Private Medical Insurance (Vitality PPP) and Health Cash Plan (Healthshield)
- Access to our flexible benefits portal - a central hub for accessing retail discounts, shopping, dining, travel, and entertainment perks
- Flexible working arrangements available
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
