Real Estate Financial Analyst

Ombrello Solutions; Quebec; Remote; CAD 69,000 - 76,000; Full time

Benefits offered by this job

Fully remote

Job summary

Ombrello Solutions is seeking a Financial Analyst, Real Estate to build financial models for housing and real estate investments across Canada. The role is a six-month contract and fully remote within Canada.

The ideal candidate is a CFA/CPA candidate or real estate finance professional with 2+ years of experience, advanced Excel skills, and bilingual English/French. You will underwrite projects, run sensitivity tests and prepare investment memos.

Qualifications

• Bachelor’s degree in finance, economics, real estate or related field.
• 2+ years in financial analysis, underwriting or real estate finance.
• Advanced Excel and financial modeling (DCF, IRR, sensitivity).
• Strong knowledge of corporate finance and real estate fundamentals.
• Fully bilingual (English and French).

Responsibilities

• Build, maintain and audit financial models for housing and real estate projects.
• Underwrite projects using rent rolls, budgets, leases and third‑party reports.
• Run sensitivity, scenario and stress tests and present results to leadership.
• Coordinate with developers, non‑profit housing providers, lenders and partners.

Skills

Real estate finance

Financial modeling

Underwriting

Bilingual English/French

Education

Bachelor's degree in finance/economics/real estate

Tools

Excel

CMHC programs

ARGUS

Yardi

Power BI

Job description

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

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.

Chez Ombrello Solutions, nous élaborons des solutions financières novatrices pour des villes en meilleure santé et plus résilientes. En collaboration avec DanSa Capital Innovation, nous travaillons notamment sur l’itinérance, le logement abordable, l’infrastructure civique et la sécurité alimentaire. Nous créons actuellement deux produits d’investissement : une obligation de 250 M$ pour l’infrastructure civique et une obligation de 100 M$ pour l’itinérance, qui finance des logements permanents partout au Canada pour des personnes et des familles hébergées en refuge après une éviction.

Nous recherchons une personne au poste d’analyste financier, immobilier pour élaborer les modèles financiers de nos produits d’investissement liés à l’immobilier, surtout les logements permanents que finance notre obligation pour l’itinérance.

À propos du poste

Ce poste convient à un analyste, à une personne candidate au CFA ou au CPA, à un professionnel de la finance immobilière ou à un professionnel en début de carrière qui s’intéresse à la finance immobilière et au logement, à la finance sociale et à l’investissement à impact, à la modélisation financière et aux politiques publiques.

La personne retenue consacrera [6 mois] à bâtir les modèles qui évaluent la viabilité, l’abordabilité et la finançabilité de projets de logement et immobiliers, puis à en présenter les résultats à la direction et aux partenaires.

Responsabilités

• Élaborer, tenir à jour et vérifier des modèles financiers (pro forma, flux de trésorerie actualisés, TRI, rendement en espèces, couverture du service de la dette)
• Souscrire les projets : états des loyers, budgets, baux, évaluations et rapports de tiers
• Réaliser des tests de sensibilité, de scénarios et de résistance
• Analyser des données de marché, démographiques et de politiques pour appuyer les hypothèses (logement abordable, immobilier multirésidentiel et commercial, terrains)
• Évaluer des structures de financement (dette, capitaux propres, subventions) et les critères des prêteurs et des bailleurs de fonds publics
• Préparer des notes, des tableaux de bord et des présentations clairs pour des publics non financiers
• Collaborer avec des promoteurs, des organismes de logement sans but lucratif, des prêteurs et DanSa Capital Innovation, et tenir les modèles à jour

Qualifications

• Baccalauréat en finance, en économie, en commerce, en immobilier ou dans un domaine connexe (ou expérience équivalente)
• [2 ans ou plus] d’expérience en analyse financière, en souscription ou en finance immobilière (stages inclus)
• Excellente maîtrise d’Excel et de la modélisation financière (FTA, TRI, analyse de sensibilité)
• Bonne compréhension de la finance d’entreprise, de l’évaluation et de l’immobilier
• Expérience ou formation en immobilier, en finance, en comptabilité ou en économie
• Solides compétences analytiques et grand souci du détail
• Excellentes habiletés de rédaction et de communication
• Parfaitement bilingue (français et anglais)
• Autonomie et respect des échéances dans un environnement à distance, au sein d’une petite équipe
• Atouts : CFA, CPA ou MBA ; programmes publics de financement du logement (SCHL), ARGUS, Yardi ou Power BI ; finance sociale ou investissement à impact

Rémunération et engagement

• [40] $ CA l'heure (taxes incluses)
• Environ [20] heures par semaine
• Durée initiale de [6 mois], avec possibilité de prolongation selon le financement
• Poste contractuel
• Entièrement à distance ; personnes situées au Canada

Pour postuler

• Votre curriculum vitæ
• Un court paragraphe sur votre intérêt pour le poste

Égalité des chances

Ombrello Solutions souscrit à l’égalité des chances et accueille toutes les candidatures, y compris celles des femmes, des Autochtones, des personnes racisées, des personnes en situation de handicap et des personnes LGBTQ+. Seules les personnes retenues pour une entrevue seront contactées.