31 Aug
|
Healthcare of Ontario Pension Plan Trust Fund
|
Ontario
31 Aug
Healthcare of Ontario Pension Plan Trust Fund
Ontario
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 chance 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
[email protected] and we will be happy to consult with you so that arrangements can be made for reasonable accommodation.
#J-18808-Ljbffr
📌 Real Estate Portfolio Analytics, Student Intern (Winter 2027 - 8 or 12 Months) (Ontario)
🏢 Healthcare of Ontario Pension Plan Trust Fund
📍 Ontario