Job brief
We are seeking a detail-oriented Real Estate Analyst to join our investment team and drive the financial success of our growing portfolio. You will take ownership of underwriting new acquisition opportunities, managing property-level budgets, and analyzing operational KPIs to uncover hidden value. This is a unique opportunity to work alongside industry veterans, influence high-stakes capital allocation, and sharpen your technical expertise in commercial real estate. If you are passionate about market dynamics and sophisticated financial modeling, we want to hear from you.
Key highlights
- Construct and maintain complex dynamic financial models in Excel to evaluate potential property acquisitions and divestment strategies.
- Perform comprehensive market research using CoStar, Reonomy, or Yardi to validate rental comps, absorption rates, and supply pipelines.
- Prepare high-stakes investment committee memos detailing risk-adjusted returns, sensitivity analysis, and value-add opportunities for senior leadership.
- Analyze monthly property operating statements and general ledgers to identify budget variances and implement corrective operational strategies.
What is a Real Estate Analyst?
A Real Estate Analyst is a financial professional who evaluates the viability of commercial and residential property investments. By synthesizing market data, demographic trends, and cash flow projections, a Real Estate Analyst helps stakeholders make data-driven acquisition and divestment decisions. This role sits at the intersection of finance and property operations, requiring a deep understanding of DCF modeling, capitalization rates, and risk mitigation strategies to maximize long-term asset value.
What does a Real Estate Analyst do?
On a typical day, a Real Estate Analyst builds complex financial models in Excel to forecast net operating income, occupancy rates, and internal rates of return for prospective properties. They conduct deep-dive market research using platforms like CoStar or Yardi to benchmark assets against regional competitors. Furthermore, they collaborate with asset managers and investment committees to present actionable insights through investment memos, budget variance reports, and quarterly performance reviews.
Key responsibilities
- Construct and maintain complex dynamic financial models in Excel to evaluate potential property acquisitions and divestment strategies.
- Perform comprehensive market research using CoStar, Reonomy, or Yardi to validate rental comps, absorption rates, and supply pipelines.
- Prepare high-stakes investment committee memos detailing risk-adjusted returns, sensitivity analysis, and value-add opportunities for senior leadership.
- Analyze monthly property operating statements and general ledgers to identify budget variances and implement corrective operational strategies.
- Support the due diligence process by coordinating with legal teams, environmental consultants, and tax professionals during transaction lifecycles.
- Monitor portfolio-level performance metrics, including NOI growth, debt service coverage ratios, and cash-on-cash returns across diverse asset classes.
- Develop detailed multi-year cash flow projections for asset management planning and capital improvement budget authorization requests.
- Collaborate with leasing teams to assess the financial impact of proposed tenant improvement allowances and lease structure modifications.
Requirements and skills
- Bachelor’s degree in Finance, Real Estate, Economics, or a related quantitative field with a strong GPA.
- Advanced proficiency in Microsoft Excel, including experience building complex macros, dynamic pivot tables, and multi-layered DCF models.
- Demonstrated hands-on experience utilizing ARGUS Enterprise for valuation, lease analysis, and property cash flow forecasting.
- Familiarity with commercial real estate platforms such as CoStar, Yardi, RealPage, or MRI for data extraction and portfolio reporting.
- Solid understanding of core real estate financial concepts, including IRR, NPV, cap rates, and equity waterfall distribution structures.
- Professional certification such as an ARGUS Software Certification or progress toward a CCIM designation is highly preferred.
- Proven ability to translate technical financial findings into persuasive visual presentations for non-technical stakeholders and partners.
- Strong organizational skills with the ability to manage multiple transaction timelines simultaneously in a high-pressure, deal-driven environment.
FAQs
What does a Real Estate Analyst do on a daily basis?
A Real Estate Analyst spends their day deep in financial analysis, primarily using Excel and ARGUS to model property cash flows and valuation scenarios. They reconcile actual property performance against budgets, conduct market research to track rent trends, and draft investment memorandums for acquisitions. Much of the day is also spent coordinating the due diligence process and communicating findings to asset managers.
What technical skills are required for a Real Estate Analyst?
The most critical technical skills include advanced Excel proficiency (modeling/macros), mastery of ARGUS Enterprise for lease and valuation analysis, and the ability to interpret financial statements like profit and loss reports. Familiarity with industry-standard databases like CoStar, Yardi, or RealPage is also essential. Additionally, analysts must be proficient in calculating financial metrics like IRR, ROI, and debt coverage ratios.
How does a Real Estate Analyst support the investment team?
A Real Estate Analyst serves as the primary data and analytics engine for the investment team. By providing rigorous underwriting for potential deals, they help stakeholders assess whether an asset meets the fund’s risk and return thresholds. Their ongoing monitoring of property budgets and market benchmarks ensures that the investment team can make timely, evidence-based decisions to maximize asset value.
What is the typical career path for a Real Estate Analyst?
The Real Estate Analyst role is often the foundational step toward becoming a Real Estate Associate, Asset Manager, or Acquisition Manager. With experience, analysts often move into senior roles where they oversee larger deal portfolios, handle complex capital stack structures, or lead investment strategy for specific asset classes. Many analysts also pursue advanced certifications like the CCIM or CFA to accelerate their advancement.