Analyst, Real Estate Portfolio Analysis

Why you’ll love working here:

• Access to an annual wellness reimbursement program for health and wellness-related expenses for permanent and temporary employees
• 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
• 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
• 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)
• 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
• Optional post-retirement health and dental benefits subsidized at 50%
• Yoga classes, meditation workshops, nutritional consultations, and wellness seminars
• High-performance, people-focused culture

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.

Reporting to the Manager, Real Estate Analysis and Technology, the Analyst will be accountable for ensuring that the Real Estate IM portfolio reporting is accurate and complete each month, and that new investment deals are properly onboarded and reflected in the portfolio forecasting application and all subsequent reporting, enabling better decision making and risk management by HOOPP’s real estate portfolio management team.

This role also supports the continued innovation and integration of new technologies/applications, data sets, processes, and reporting that HOOPP’s real estate team is implementing to drive superior insights and real estate returns. The ideal candidate has a keen interest in real estate, technology, processes, data, and BI and reporting tools. They are excited to learn about the latest technologies being used in this space and to bring their ideas to an open-minded team that is working to provide the best tools possible to the real estate investment team.

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:

• Responsible for updating Taliance, the Real Estate Portfolio Forecasting application, with portfolio data, including forecasted acquisitions and dispositions; forecasted debt; ensuring monthly actuals are loaded; investigating issues and resolving as required; ensuring other data sources are updating as expected.
• 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 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.
• Support the consolidation of reporting across development managers as required. Under the direction of others, using scenario analyses, stress-test, and complete sensitivity analysis to determine impact of various risk scenarios, investment strategies and asset mix allocations on portfolio performance. As third-party applications (Argus, Taliance, Dealpath) expand their functionality, research whether the expanded functionality can help the real estate team and determine how it can be incorporated into existing processes.
• 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:

• 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
• Strong understanding of real estate forecasting and valuations
• Post-secondary education in a relevant discipline such as Business Administration, Finance, commercial appraisal highly recommended.
• Strong analytical, problem solving and organizational skills, together with excellent oral and written communication and presentation skills.
• Listens to and works well with others.
• Experience with Argus AE, Tableau, Qlik, MS Power BI, business process improvement
• Learns quickly, takes initiative, and works independently with minimal direction.
• Demonstrated thoroughness and attention to detail.
• Experience with portfolio forecasting, and an understanding of time weighted vs money weighted returns.
• Experience with Python, SQL, Taliance, Anaplan considered an asset
• 2 to 3 years of related analytical real estate experience with land, office, retail, industrial, multi-residential assets; real estate debt or developments.
• Strong competency in financial modelling and the ability to complete efficient and complex models in Excel or using other analytical tools
• Demonstrated ability to produce effective reports; ability to analyze and interpret complex data sets and large volumes of information
• Ability to manage multiple projects and tight deadlines; project management and quality assurance skills are a plus.
• Advanced knowledge of all Microsoft Office applications, Argus Enterprise