Senior Data Analyst

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

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.

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

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

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.