Financial Analyst, Real Estate Finance

Description

• Preparation of monthly PowerBI loan compliance dashboards for senior management and various internal stakeholders for the global debt portfolio
• Assist in managing Oxford’s letter of credit (‘LC’) book including coordination of LC issuance and monitoring LC maturities
• Responding to ad-hoc requests from Accounting, Asset Management, Investments, Legal and other internal teams
• Support external audit year-end debt confirmation process and supplying the external auditors with all new loan agreements
• Responding to and resolving ad-hoc lender enquiries regarding reporting deliverable
• Manage debt servicing payment setup for new loans, working with the Oxford Accounting and Treasury teams and coordinating with third-party lenders
• Maintenance of a complete inventory of guarantees including monthly reporting summarizing Oxford’s guarantees by type, amount and by guarantor entity
• Provide weekly loan compliance updates to the Real Estate Finance team
• Coordinate requests to lenders to obtain their consent for items that require lender approval, including analysis of loan agreements for consent requirements, working with asset management teams to arrange lender requests, and maintenance of an up-to-date consent summary and tracker
• Model pro-forma debt covenants and forward-looking credit metrics (LTV / DSCR / Debt Yield, etc.) across the global debt portfolio to proactively monitor the portfolio against covenant requirements
• Review newly executed loans agreements to summarize key debt terms and metrics, track ongoing lender reporting requirements, and ensure newly onboarded loans and guarantees are correctly reflected in Oxford’s compliance reporting
• Ensuring all loan documents are filed in an organized and systematic manner with records management
• Ongoing development and implementation of new PowerBI dashboards for monthly distribution to key internal stakeholders
• Calculate debt covenants for inclusion in Oxford’s lender reporting packages; Partner with the Asset Management teams for asset level inputs for proforma covenant calculations
• Key contributor and point of contact in managing Oxford’s global loan compliance for it’s $21B debt portfolio (200+ loan and hedging instruments)
• Coordinate the assembly, review, and delivery of lender reporting packages for Oxford’s North American debt portfolio ensuring accurate and on-time delivery to lenders
• Liaise with the European and Asia Pacific Finance teams to standardize global loan compliance processes
• Contribution to long-term projects including exploring use of AI/Microsoft Copilot, process simplification, standardization of covenant models, as well as assisting in the design and implementation of a new debt reporting and lender reporting workflow tool (Yardi)
• Preparation of quarterly compliance meeting materials for senior management to communicate current and pro-forma covenant positions, required lender consents and other loan compliance related matters
• Establishing relationships and regular reporting cadence with key business partners including the Asset Management team to gain in-depth knowledge of the portfolio in order to identify potential implications for debt financing and loan compliance
• Build out loan specific compliance certificates as well as sub-certificate questionnaires to support Oxford’s ongoing lender reporting requirements
• Supporting Financing Leads by determining prepayment rights, calculating expected prepayment penalties, calculating portfolio-level proforma key debt metrics (weighted average term and rate) for refinancing approvals, and ad hoc analysis

Requirements

• Undergraduate degree in Business, Accounting or Economics
• CPA or CFA designation, or working towards either designation (Oxford has a CPA Ontario pre-approved program) considered an asset
• 1-3 years of work experience in a Finance, Accounting, or Banking role with strong debt acumen
• Have sound logic and reasoning skills, with the ability to analyze an issue and evaluate and present various options for solution
• Exposure to and implementation of dynamic visualization and reporting tools such as PowerBI, Tableau and Yardi considered an asset
• Highly proficient with Microsoft Excel and PowerPoint (financial modelling skills, advanced functions, confidence in building Powerpoint decks)
• Strong documentation and organization skills and a high level of attention to detail
• Clear, personable, and effective communication skills (both written and verbal); can articulate a basic understanding of accounting and debt related concepts
• Exposure to reviewing and synthesizing contracts; experience interpreting loan agreements is considered an asset

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance