Senior Data Analyst - Real Estate

Salary: £40,000-45,000 + Discretionary BonusContract: Permanent | Full-TimeLocation: Central London | Hybrid WorkingHours: 9:30am - 6:00pm, Monday to Friday

The Opportunity

Our client is a residential real estate investment firm, with a rapidly expanding portfolio spanning multiple major cities, delivering community focused development and growth.

Their substantial portfolio encompasses serviced apartments, private rental accommodation, and HMO properties. Based in central London, they continue to identify and secure new development opportunities.

Your Role

We are seeking a Senior Data Analyst to join the Investment and Valuation team, reporting directly to the Valuations and Investment Manager. This data-driven role offers unparalleled exposure to diverse analytical challenges within a collaborative specialist team environment.

Core Responsibilities:

Design and manage performance dashboards for assets, portfolios and business units using Excel and visualisation platforms
Prepare monthly performance reports consolidating financial, leasing and operational data across commercial and residential assets
Build and manage complex Excel environments with advanced data manipulation using Power Query, pivot tables, macros and VBA
Track core KPIs including rental income, occupancy, arrears, NOI, WAULT, yield performance and valuation movements
Consolidate data from property management, finance and CRM systems (including Yardi) into reports
Support forecasting and planning through historical analysis and predictive modelling
Coordinate reporting schedules and ensure timely delivery of critical data across teams

Your Profile

Essential Experience:

4-7+ years' proven data/business analyst experience, ideally within real estate, REITs, property management or asset management sectors
Advanced Excel and PowerPoint proficiency including pivot tables, Power Query, VBA/macros and complex financial modelling
Hands-on experience with property management/accounting systems (Yardi advantageous)
Demonstrable experience with visualisation and reporting platforms

Technical Excellence:

Deep understanding of real estate financial metrics, leasing fundamentals and portfolio KPIs
Strong analytical capabilities with proven ability to distil complex information for non-technical stakeholders
Exceptional data management skills maintaining integrity across multiple source systems
Professional communication skills with confidence to manage stakeholder expectations and accountability

The Package

Comprehensive Benefits:

Competitive base salary
Discretionary performance bonus
25 day's annual leave plus UK bank and public holidays
Company pension scheme
Private medical insurance
Enhanced maternity and paternity provisions
Hybrid working model (3 days office, 2 days home)
Dog-friendly office environment (1 day per week)

We champion diversity and equal opportunities across all our partnerships.

For a confidential discussion about this opportunity, please submit your application or contact our specialist property recruitment team.