Business Analyst - Real Estate Valuations & Modeling

You will be responsible for building, maintaining, and auditing complex real estate financial models in Excel to evaluate new acquisitions, developments, and asset repositioning. This includes using DCF, IRR, sensitivity analyses, and waterfall structures. Additionally, you will create and manage dashboards and reporting tools using Power BI for portfolio performance, investment tracking, and decision support. You will also conduct property and portfolio valuations, market research, and benchmarking analysis to support strategic recommendations. Collaboration with asset management, acquisitions, finance, and development teams on financial feasibility studies and investment presentations will be essential. Furthermore, you will analyze operating and financial data from Yardi and other internal systems to identify trends, risks, and opportunities. You will also assist with investor reporting, pitch decks, and due diligence for capital raises or dispositions. It is important to stay current with Toronto/GTA real estate trends, economic factors, and industry best practices. Qualifications: - Minimum 5 years of experience in real estate investment, finance, private equity, or asset management, with a focus on modeling and analysis. - Advanced proficiency in Microsoft Excel including nested formulas, macros, and dynamic financial modeling. - Strong experience with Power BI for data visualization and business intelligence. - Familiarity with Yardi or similar property management/accounting platforms. - Solid understanding of real estate valuation methodologies such as the income approach, comparables, and cost. - Post-secondary degree in Finance, Real Estate, Accounting, Economics, or a related field. - Professional designation or progress toward CFA or FRM is strongly preferred. - Exceptional attention to detail, communication skills, and ability to work in a fast-paced environment.,