Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse data and create performance dashboards for residential real estate assets.
- Company: Dynamic residential real estate business with a focus on community development.
- Benefits: Competitive salary, bonus potential, 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 rapidly expanding company.
The predicted salary is between 50000 - 67000 £ per year.
Overview
Excel Data Analyst – Residential Real Estate
Base pay range
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.
#J-18808-Ljbffr
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 and data analysis sectors on LinkedIn. Join relevant groups, attend webinars, and don’t be shy about asking for informational interviews. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Excel dashboards and data analysis projects. This is your chance to demonstrate your expertise in handling complex data and visualisation tools. Make sure to highlight any experience with property management systems like Yardi.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge. Be ready to discuss your experience with KPIs, financial modelling, and how you’ve tackled analytical challenges in the past. Practice explaining complex concepts in simple terms for non-technical stakeholders.
✨Tip Number 4
Apply through our website! We make it easy for you to find roles that match your skills and interests. Plus, it shows you’re serious about joining our team. Don’t forget to follow up after applying; a little persistence can go a long way!
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 projects in real estate. 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 makes you a perfect fit. We love seeing enthusiasm and a personal touch, so let your personality come through.
Showcase Your Technical Skills: Since this role requires advanced Excel skills, don’t hold back! Mention specific tools like Power Query and VBA that you've used. We’re keen to see how you’ve tackled complex data challenges in your previous roles.
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’re considered for the role. Plus, it’s super easy – just follow the prompts and submit your details!
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 pivot tables, Power Query, and VBA. Prepare to demonstrate your proficiency with real-life examples or even a mini-project that showcases your ability to manipulate data effectively.
✨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 from day one.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving skills in real-world scenarios. Think about past experiences where you had to analyse complex data or manage stakeholder expectations, and be ready to share how you approached those challenges.
✨Showcase Your Communication Skills
As you'll be working with non-technical stakeholders, practice explaining complex data insights in simple terms. During the interview, focus on how you can convey information clearly and effectively, demonstrating your ability to bridge the gap between technical and non-technical teams.