Financial Modelling

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.

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.
• 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