At a Glance
- Tasks: Build and maintain data infrastructure and 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: Experience in Power BI, SQL, and stakeholder management is essential.
The predicted salary is between 38162 - 50287 £ per year.
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 & 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.
Who will my key contacts be?
- Finance leadership (Head of Commercial Finance, Head of Settlement & Treasuryand 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, projectmanagementand operational data sources, including Net Suite, Cascade and Smartsheet.
- Data Analytics team
Essential experience, skillsand knowledge
- 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.
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 thanmaintainingan existing one.
- What success looks like
- 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.
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
- #J-18808-Ljbffr
Financial Data Analyst FTC 6M 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
✨Tip Number 1: Tap Into Professional Networks
The finance world loves a good connection, so jump into industry-specific groups on platforms like LinkedIn where you can find discussions on financial controlling. Engaging in these communities can expose you to hidden job leads that aren't openly advertised!
✨Tip Number 2: Attend Finance Events and Conferences
Make it a mission to attend finance-related events and conferences, even virtual ones! This is a golden opportunity to network face-to-face with people from companies like Rail Delivery Group. You never know who might be your next boss or a crucial contact!
✨Tip Number 3: Showcase Your Expertise
Consider writing articles or sharing insights related to financial controlling or industry trends. Publish these on platforms like LinkedIn to establish yourself as a knowledgeable player in the field. This not only increases your visibility but also catches the attention of recruiters from Rail Delivery Group.
✨Tip Number 4: Apply Directly on Company Websites
Since you're going for a full-time gig, don't forget to keep an eye on the careers page of companies you're interested in, like Rail Delivery Group. Many companies prefer candidates who apply through their website as it shows genuine interest and makes your application stand out!
We think you need these skills to ace Financial Data Analyst FTC 6M
Some tips for your application 🫡
Show Off Your Numbers Game:In financial controlling, detail is everything! Make sure your CV showcases your proficiency with numbers—highlight any relevant experience in budgeting, forecasting, or working with financial software. Quantifying your past achievements will make you stand out, so don’t be shy about flaunting those impressive percentages or cost savings you've implemented.
Tailored Cover Letter is Key:Your cover letter is a chance to shine, especially for a full-time role. Use it to express your genuine interest in Rail Delivery Group and the specific impact you hope to make in financial controlling. Mention any relevant qualifications or experiences that align with the company’s goals, and don’t forget to show that you're ready for a long-term commitment!
Certifications Matter:List relevant certifications such as ACCA or CIMA on your CV. These qualifications not only showcase your dedication to the field but also your technical competence in financial principles. If you have any ongoing training or courses, make sure to mention those as well to demonstrate your commitment to continual learning in financial controlling.
Don’t Overlook Soft Skills:While numbers are crucial, so are those soft skills! Financial controllers need strong communication and analytical reasoning abilities. We recommend embedding examples of these skills in your CV and cover letter, like how you’ve successfully delivered financial reports to stakeholders or collaborated with teams to improve processes. Let’s show Rail Delivery Group how you can be a team player!
How to prepare for a job interview at Rail Delivery Group
✨Brush Up on Technical Skills
Make sure you're comfortable with key financial concepts, especially around forecasting, budgeting, and variance analysis. Sometimes, interviewers may throw in technical questions or case studies, so practicing these types of scenarios will help you shine!
✨Showcase Your Financial Acumen
If you've had experience with specific financial software like SAP or Oracle, make it known! Be ready to discuss how you used these tools to improve processes or reporting, as this hands-on knowledge can really set you apart in a full-time role with Rail Delivery Group.
✨Know Your Numbers
In full-time interviews, especially in financial controlling, be prepared for numerical reasoning tests or questions. Brush up on your mental maths and understand how to interpret and analyse financial statements on the spot, as this may come up during the assessment.
✨Connect with Company Goals
Familiarise yourself with Rail Delivery Group's financial objectives and any recent developments. During the interview, try to weave your understanding of their business model and challenges into your answers—this shows your genuine interest and alignment with their goals!
