Financial Analyst, Real Estate Finance

Description

• 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)
• 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
• Maintenance of a complete inventory of guarantees including monthly reporting summarizing Oxford’s guarantees by type, amount and by guarantor entity
• 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
• 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
• Manage debt servicing payment setup for new loans, working with the Oxford Accounting and Treasury teams and coordinating with third-party lenders
• Build out loan specific compliance certificates as well as sub-certificate questionnaires to support Oxford’s ongoing lender reporting requirements
• 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
• 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
• Provide weekly loan compliance updates to the Real Estate Finance team
• Liaise with the European and Asia Pacific Finance teams to standardize global loan compliance processes
• Key contributor and point of contact in managing Oxford’s global loan compliance for it’s $21B debt portfolio (200+ loan and hedging instruments)
• 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
• 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
• Responding to and resolving ad-hoc lender enquiries regarding reporting deliverable
• Ensuring all loan documents are filed in an organized and systematic manner with records management
• Support external audit year-end debt confirmation process and supplying the external auditors with all new loan agreements
• Preparation of monthly PowerBI loan compliance dashboards for senior management and various internal stakeholders for the global debt portfolio
• Ongoing development and implementation of new PowerBI dashboards for monthly distribution to key internal stakeholders
• 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
• 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

• Strong documentation and organization skills and a high level of attention to detail
• Have sound logic and reasoning skills, with the ability to analyze an issue and evaluate and present various options for solution
• 1-3 years of work experience in a Finance, Accounting, or Banking role with strong debt acumen
• Undergraduate degree in Business, Accounting or Economics
• Exposure to and implementation of dynamic visualization and reporting tools such as PowerBI, Tableau and Yardi considered an asset
• 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
• CPA or CFA designation, or working towards either designation (Oxford has a CPA Ontario pre-approved program) considered an asset
• Highly proficient with Microsoft Excel and PowerPoint (financial modelling skills, advanced functions, confidence in building Powerpoint decks)

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance