At a Glance
- Tasks: Build data infrastructure and create insightful Power BI dashboards for finance and projects.
- Company: Join Rail Delivery Group, a key player in the UK's rail transformation.
- Benefits: Enjoy 30 days annual leave, 75% rail travel discount, and flexible working options.
- Other info: Dynamic role with opportunities for personal development and career growth.
- Why this job: Be at the forefront of a major industry transition and make a real impact.
- Qualifications: Strong Power BI, SQL skills, and experience with data integration required.
The predicted salary is between 38162 - 50287 £ per year.
Description
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.
What is the purpose of this job?
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 .
What can I expect to do in this job?
- Data infrastructure
- Identify, connect and consolidate data from disparate business systems, including Net Suite, 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.
- Power BI reporting and dashboards
- 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.
- Ad hoc finance analysis / automation
- Support the Head of Commercial Finance, Head of Settlement & Treasury and 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.
Who will my key contacts be?
- Finance leadership (Head of Commercial Finance, Head of Settlement & Treasury and Finance 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, project management and operational data sources, including Net Suite, Cascade and Smartsheet.
- Data Analytics team
Requirements
Essential experience, skills and knowledge
- Strong hands-on experience building Power BI reports and data models, including Power Query, DAX and data modelling best practice.
- Experience integrating and structuring data from multiple, disparate source systems.
- Solid SQL skills for data extraction, transformation and querying.
- Comfortable working with finance, HR and 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.
Desirable experience
- 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 than maintaining an existing one.
- What success looks like
- A single source of truth for finance, people and 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.
Benefits
Why Work for RDG?
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
Financial Data Analyst FTC 6M in London employer: Rail Delivery Group
At Rail Delivery Group, we pride ourselves on being an exceptional employer that fosters a collaborative and inclusive work culture. As a strategic HR Partner, you will have the opportunity to lead impactful people initiatives within the dynamic rail industry, while benefiting from professional growth opportunities and a commitment to employee well-being. Located in the heart of the UK railway sector, our organisation offers a unique chance to shape the future of rail transport, making your work both meaningful and rewarding.
StudySmarter Expert Advice🤫
We think this is how you could land Financial Data Analyst FTC 6M in London
✨Join Financial Networking Events
Jump into local finance meetups and conferences — they’re a goldmine for temporary roles in banking and financial services. You can chat with industry professionals and even get leads on upcoming opportunities that might not be posted online yet.
✨Utilise Temp Agencies Specialised in Finance
Reach out to temp agencies that focus on the banking sector. They often have strong ties with various firms and can help you secure short-term gigs that can help beef up your CV and get your foot in the door at firms like Rail Delivery Group.
✨Connect with Alumni from Your Uni
Don't underestimate the power of your university’s alumni network. Many former students are working in banking and can help you find temporary roles or even offer mentorship. Reach out directly or attend alumni events to broaden your circle.
✨Stay Active on Job Boards and Company Websites
Keep your eyes peeled on job boards specifically for finance roles. Companies like Rail Delivery Group might post temporary positions directly on their sites, so make sure to apply there too. Set alerts to catch those roles the moment they go live!
We think you need these skills to ace Financial Data Analyst FTC 6M in London
Some tips for your application 🫡
Show Off Your Academic Achievements:In banking and financial services, your academic record can really make you stand out. List relevant grades, certifications, or coursework on your CV, especially if you've taken finance-related modules. This is particularly important for a temporary role where qualifications can help you shine even brighter!
Highlight Relevant Experience:If you’ve done any internships, part-time roles, or even coursework that aligns with banking or finance, make sure you include those! Showcase specific tasks where you used quantitative skills or analytical thinking, as this is what the hiring managers at Rail Delivery Group will be keen to see in your application.
Tailor Your Cover Letter Purposefully:When writing your cover letter, focus on why you’re interested in a temporary position at Rail Delivery Group. Let them know how you can quickly adapt to the team's needs and how eager you are to learn the ropes of the banking sector during this short stint. Your motivation and enthusiasm could really set you apart!
Be Prepared with References:For temporary roles, references can play a crucial role in your application. Make sure you’ve got a couple of references lined up who can vouch for your skills and work ethic. This helps to give Rail Delivery Group confidence in your short-term commitment to the role.
How to prepare for a job interview at Rail Delivery Group
✨Brush Up on Financial Regulations
Since this is a role in banking and financial services, be ready to discuss key regulations like MiFID, Basel III, or GDPR. These are hot topics, and your awareness of how they impact daily operations can give you a significant edge during your interview with Rail Delivery Group.
✨Showcase Your Analytical Skills
Prepare for interview questions that assess your analytical abilities. You might need to tackle hypothetical scenarios involving risk assessment or financial forecasting. Bringing examples of relevant projects or coursework can emphasise your practical understanding of these concepts.
✨Highlight Flexibility and Adaptability
For a temporary role, showing that you can quickly pick up new processes and tools is crucial. Be ready to discuss previous experiences where you had to adapt to changing requirements or tight deadlines, as this will reassure Rail Delivery Group that you’re a reliable team player.
✨Demonstrate a Willingness to Learn
In a temporary position, leaning into your eagerness to learn can really set you apart. Be prepared to share how you’re staying updated on industry trends or any additional training you've pursued. Employers appreciate candidates who are proactive about their development—even for short-term roles.
