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.

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.

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