Analyst, Real Estate Portfolio Analysis

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- membership in HOOPP’s world class defined benefit pension plan, which can serve as an important part of your retirement security- competitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team's diversity and mental health (e.g., gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, and newly extended maternity/parental leave top of 26 weeks)- optional post-retirement health and dental benefits subsidized at 50%- yoga classes, meditation workshops, nutritional consultations, and wellness seminars- access to an annual wellness reimbursement program for health and wellness-related expenses for permanent and temporary employees- 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

Job Summary

HOOPP Real Estate Investment Management (IM) manages the pension fund's real estate investment portfolio, which includes close to 60 million square feet of office, retail, industrial and multi-residential properties in Canada, the United States, the United Kingdom, and Western Europe. The Real Estate team currently includes 24 dynamic investment professionals, working in a fast-paced and entrepreneurial environment, who pride themselves on the adept management of a complex portfolio, the diligent execution of innovative deals, and providing consistent, competitive, long-term risk-adjusted returns. HOOPP Real Estate has a strong commitment to diversity & inclusion, sustainability and fighting climate change through our award-winning ESG program.

The Analyst will work primarily with individuals within Real Estate Investment Management, as well as with Real Estate Finance, Finance Business Solutions, and the Investment Solutions team.

What you will do:- Support the monthly capacity analysis production and semi-annual forecasting process in Taliance by validating and loading models for income producing properties, properties under development and fund investments while trouble-shooting any issue that may come up.- Ensure that data for new investments is accurately reflected in Tableau reporting. Collect and verify the accuracy of data points and reporting inputs from investment partners and elsewhere as required for the portfolio. Abstracting or synthesizing key data points from loan, asset/property/development management, and limited partner agreements as required.-

• Support report development in Tableau, which may include developing initial report requirements and/or building the report in Tableau, development of test cases, working with Finance-Business-Solutions to create the report; performing report testing and putting the report into production; and retesting modifications.- Support the Real Estate Investment Management team in the management of assets and risk analysis. Prepare other research reports and undertake additional analysis and projects as required.- Support the implementation and integration of new technologies as required, which may include drafting business cases to help with annual business planning processes, soliciting, and drafting business requirements, documenting processes, developing communication plans and help with any change management.

What you bring

• Post-secondary education in a relevant discipline such as Business Administration, Finance, commercial appraisal highly recommended.- 2 to 3 years of related analytical real estate experience with land, office, retail, industrial, multi-residential assets; real estate debt or developments.- Experience with Argus AE, Tableau, Qlik, MS Power BI, business process improvement- Strong analytical, problem solving and organizational skills, together with excellent oral and written communication and presentation skills.- Strong understanding of real estate forecasting and valuations- Strong competency in financial modelling and the ability to complete efficient and complex models in Excel or using other analytical tools- Experience with portfolio forecasting, and an understanding of time weighted vs money weighted returns.- Experience with Canadian and International valuation methods would be an asset- Experience working with IT teams, and writing software business requirements and test-cases considered an asset-
• Experience with Python, SQL, Taliance, Anaplan considered an asset- Demonstrated ability to produce effective reports; ability to analyze and interpret complex data sets and large volumes of informatio