Analyst, Real Estate Finance & Capital Markets

Description

• Preparation of monthly PowerBI dashboards for senior management and various internal stakeholders for the global debt portfolio
• Contribution to long-term projects including process automation and building out playbooks and stakeholder reference materials
• Working collaboratively with the Treasury team in maintaining a live liquidity forecast which captures the impact of expected financing activity on Oxford’s overall cash needs
• Preparation of key debt reports to internal stakeholders within Oxford and OMERS including the debt reconciliation to the accounting records and the debt continuity schedule
• Responding to ad-hoc requests from Accounting, Asset Management, Investments, Strategy, and other internal teams
• Building strong relationships and working collaboratively with the Accounting teams and acting as a key point of contact within the organization relating to inquiries on the global debt portfolio
• Process improvements and technology enhancements to develop reporting systems and tools
• Completion of month-end reporting procedures in accordance with Oxford’s risk and internal control framework, including maintenance of the debt reporting data repository
• Maintaining an inventory of statistics on Oxford’s global financings such as gross financing activity, fees paid to brokers and lenders, and other lender relationship data
• Supporting the Investments and Asset Management teams on dispositions by determining prepayment rights and calculating expected prepayment penalties upon sale
• Reviewing relevant sections of executed debt agreements and completing onboarding procedures, including entering key details into Oxford’s debt reporting software and ensuring newly onboarded loans are correctly reflected in Oxford’s consolidated reporting

Requirements

• Strong documentation and organization skills and a high level of attention to detail
• Clear, personable, and effective communication skills (both written and verbal)
• Actively working towards a CPA or CFA designation an asset
• Exposure to Business Intelligence tools such as PowerBI, Tableau or other BI tools a strong asset
• Self-starting personality that can work in a fast-paced, growing organization with tight deadlines
• Can articulate a basic understanding of Accounting, finance, and debt related concepts
• Exposure to reviewing and synthesizing contracts
• Undergraduate degree in Business, Accounting or Economics
• Strong analytical and modelling skills, including intermediate to advanced knowledge of excel
• Highly proficient with Microsoft Excel and PowerPoint (basic financial modelling skills, can organize and extract key information from large data sets, confidence in building PPT decks)

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance