Robert Walters
Financial Modelling
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Interim Financial Modeller
Salary: £600/day
Location: London
An esteemed global insurance services provider is seeking an Interim Financial Modeller to join their Group Finance team in London. This contract role offers a unique opportunity to design and build robust, well-documented Excel-based sub consolidation models that will shape the future of financial reporting within a large international group. With a focus on delivering clear, concise outputs and supporting internal stakeholders, you will play a pivotal part in enhancing transparency and auditability across multiple business units.
What you'll do:
- As an Interim Financial Modeller, you will be instrumental in shaping the financial reporting landscape by developing scalable Excel-based models that accommodate complex consolidations across numerous business units.
- Design and build Excel-based sub consolidation frameworks capable of handling over 200 trial balances and producing multiple business unit groupings driven by legal entity structure.
- Define model architecture to ensure formulas and structure remain simple yet provide appropriate controls, transparency, and auditability for all users.
- Implement adjustment layers within each sub consolidation to support manual consolidation adjustments such as reclasses, alignment adjustments, and eliminations at the consolidation level.
- Develop scalable approaches that allow for at least five initial sub consolidations with potential extension to ten or more views without requiring major redesigns.
- Enable the possibility of running separate 'what if' scenario views of the Group to support strategic decision-making processes.
- Build robust reconciliation routines so that the sum of sub consolidations plus manual adjustments aligns perfectly with the main Group consolidation outputs.
- Produce concise output packs including Profit Loss, Balance Sheet, and Cashflow by business view suitable for internal stakeholders and transaction workstreams at consolidated, sub consolidated, and legal entity levels.
- Create clear documentation detailing model design, usage instructions, and maintenance guidelines to ensure sustainability beyond the contract period.
- Engage closely with Group Consolidations & Reporting team members as well as other finance stakeholders to confirm reporting definitions and guarantee outputs are fit for purpose.
- Provide handover training sessions and transition materials so the internal team can confidently maintain the model after your assignment concludes.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
What you bring:
- Advanced Excel modelling skills demonstrated through previous experience building complex models within multi-currency environments for large international groups.
- Proven track record managing substantial volumes of trial balances and consolidating adjustments efficiently while maintaining high standards of accuracy.
- Strong financial background with deep understanding of Profit Loss statements, Balance Sheets, and Cash Flow analysis relevant to global organisations.
- Ability to design scalable frameworks that support multiple business unit groupings driven by legal entity structure without compromising simplicity or control.
- Experience implementing adjustment layers for manual consolidation entries such as reclasses or eliminations at various levels within financial models.
- Excellent documentation skills enabling clear communication of model architecture, usage instructions, and maintenance procedures for future users.
- Effective interpersonal skills allowing you to collaborate closely with finance stakeholders to confirm reporting definitions and ensure outputs meet organisational needs.
- Capacity to deliver concise output packs suitable for diverse internal audiences including transaction workstreams at consolidated or legal entity levels.
- Commitment to providing thorough handover training sessions along with transition materials that empower internal teams post-contract completion.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Nice to have:
- Familiarity with Cognos Controller software; proficiency in Power Query or VBA enhances your ability to automate processes but is not essential.
What's next:
If you are ready to make a meaningful impact on financial reporting within a supportive global organisation, apply now!
Apply today by clicking on the link provided.
Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills