Senior Analyst, Real Estate Portfolio Analytics
HOOPP (Healthcare of Ontario Pension Plan) · CA
18 days agoImpress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Senior Analyst, Real Estate Portfolio Analytics role.
Rezi rewrites your resume against HOOPP (Healthcare of Ontario Pension Plan)'s job description. Free.

Tailor your resume to this Senior Analyst, Real Estate Portfolio Analytics role.
Rezi rewrites your resume against HOOPP (Healthcare of Ontario Pension Plan)'s job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Senior Analyst, Real Estate Portfolio Analytics posting at HOOPP (Healthcare of Ontario Pension Plan) — free, in seconds.

Don't guess if your resume is good enough.
See how it scores against the Senior Analyst, Real Estate Portfolio Analytics posting at HOOPP (Healthcare of Ontario Pension Plan) — free, in seconds.
About the Role
The Real Estate Investment Management group at HOOPP is seeking a Senior Analyst, Real Estate Portfolio Analytics to join the Real Estate Data and Analysis (REDA) team. This dual-mandate role involves serving as the team's artificial intelligence subject matter expert and managing the recurring analytics and reporting cycle, with a focus on automating repeatable tasks to enhance AI capabilities.
Responsibilities
- Serve as the real estate team's subject matter expert on artificial intelligence, advising colleagues on tool selection, effective prompting, workflow design, and where human review remains essential.
- Automate the recurring analytics and reporting work, including data validation, reconciliation, input collection, documentation, and first-pass analysis and commentary.
- Design, build, document and maintain reusable prompts, templates and AI-assisted workflows for team adoption.
- Apply AI to quality control by cross-checking data between systems, surfacing anomalies, and flagging gaps.
- Evaluate and pilot emerging AI capabilities relevant to real estate data, valuation, forecasting and reporting.
- Define and uphold review standards for AI-assisted output, ensuring independent verification and maintaining an audit trail.
- Build the team's AI fluency through demonstrations, working sessions, and coaching.
- Represent REDA in cross-functional discussions on AI and data tooling.
- Own the semi-annual Forecast, monthly Capacity Analysis, quarterly Pacing Plans, and monthly Executive Dashboard end to end.
- Deliver portfolio analysis and ad-hoc data support, including return attribution, correlation analysis, benchmark analysis and market research.
- Monitor and report on investment policy limits.
- Support the annual credit rating refresh and other external reporting.
- Set and maintain standards for loading and validating underwriting, development and LP models in Taliance.
- Own the design and enhancement of BI reports and contribute to reporting platform changes.
- Act as a liaison between Investment Management, ISG and Finance for data accuracy in reporting.
- Abstract and interpret key terms from agreements and confirm they are correctly reflected in models and reporting.
- Direct the day-to-day work of the Co-op Analyst, including setting priorities, reviewing output, and providing coaching.
- Build documentation and training material to shorten ramp-up time for new team members.
Requirements
- 4–6 years of relevant working experience in real estate, finance, investment or accounting.
- A solid grounding in real estate investment concepts, including capitalization rates, IRRs and discounted cash flow analysis.
- Proficiency in financial statements and building complex financial models in Excel.
- Experience applying AI tools to analytical, reporting or operational work with concrete examples of process improvements.
- Ability to bring others along with AI implementation.
- Sound judgment on data sensitivity and confidentiality.
- Comfort working within the controls expected of a regulated pension organization.
- Experience directing, reviewing or mentoring junior analysts or co-op students is an asset.
Skills
- Artificial Intelligence
- Data Analysis
- Reporting
- Portfolio Management
- Forecasting
- Business Intelligence (BI)
- Argus Taliance
- Tableau
- Power BI
- SAP HANA
- Snowflake
- Python
- SQL
- Excel
- Financial Modeling
- Real Estate Investment Concepts
- Capitalization Rates
- IRR Analysis
- Discounted Cash Flow Analysis
- Financial Statements Analysis
- Prompt Engineering
- Workflow Design
- Data Validation
- Reconciliation
- Quality Control
- Emerging AI Capabilities Evaluation
- Investment Policy Monitoring
- Credit Rating Support
- Underwriting Model Loading
- Development Model Loading
- LP Model Loading
- Debt Reconciliation
- LP Cash Calls
- LP Distributions
- Debt Assumptions
- BI Report Design
- BI Report Enhancement
- Data Liaison
- Agreement Interpretation
- Team Direction
- Mentoring
- Documentation
- Training Material Development
Location
- Ontario
Work Type
- Full-time
Experience Level
- Senior
- 4-6 years
Education Level
- BSc, BA or MBA in a related field
- CFA or CPA designation is an asset
Salary/Compensations
- $103,000 - $153,000 CAD
Benefits
- High-performance, people-focused culture
- Commitment to equity, diversity, and inclusion
- Learning and development initiatives (workshops, Speaker Series, LinkedIn Learning)
- Membership in HOOPP’s defined benefit pension plan
- Competitive, 100% company-paid extended health and dental benefits for permanent employees
- Coverage supporting diversity and mental health (gender affirmation, fertility, drug treatment, psychological support up to $2,500/year)
- Parental leave top-up
- Health spending account
- Optional post-retirement health and dental benefits subsidized at 50%
- Yoga classes
- Meditation workshops
- Nutritional consultations
- Wellness seminars
- Discretionary incentive plan(s)
About the Company
- HOOPP (Healthcare of Ontario Pension Plan) is a world-class defined benefit pension plan.
- The Real Estate Investment Management group manages real estate investments.
- The Real Estate Data and Analysis (REDA) team provides insights, analytics, AI support, and reporting for the real estate investment management team.
- HOOPP operates within a regulated pension environment.
Equal Opportunity
- HOOPP may use artificial intelligence tools to assist in screening, assessing and selecting applicants for this position. These tools support our recruitment process but do not replace human judgment and decision-making.