Mortgage Analytics Intern (Summer 2027)

Alberta Investment Management Corporation; Edmonton; On-site; CAD 32,000 - 36,000; Full time

Job summary

AIMCo's Mortgage team in Edmonton is seeking a student to support its portfolio management efforts. The role focuses on reviewing loans, updating data, and assisting with mortgage investment underwriting while gaining exposure to Canadian, US and UK markets.

The ideal candidate is an undergraduate in a commerce/finance/economics/math-related field, proficient with Excel and Outlook, with exposure to SQL or Power BI considered an asset. This is a 4-month, full-time co-op-like position.

Qualifications

• Undergraduate student enrolled in a relevant field such as Commerce, Business, Finance or Economics.
• Proficient with Microsoft Office applications (Excel, Word, Outlook).
• Experience with databases (MS Access or SQL) is an asset.
• Exposure to automated reporting tools (Power BI) is an asset.

Responsibilities

• Reviewing annual loans by completing rent roll updates.
• Reviewing operating statements and inputting tenant classifications and market research.
• Updating loan information and data management.
• Reporting and assisting the team on mortgage investment underwriting.

Skills

Analytical skills

Communication skills

Time management

Attention to detail

Education

Commerce/Business/Finance/Economics student

Tools

Excel

Outlook

Power BI

SQL

Job description

AIMCo's Mortgage team in Edmonton is seeking a student to support its portfolio management efforts. The role focuses on reviewing loans, updating data, and assisting with mortgage investment underwriting while gaining exposure to Canadian, US and UK markets.

The ideal candidate is an undergraduate in a commerce/finance/economics/math-related field, proficient with Excel and Outlook, with exposure to SQL or Power BI considered an asset. This is a 4-month, full-time co-op-like position.