Job Description

Excel Data Analyst - Residential Real Estate
Salary: 50,000 - 67,000 + Discretionary Bonus
Location: Central London | Hybrid Working
Please note we will not be able to progress applicants who require Visa Sponsorship for this client.
The Opportunity
Our client is a residential real estate business, 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, 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)

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.

Skills Required