Senior Financial Modelling Analyst

Murray McIntosh; Greater London; On-site; GBP 50,000 - 90,000; Full time

Job summary

An established industry player in Real Estate Finance is seeking a Financial Modelling Analyst to join their growing team. This role involves building and updating complex financial models, conducting rigorous analysis, and providing actionable insights to management. The successful candidate will collaborate across departments, ensuring accurate cash management and compliance with financial covenants. If you're driven, analytical, and ready to make an impact in a fast-paced environment, this opportunity is perfect for you.

Qualifications

• Experience in building Excel models and automating reports.
• Strong analytical skills with a focus on financial modelling.

Responsibilities

• Build and maintain financial models for decision-making and forecasting.
• Conduct quantitative analysis to support business strategies.

Skills

VBA

SQL

Analytical Skills

Problem-Solving Skills

Financial Analysis

Cash Management Reporting

Education

Bachelor’s degree in a science or mathematical field

CFA, FRM, or other quantitative certifications

Tools

Excel

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Murray McIntosh. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

Direct message the job poster from Murray McIntosh

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, making this 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:

1. 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.
2. Conduct rigorous quantitative financial analysis to support business strategies and plans.
3. Provide actionable insights and recommendations to management based on robust financial analysis and modelling results.
4. Collaborate with other departments to gather, process, and analyse large datasets required for financial modelling.
5. Use VBA and SQL to automate routine complex reports and build user-friendly models.
6. Analyse and problem solve using structured, clear, tidy, methodical, and logical approaches to modelling.
7. Continuously improve analytical and reporting processes and communicate complex concepts in a simple way.
8. Manage multiple workstreams under tight deadlines and work collaboratively across the business.
9. Deliver reports according to a strict schedule to external institutional stakeholders.
10. Support the finance function in developing revenue models and optimising portfolio treasury allocations and performance.
11. Develop and manage Cash Management Reporting processes for Back Leverage providers (Senior Leverage), ensuring timely and accurate reporting aligned with lender requirements:
12. Create and maintain detailed cash flow reports that highlight inflows, outflows, and liquidity positions.
13. Monitor compliance with financial covenants and proactively identify potential issues.
14. Coordinate with treasury and accounting teams to reconcile cash movements and ensure accuracy in reporting.
15. Provide scenario analysis and stress testing of cash flows to assess the impact of various market or operational conditions.
16. Develop dashboards and tools to streamline cash management insights for stakeholders.
17. Communicate findings and recommendations clearly to senior leadership and external lenders.
18. 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 high competency in VBA and SQL.
• Strong analytical and problem-solving skills.
• Familiarity with sophisticated debt products, including senior, junior, mezzanine constructs, asset-backed leverage.
• Experience 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 meet 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 seek someone with experience in securitisation and senior leverage environments. You should be ambitious, curious, driven, and entrepreneurial.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Analyst, Finance, and Accounting/Auditing

Industries

• Real Estate, Financial Services, and Investment Management