Real Estate Financial Analyst

Job summary

Build, maintain, and audit financial models for housing and real estate projects, including underwriting, cash flow, valuation, and financing analyses. Prepare sensitivity analyses, investment memos, dashboards, and presentations, while coordinating with project partners and maintaining accurate model documentation.

Job details

At Ombrello Solutions, we build proprietary investment products that result in Healthier Cities. Working hand-in-hand with DanSa Capital Innovation, our work focuses on homelessness, affordable housing, urban nature & biodiversity, civic infrastructure, and food security amongst others. We are currently building three investment products: a $250M Civic Infrastructure Bond, $100M Homelessness Bond, and $100M Community Real Estate Investment Trust. Description of the three products 1. DanSa Capital: development, commercialization and management of proprietary systemic investment products a. $250mil Civic Infrastructure Bond, which finances acquisition of ~215 acres of mature private urban nature sites across Ontario and Quebec, restores and develops them into urban parks (Parks +) that integrate biodiversity, nature based solutions and community services. b. $100mil Homelessness Bond, which finances acquisition of 400 existing vacant housing units in Montreal to convert them into permanent housing for individuals and families who find themselves in a situation of homelessness due to evictions. c. $250mil Community Real Estate Investment Trust (REIT), a national vehicle that enables preservation and improvement of not-for-profit real estate across all asset classes. 2. DanSa Capital Innovation: structuring of market building catalytic investment products Service provider to external organizations focused on bringing to market innovative investment products for key societal and environmental challenges 3. DanSa Asset Developer: pre-development of civic and natural assets Internal dedicated team of urban planners, landscape architects, and real estate specialists. Together they research, prepare concept plans and feasibility studies as well as ownership and governance structures for identified pipeline of projects to be financed from the proceeds of the structured investment products. We are seeking a Financial Analyst, Real Estate to build the financial models and analysis behind our real estate-linked investment products. The role will be shared across three mandates. About the Role This role is ideal for an analyst, a CFA or CPA candidate, a real estate finance professional, or an early-career professional interested in: Real estate finance and housing Social finance and impact investing Financial modeling and underwriting Public policy and affordable housing The successful candidate will spend 6 months building the financial models that test whether housing and real estate projects are viable, affordable and financeable, and presenting the results to our leadership team and partners. Specifically, the individual would be in charge of the following key activities: Build and maintain underwriting and cash flow models for housing and real estate projects across Canada, from early feasibility through financing; Analyze project financials, including rent rolls, operating budgets, capital costs and available funding (such as CMHC programs), and assess each project against our investment criteria; Prepare sensitivity analyses, investment memos and briefing notes for our leadership team, investors and partners. Responsibilities Build, maintain and audit financial models (pro formas, discounted cash flow, IRR, cash-on-cash return and debt service coverage) for real estate and housing projects Underwrite projects by reviewing rent rolls, operating and capital budgets, leases, appraisals and third-party reports Run sensitivity, scenario and stress tests to show how changes in rents, costs, interest rates and funding affect each project Research and analyze market, demographic and policy data to support model assumptions across segments that include: Affordable and permanent housing Multi-residential and commercial real estate Land and development sites Assess financing structures that combine debt, equity and grant funding, and the criteria set by lenders and public funders Prepare investment memos, dashboards and presentations that explain results clearly to non-financial audiences Coordinate with developers, non-profit housing providers, lenders and DanSa Capital Innovation, and keep model documentation, version control and data accurate Qualifications Bachelor’s degree in finance, economics, commerce, real estate or a related field (or equivalent experience) 2+ years of experience in financial analysis, underwriting or real estate finance (internships and co-op terms count) Advanced Excel and financial modeling skills, including DCF, IRR and sensitivity analysis Solid understanding of corporate finance, valuation (direct capitalization and DCF) and real estate fundamentals Experience or educational background in the following fields: Real estate; Finance; Accounting; Economics. Strong analytical and problem-solving skills with high attention to detail Excellent writing, communication and presentation skills, including explaining numbers to non-financial audiences Fully bilingual (English and French) Ability to work independently and meet deadlines in a remote, small-team environment CFA (any level), CPA or MBA is considered an asset Experience with CMHC or other public housing funding programs, ARGUS, Yardi or Power BI is a plus Familiarity with social finance or impact investing is an asset Compensation & Engagement CAD $50/hour (tax in) Approximately 20 hours per week 6-month initial term, with potential to extend subject to funding Contract role Fully remote; candidates must be located in Canada To Apply Please apply through LinkedIn with: Your résumé A short paragraph outlining your interest in the role Optional: a sample of a financial model or analysis you have built (remove any confidential data) Equal Opportunity Ombrello Solutions is an equal opportunity employer. We welcome applications from people of all backgrounds, including women, Indigenous peoples, racialized people, persons with disabilities, and LGBTQ+ people. Only candidates selected for an interview will be contacted.

What you’ll do

Build, maintain, and audit financial models for housing and real estate projects, including underwriting, cash flow, valuation, and financing analyses. Prepare sensitivity analyses, investment memos, dashboards, and presentations, while coordinating with project partners and maintaining accurate model documentation.

Requirements

Applicants need a bachelor’s degree in a relevant field or equivalent experience, at least two years of financial analysis, underwriting, or real estate finance experience, and advanced Excel and financial modeling skills. Strong analytical, communication, and presentation abilities are required, as is fluency in English and French; CFA, CPA, or MBA credentials and experience with public housing funding programs or relevant software are assets.

Listed skills

• Microsoft Excel · Preferred
• Bilingual communication · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Financial Modeling
• Real Estate Underwriting
• Cash Flow Analysis
• Discounted Cash Flow Analysis
• IRR Analysis
• Sensitivity Analysis
• Scenario Analysis
• Stress Testing
• Real Estate Valuation
• Investment Analysis
• Excel
• Market Research
• Financial Writing
• Presentation Skills
• Data Accuracy
• Bilingual Communication

Job areas

• Finance & Accounting
• Data & Analytics
• Social Services
• Environmental & Sustainability