Senior Analyst, Real Estate Portfolio Analytics

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 described below — data validation, reconciliation, input collection, documentation, and first-pass analysis and commentary — and use the capacity released to support the wider team.

Design, build, document and maintain reusable prompts, templates and AI-assisted workflows that the team can adopt independently, so capability is embedded in the process rather than resident in one person.

Apply AI to quality control: cross-checking data between systems, surfacing anomalies in portfolio data, and flagging gaps before they reach a published report.

Evaluate and pilot emerging AI capabilities relevant to real estate data, valuation, forecasting and reporting, and assess each against HOOPP's data handling, privacy, records and information security requirements before adoption, escalating questions through the appropriate internal channels.

Define and uphold the review standards for AI-assisted output, making clear what must be independently verified before it is relied on, and maintaining an audit trail appropriate to a regulated pension environment.

Build the team's fluency through short demonstrations, working sessions and one-to-one coaching, and track adoption and time saved so the benefit can be demonstrated to leadership.

Represent REDA in cross-functional discussions on AI and data tooling with ISG, BSG and Finance, and bring back what is relevant to real estate.

Own the semi-annual Forecast, monthly Capacity Analysis and quarterly Pacing Plans: set deliverables and due dates for contributors, direct the Co-op Analyst's inputs, chase outstanding items, and consolidate and interpret the results.

Own the monthly Executive Dashboard end to end, from data verification through review, approval and publication, and explain what drives the metrics month over month.

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, including portfolio loan-to-value, reproducing calculations from source data and reconciling methodology differences with Risk and Finance.

Support the annual credit rating refresh and other external reporting, assembling schedules from Accounting, Finance and the Business Partner team and reconciling figures across sources.

Set and maintain the standards for loading and validating underwriting, development and LP models in Taliance, and extend its automation across debt reconciliation, LP cash calls and distributions, and multiple debt assumptions.

Own the design and enhancement of BI reports, approve them for publication, and contribute to reporting platform and system changes as they arise.

Act as a liaison between Investment Management, ISG and Finance so that data for new investments is accurately reflected in reporting, and oversee testing of BI reports and HANA views.

Abstract and interpret key terms from loan, asset and development management, and limited partner agreements, and confirm they are correctly reflected in the models and reporting.

Direct the day-to-day work of the Co-op Analyst: set priorities, explain the investment context behind the task, review output, and provide regular coaching and feedback.

Build documentation and training material that shortens ramp-up time for new team members and co-op students.

A practical problem solver — you understand real estate investing well enough to know which problems are worth solving, and you work back from the decision the team is trying to make.

An analytical thinker — you turn complex data into insight and action.

A teacher as much as a builder — you would rather make five people faster than be the fastest person on the team, and you enjoy explaining how something works.

A self-starter who is accountable — you pick up new tools and concepts quickly and do not wait to be asked.

A clear communicator — you tailor the message to investment, technical and external audiences.

Organized and adaptable — you hold quality across multiple deadlines and stay practical when priorities shift.

Detail-oriented and appropriately skeptical — accurate in the numbers, deliberate in presentation, and clear-eyed about where AI output needs to be verified before anyone relies on it.

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.