Financial Modelling Analyst

We have been retained by a leading provider of Real Estate Finance, in their search for a Financial Modelling Analyst. Our client has a track record of funding +£7bn of real estate projects and offers a series of structured credit solutions across Bridging Finance, Development Finance and bespoke Lending Solutions. They are increasing their European footprint and expanding their back-office functions to support current and continued growth, this is a key hire.

Reporting to, and working closely with, the Head of Financial Analytics the post holder will be highly visible across the Group and will liaise with a range of internal and external stakeholders including the Board and Advisors. The Financial Modelling Analyst will build, maintain, and update financial models using advanced mathematical and statistical concepts to support decision-making, forecasting, and budgeting for various product lines and sophisticated debt products. They will also conduct quantitative financial analysis to support business strategies and plans, provide actionable insights and recommendations to management based on robust financial analysis and modelling results, and collaborate with other departments to gather, process, and analyse large datasets required for financial modelling.

Key responsibilities:

Build, maintain, and update financial models using mathematical and statistical methods to support decision-making, forecasting, and budgeting for various product lines and debt products.
Conduct rigorous quantitative financial analysis to support business strategies and plans.
Provide actionable insights and recommendations to management based on robust financial analysis and modelling results.
Collaborate with other departments to gather, process, and analyse large datasets required for financial modelling.
Use VBA and SQL to automate routine complex reports and build user-friendly models.
Analyse and problem-solve using structured, clear, tidy, methodical, and logical approaches to modelling.
Continuously improve analytical and reporting processes and communicate complex concepts in a simple way.
Manage multiple work streams under tight deadlines and work collaboratively across the business.
Deliver reports according to a strict schedule to external institutional stakeholders.
Support the finance function in developing revenue models and optimising portfolio treasury allocations and performance.
Develop and manage Cash Management Reporting processes for Back Leverage providers (Senior Leverage), ensuring timely and accurate reporting aligned with lender requirements:
Create and maintain detailed cash flow reports that highlight inflows, outflows, and liquidity positions.
Monitor compliance with financial covenants and proactively identify potential issues.
Coordinate with treasury and accounting teams to reconcile cash movements and ensure accuracy in reporting.
Provide scenario analysis and stress testing of cash flows to assess the impact of various market or operational conditions.
Develop dashboards and tools to streamline cash management insights for stakeholders.
Communicate findings and recommendations clearly to senior leadership and external lenders.
Work closely with treasury and credit teams to ensure the seamless flow of cash reporting, compliance, and alignment with back leverage covenants.

Requirements:

Bachelor's degree in a science or mathematical field with a high degree of competency in both VBA and SQL.
Analytical and problem-solving skills.
Familiarity with sophisticated debt products, including senior, junior, mezzanine constructs, asset-backed leverage is compulsory
Familiarity with running scenarios to optimise portfolio treasury allocations and performance.
Experience in Cash Management Reporting for Back Leverage providers (Senior Leverage).
Ability to work under pressure and to tight deadlines in a fast-paced environment.
Strong communication skills to explain complex concepts to non-technical stakeholders.
Experience building Excel models from scratch and automating complex reports.
Ability to work flexibly and adapt to changing priorities and deadlines.
CFA, FRM, or other quantitative certifications are a plus.

We are seeking someone with experience in a securitisation and senior leverage environment. You will need to be ambitious, curious, driven and entrepreneurial