Strategic FP&A Analyst - Real Estate Portfolio (Hybrid)

The Crown Estate; Windsor; Hybrid; GBP 50,000 - 70,000; Full time

Benefits offered by this job

Competitive salary

Pension

Performance bonus

Flexible working

Family policies

Private healthcare

Life cover

Critical illness cover

28 days holiday + buy more

Volunteering days

Job summary

The Crown Estate is seeking a qualified finance professional to own monthly reporting, budgeting and forecasting, and to drive continuous improvement across the function. You will partner with asset managers, managing agents and internal teams to deliver accurate analysis and actionable insights.

Reporting to the Commercial Finance Manager, the role emphasizes enhanced MI, automation and data-driven decision making across a diverse portfolio, with hybrid working arrangements and broad

Qualifications

• Qualified accounting professional (ACA/ACCA/CIMA).
• Approx. 4–5 years of relevant commercial finance experience.
• Strong budgeting & forecasting knowledge.
• Experience with month-end processes and variance analysis.
• Advanced Excel modelling, lookups & pivots.
• Experience creating dashboards and data visualisations.

Responsibilities

• Own monthly management reporting with variance analysis and portfolio performance.
• Lead annual budgeting and quarterly forecasting with stakeholders.
• Partner with budget holders and operational teams to analyse performance and risks.
• Oversee month-end activities including accruals and journals.
• Enhance MI using Excel, Power BI and self-service dashboards.
• Extract and reconcile data from multiple systems for reporting.
• Provide financial analysis for business cases and investment appraisals.
• Manage capital expenditure reporting and project tracking.
• Build strong stakeholder relationships and drive process improvements.
• Produce clear financial insights for finance and non-finance audiences.

Skills

Budgeting

Forecasting

Month-end processes

Variance analysis

Advanced Excel

Power BI

Power Query

Anaplan

Stakeholder management

Automation

Business partnering

Data interpretation

Education

ACA/ACCA/CIMA qualification

Tools

Power BI

Power Query

Anaplan

Agresso/Unit4

Job description

The Crown Estate is seeking a qualified finance professional to own monthly reporting, budgeting and forecasting, and to drive continuous improvement across the function. You will partner with asset managers, managing agents and internal teams to deliver accurate analysis and actionable insights.

Reporting to the Commercial Finance Manager, the role emphasizes enhanced MI, automation and data-driven decision making across a diverse portfolio, with hybrid working arrangements and broad