Financial Analyst

Community Land Trust, CHF BC, COHO; Vancouver; On-site; CAD 70,000 - 85,000; Full time

Job summary

Community Land Trust à Vancouver cherche un Financial Analyst pour soutenir ses plans de croissance. Le candidat idéal travaillera sur des analyses de marché et des prévisions financières tout en collaborant avec divers départements pour améliorer le reporting interne et externe. Ce rôle clé exige une expérience en finances, modélisation et capacité à travailler sous pression, tout en favorisant la diversité et l'inclusion au sein de l'équipe.

Benefits

Comprehensive benefits package

Qualifications

• Minimum de 3 ans d'expérience professionnelle dans le domaine financier ou immobilier.
• Expérience en modélisation financière et analyses de données.
• Capacité à gérer plusieurs projets dans un environnement dynamique.

Responsibilities

• Préparer des prévisions de flux de trésorerie et des rapports statistiques.
• Créer et analyser des proformas et des scénarios.
• Assister à l'administration des prêts et des partenariats en capital.

Skills

Data Analysis

Financial modeling

Communication

Problem-solving

Quantitative skills

Excel

Education

Bachelor's degree in finance

CFA, CMA, CPA, MBA (preferred)

Tools

SAGE

Arcori

Job description

Organizational Overview

Based in Vancouver, Community Land Trust (CLT) is a social purpose real estate developer focused on creating communities' people are proud to call home. Established in 2015, CLT is a member of the CHF BC group of social enterprises. CLT stewards its real estate, asset management, development, and finance portfolios with access to shared corporate services of the CHF BC group.

CLT currently has more than 30 co-ops in their portfolio, with more than 2,600 occupied homes and another 750 homes in development or under construction in Victoria, Abbotsford, Maple Ridge, Vancouver, Surrey, New Westminster, Burnaby, Coquitlam, Kelowna and North Cowichan.

Over the past 10 years, CLT has grown significantly, building their own real estate, development, asset management, and finance divisions. Today, CLT has a real asset portfolio of approximately $1.25 billion, with $35 million in operating budgets and a team of 48 staff.

Our team of skilled industry professionals is focused on creating and advocating for inclusive communities that residents are proud to call home.

Purpose of the Position

Reporting to the Director of Finance, the Financial Analyst, is responsible for assisting and supporting the CLT in achieving their growth and overall strategic plan. This includes working on various aspects of our Real Estate portfolios, such as completing property valuations and market analysis and assisting in the preparation of underwriting for new construction projects, new acquisitions, and renewals of commercial mortgages. The ideal candidate will work collaboratively with all departments including Finance, Development and Real Estate and Asset Management to build out our internal and external reporting suite, including financial reviews of current commercial tenants.

In addition, they will also play a supporting role in loan administration by conducting annual reviews of existing mortgages and preparing various internal reports.

Key Responsibilities

• Work with the Management team to create various new reports in order to enhance reporting suite available to internal and external stakeholders
• Prepare cash flow forecasts and statistical reports
• Prepare special reports for management and department heads by collecting, analyzing, and summarizing information and trends
• Create, review and analyze proformas, scenario analysis, capital budgets, cash flows and partnership models (new construction, development, existing income producing properties)
• Prepare development financing packages. Collect, validate and analyze all necessary financial information and perform due diligence to meet CLT's risk and return requirements, including analysis of financial statements and review of third-party reports (appraisal, building condition, environmental)
• Model debt and equity structures to determine optimal project profitability and risk mitigation
• Assist with implementing and streamlining current processes in order to improve day-to-day business activities across the company
• Analyze the market and collaborate in maintaining a database to monitor the real estate market and determine and validate the assumptions used in the financial analysis.
• Extensive use of advanced Excel formulas to automate recurring analysis/working papers
• Undertake and lead various ad hoc analysis as required on a regular basis
• Participate in various Finance Department initiatives and special projects
• Assist with placement and administration of development loans and equity partnership
• Provide support to all Department heads as required

Education and Experience

• Bachelor's degree in finance, business administration, Accounting or real estate; Other certifications or Master's Degree, or enrollment in an applicable program preferred (ie. CFA, CMA, CPA, MBA)
• A minimum of 3+ years of professional experience in finance and real estate or related area
• Experience in the areas of real estate development, construction or project financing would be beneficial
• Financial modeling experience and strong modeling skills
• Data Analysis and Business Analysis experience

Skills and Abilities

• Highly organized with the ability to simultaneously manage multiple projects and fulfill responsibilities in a fast-paced environment
• Ability to work both independently and as part of a team
• Excellent communication skills and collaborates effectively with others
• Self-motivated and enjoys problem-solving in an unstructured environment
• Solid quantitative skills combined with critical thinking capability
• Strong work ethic with a proven ability to meet deadlines and work under pressure
• Advanced Excel skills and proficient working with large data sets using exceptional analytic skills
• Knowledge of accounting software SAGE & Arcori would be an asset
• ERP systems implementation considered an asset

Compensation: $70,000 - $85,000/year. Salary commensurate with experience. Additionally, we offer a comprehensive benefits package.

Equity, Diversity and Inclusion

CLT Development Services Society is an equal opportunity employer. We hire based on merit and are strongly committed to equity, diversity and accessibility. Upon request accommodation will be provided throughout the recruitment, selection and/or assessment process to applicants with disabilities. We value diversity and encourage applications from individuals of all backgrounds and experiences.