Junior Real Estate Acquisition Analyst in Cambridge

Company Overview

Yellow Tree is a Real Estate Investment Fund based in Gibraltar and is dedicated to the ownership, development and management of commercial and residential real estate assets. The Yellow Tree Real Estate Investment Fund is backed by a Gibraltar-based multi-family office. Yellow Tree invests across capital and gateway cities, employing a tailored investment strategy to each geographic region. Our portfolio underscores long-term value and mirrors our dedication to excellence. Our philosophy centers on income generation, ensuring that 100% of our portfolio consistently delivers returns. We achieve this by taking an asset-by-asset approach, where each asset carries its own weight in contributing income without dilution. Each asset has its own business plan that is meticulously followed making sure that each asset performs as expected. We own and manage sustainable and high-quality properties, aligning with the objectives of leading national and international corporations. This ensures that Yellow Tree Group is synonymous with quality, reliability, and enduring success.

Role Overview

We are seeking a motivated and analytical Junior Real Estate Acquisition Analyst to join our growing investment team. This role offers an excellent opportunity to gain exposure to real estate acquisitions, investment analysis, financial modelling, and portfolio management across multiple asset classes and international markets. The successful candidate will support the evaluation of investment opportunities, market research, financial analysis, and due diligence activities while working closely with senior members of the acquisitions and investment teams.

Key Responsibilities

• Research & Investment Analysis
  • Conduct market research and gather data on real estate sectors, including hospitality, residential, student housing, office, retail, commercial assets, and logistics.
  • Support the preparation of investment analyses, business cases, and presentations for internal stakeholders.
  • Assist in building and maintaining financial models to evaluate acquisition opportunities and asset performance.
  • Analyse property-level financial information, operating performance, and market data.
  • Monitor market trends, competitor activity, and economic indicators relevant to investment decisions.
  • Support the team in assessing potential acquisitions and portfolio growth opportunities.
  • Assist in preparing reports and investment summaries for management review.
• Acquisitions & Deal Support
  • Assist with the sourcing and evaluation of acquisition opportunities across the Group’s target markets.
  • Review property information, leases, operational data, and financial documentation.
  • Support the maintenance and improvement of internal acquisition and investment evaluation models.
  • Prepare materials and analysis for investment committee and acquisition meetings.
  • Liaise with brokers, consultants, lenders, and external advisors to gather information required for investment assessments.
  • Support transaction execution activities and maintain acquisition pipelines and databases.
  • Assist with commercial analysis related to acquisitions and strategic initiatives.
• Due Diligence & Portfolio Support
  • Assist in coordinating financial, commercial, operational, and legal due diligence processes.
  • Review budgets, forecasts, and business plans to support investment evaluations.
  • Support the analysis of asset performance and identification of potential risks and opportunities.
  • Assist with preparing reports and presentations for internal stakeholders.
  • Support portfolio monitoring activities and post-acquisition integration processes.
  • Maintain accurate records and documentation related to acquisitions and investment projects.
  • Contribute to the continuous improvement of internal reporting and analytical processes.

Skills & Qualifications

• Bachelor's degree in Finance, Real Estate, Economics, Accounting, Business Administration, or a related field.
• 1–2 years of experience in real estate, investment analysis, corporate finance, valuation, consulting, banking, brokerage, or a related field.
• Strong analytical and numerical skills.
• Good understanding of financial statements and basic financial modelling principles.
• Proficiency in Microsoft Excel and PowerPoint.
• Ability to analyse and interpret financial and market data.
• Strong attention to detail and accuracy.
• Curious and eager to learn about real estate investments.
• Strong organisational and time-management skills.
• Ability to work independently while collaborating effectively within a team.
• Excellent written and verbal communication skills.
• Proactive mindset with a willingness to take ownership of assigned tasks.
• Ability to work in a fast-paced and international environment.
• Exposure to real estate investment, valuation, acquisitions, or asset management.
• Knowledge of financial modelling and investment appraisal techniques.
• Experience using real estate databases and market research tools.
• Right to work in UK.

We offer competitive salary packages, great learning and development opportunities. Opportunity to be part of a dynamic growing team in a fast-growing Real Estate group. Performance Bonus, Team Building, Celebration and parties, Loyalty gifts, Gift Cards Women’s Day & Men’s Day, Extra free days: on your birthday the company gifts you a day off, Birthday cake, Holiday Baskets.

Yellow Tree is a GDPR compliant company, by applying to this job post, you consent with your data being processed in accordance with our Privacy Policy which you can find on https://yellowtree.com/gdprrecruitmentpolicy. Yellow Tree is an Equal Employment Opportunity and affirmative action employer. We do not discriminate based on race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability status, or any other applicable characteristics protected by law.