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.
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.
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 lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Show off your Excel skills! Create a mini-project or dashboard that showcases your data analysis abilities. Share it during interviews to impress potential employers with your hands-on experience.
✨Tip Number 3
Prepare for those tricky interview questions! Brush up on your knowledge of KPIs and financial metrics relevant to real estate. We want you to feel confident and ready to tackle any question thrown your way.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we’re always on the lookout for talented individuals like you to join our team.
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 is tailored to the Excel Data Analyst role. Highlight your experience with advanced Excel functions, data manipulation, and any relevant real estate projects. 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 explain why you're passionate about the role and how your background in data analysis aligns with our client's needs. Keep it concise but impactful – we love a good story!
Showcase Your Technical Skills: Don’t forget to mention your technical prowess! Be specific about your experience with tools like Power Query, VBA, and any property management systems you've used. We’re keen to see how you can bring those skills to our team.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates. Plus, it shows you’re serious about joining us!
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 tackled data challenges or improved reporting processes, 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 manage stakeholder expectations and communicate effectively within the team.
