Business Analyst - Real Estate Valuations & Modeling

Vichara Technologies; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading real estate consultancy in Toronto seeks a financial analyst to build complex financial models and create reporting tools. Ideal candidates have over 5 years in real estate investment and excel in data visualization with Power BI. Strong analytical and communication skills are essential for collaborating with various teams. This role offers opportunities for professional growth in a dynamic environment.

Qualifications

• 5+ years of experience in real estate investment, finance, or asset management.
• Advanced proficiency in Microsoft Excel including formulas and models.
• Strong experience with Power BI for data visualization.

Responsibilities

• Build and audit complex real estate financial models.
• Create dashboards and reporting tools for portfolio performance.
• Collaborate with teams on feasibility studies and presentations.

Skills

Real estate financial modeling

Data visualization

Analytical skills

Communication skills

Education

Post-secondary degree in Finance, Real Estate, Accounting, or Economics

Tools

Microsoft Excel

Power BI

Yardi

Job description

• Build, maintain, and audit complex real estate financial models (DCF, IRR, sensitivity analyses, waterfall structures) in Excel to evaluate new acquisitions, developments, and asset repositioning.
• Create and manage dashboards and reporting tools using Power BI for portfolio performance, investment tracking, and decision support.
• Conduct property and portfolio valuations, market research, and benchmarking analysis to support strategic recommendations.
• Collaborate with asset management, acquisitions, finance, and development teams on financial feasibility studies and investment presentations.
• Analyze operating and financial data from Yardi and other internal systems to identify trends, risks, and opportunities.
• Assist with investor reporting, pitch decks, and due diligence for capital raises or dispositions.
• 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 (income approach, comparables, cost).
• Post-secondary degree in Finance, Real Estate, Accounting, Economics, or a related field.
• Professional designation or progress toward CFA or FRM strongly preferred.
• Exceptional attention to detail, communication skills, and ability to work in a fast-paced environment.