Real Estate Portfolio Analytics, Student Intern (Winter 2027 - 8 or 12 Months)

Healthcare of Ontario Pension Plan Trust Fund Company; Toronto; Hybrid; CAD 36,000 - 55,000; Part time

Benefits offered by this job

Flexible hybrid work model

Job summary

HOOPP’s Real Estate Portfolio Management group is seeking a Real Estate Portfolio Analytics Co-op Student to join the REDA team in Toronto. You will support analytics, reporting, and data-driven insights using tools like Taliance, Argus, and Tableau in a fast-paced investment management setting.

The role emphasizes data modeling, validation, and collaborative problem solving, with a flexible hybrid work arrangement and opportunities to contribute to capital pacing and forecasting processes.

Qualifications

• Bachelor-level degree in business, real estate, finance, or related field preferred.
• Strong foundation in real estate concepts and financial statements analysis.
• Experience with real estate valuation/underwriting concepts is a plus.
• Proven ability to analyze large data sets and produce BI outputs.
• Excellent communication and stakeholder presentation skills.

Responsibilities

• Support semi-annual Real Estate Forecast by loading and validating valuation models and debt structures.
• Assist monthly investment capacity analysis and capital pacing planning.
• Improve Taliance import model and document data flow and system setup.
• Verify monthly data loads for accuracy and assist in BI reporting.

Skills

Analytical

Excel modeling

Data visualization

SQL

Teamwork

Self-motivated

Education

BSc/BA or MBA

Tools

Excel

Argus Enterprise

Taliance

Tableau

SAP HANA

Snowflake

SQL

Job description

Why you'll love working here:

high-performance, people-focused culture our commitment that equity, diversity and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees’ career growth optional membership in HOOPP's world class defined benefit pension plan, which can serve as an important part of your retirement security virtual fitness, yoga and meditation classes, nutritional consultations and wellness seminars flexible hybrid work model that embraces remote work the opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workers

Application deadline: September 15, 2026 Application requirements: Resume, transcript and cover letter

Job Summary

The Real Estate Portfolio Management group at HOOPP (Healthcare of Ontario Pension Plan) seeks a skilled individual for an 8- or 12-month co-op placement as an Analyst, Real Estate Portfolio Analytics Co-op Student within the Real Estate Data and Analysis (REDA) team. This group provides critical insights, analytics, reporting, and ad-hoc support to the real estate investment management team utilizing various technical resources such as Argus Taliance, our Portfolio Management and Forecasting tool, alongside Business Intelligence reporting tools such as Tableau which are powered by the Data Warehouse. The REDA team is committed to creating genuine value for stakeholders within an active and fast-moving setting. Emphasizing innovation, they encourage questioning established procedures, foster team collaboration, and prioritize effective, pragmatic solutions.

What you will do:

• Real Estate Portfolio Management Analytics Support the production of the semi-annual Real Estate Forecast by loading and validating real estate valuation/underwriting models, modeling debt and investment ownership structures in Taliance Assist in the creation of monthly investment Capacity Analysis and the formulation of capital Pacing Plans, ensuring that all input data is accurate and reviewing the final output for accuracy Improve the existing Taliance import model and collaborate with the team to integrate it into the standard underwriting templates Develop a comprehensive document for the Taliance setup and modeling process that outlines data flow and system configuration Assist with the monthly data loads verifying and validate has been uploaded correctly and accurately Work on refining the modeling in the Taliance system including mechanisms to true-up debt, LP cash calls/distributions and the addition of multiple assumptions
• Business Intelligence Reporting Support the production and maintenance of existing BI reports including the Executive Dashboard, Asset Class Dashboards, Return Attribution report and various other analytical tools Assist the team with ad-hoc analytical support related to the business

What you will bring:

• BSc/BA or Master in Business Administration, Real Estate, Finance, or related field is preferred
• Background in real estate, finance, investment, accounting, computer science, engineering or mathematics is preferred
• Can practically apply Real Estate concepts such as Discounted Cashflow Analysis
• Grasp concepts related to Real Estate Finance, including the analysis of a Balance Sheet, Financial Statements, and the comparison of cost to market value.
• Able to effectively communicate, prepare and present output to various stakeholders
• Advanced knowledge of Excel modeling; familiarity with Argus Enterprise, Taliance, Tableau, SAP HANA, Snowflake or SQL is preferred
• Analytical Able to process large amounts of data, pick out relevant trends and report on them
• Self-starter Highly motivated to learn new concepts related to real estate portfolio management, investment, real estate finance and BI reporting
• After being given direction, able to work with minimal supervision to complete required tasks within areas of expertise
• Asks for direction and guidance when required
• Teamwork Experienced working in a team setting with various subject matter experts
• Self-aware and able to receive constructive feedback
• Able to effectively collaborate with team members and stakeholders

The expected hourly rate range for this role is $26.00 to $40.00 The actual hourly rate offered to the successful candidate may vary based on multiple factors including, but not limited to, individual's expertise and level of experience applicable to the role they are being offered.

About HOOPP

Founded in 1960 by the Ontario Hospital Association, the Healthcare of Ontario Pension Plan (HOOPP) is one of Canada’s strongest and most stable defined benefit pension plans. For over 65 years, HOOPP has delivered on its pension promise to Ontario’s healthcare workers, now serving more than 504,000 members and 870 employers across the province. With offices in Toronto and London, HOOPP manages a global, diversified multi-asset portfolio. One of Canada’s Maple 8 pension plans, HOOPP oversees $132 billion in assets and remains fully funded, supported by strong risk-adjusted returns, stable contribution rates for more than 20 years and independent governance. Our strength is powered by our people who bring HOOPP’s mission, vision and values to life and play a crucial role in helping us succeed. We are a purpose-driven organization committed to building an equitable, diverse and inclusive workplace where different perspectives drive better outcomes. We look for talented, forward-thinking individuals who want their work to have real impact on the lives of others. We believe an equitable, diverse and inclusive (EDI) workplace is integral to cultivating a positive culture. We integrate fair and inclusive practices into our programs and processes, creating equal opportunity and establishing a consistent employee experience across our organization. If you need accommodation at any point in our recruitment process, please advise your recruiter or email us at [e-mail] and we will be happy to consult with you so that arrangements can be made for reasonable accommodation.