Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse data and create performance dashboards for real estate assets using Excel.
- Company: Dynamic residential real estate business with a growing portfolio.
- Benefits: Competitive salary, bonus, hybrid working, and generous leave.
- Why this job: Join a collaborative team and tackle diverse analytical challenges in real estate.
- Qualifications: 4-7 years of data analysis experience, advanced Excel skills, and real estate knowledge.
- Other info: Opportunity for professional growth in a supportive environment.
The predicted salary is between 50000 - 67000 £ per year.
Excel Data Analyst – Residential Real Estate
Are you the right candidate for this opportunity Make sure to read the full description below.
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.
Excel Data Analyst - Residential Real Estate employer: deverellsmith
Contact Detail:
deverellsmith Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Excel Data Analyst - Residential Real Estate
✨Tip Number 1
Network like a pro! Reach out to people in the real estate sector on LinkedIn or at industry events. A friendly chat can sometimes lead to job opportunities that aren't even advertised.
✨Tip Number 2
Show off your Excel skills! Create a portfolio showcasing your data analysis projects, especially those relevant to real estate. This will give potential employers a taste of what you can do.
✨Tip Number 3
Prepare for interviews by brushing up on common data analysis questions and real estate metrics. We recommend practising with a friend or using mock interview platforms to build your confidence.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who take the initiative to connect directly with us.
We think you need these skills to ace Excel Data Analyst - Residential Real Estate
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the role of Excel Data Analyst. Highlight your experience with Excel, data manipulation, and any relevant real estate knowledge. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to tell us why you're passionate about data analysis in the residential real estate sector. Share specific examples of your past work that align with the responsibilities listed in the job description.
Show Off Your Technical Skills: Don’t hold back on showcasing your technical prowess! Mention your experience with Power Query, VBA, and any property management systems like Yardi. We love seeing candidates who can hit the ground running with these tools.
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It helps us keep everything organised and ensures your application gets the attention it deserves. Plus, it’s super easy!
How to prepare for a job interview at deverellsmith
✨Know Your Excel Inside Out
Since the role heavily relies on advanced Excel skills, make sure you brush up on your knowledge of pivot tables, Power Query, and VBA. Practise building complex models and dashboards, as you might be asked to demonstrate your proficiency during the interview.
✨Understand Real Estate Metrics
Familiarise yourself with key real estate financial metrics like NOI, WAULT, and yield performance. Being able to discuss these concepts confidently will show that you understand the industry and can contribute meaningfully to the team.
✨Prepare for Scenario-Based Questions
Expect questions that assess your analytical thinking and problem-solving skills. Prepare examples from your past experience where you've successfully managed data or solved complex issues, especially in a real estate context.
✨Showcase Your Communication Skills
As you'll need to distil complex information for non-technical stakeholders, practice explaining technical concepts in simple terms. This will demonstrate your ability to communicate effectively and manage stakeholder expectations.
