Data Analyst - Portfolio Reporting, Real Estate Debt

QuadReal Property Group; Vancouver; On-site; CAD 74,000 - 84,000; Full time

Job summary

QuadReal Property Group in Vancouver, Canada seeks a Data Analyst - Portfolio Reporting, Real Estate Debt for a 12-month contract to support management reporting, forecasting and portfolio analytics across the RE Debt portfolio. You will translate reporting requirements into data specifications and build data flows from the Enterprise Data Platform to the reporting layer.

You will collaborate with ED&A, IT, Real Estate Debt Investment, Accounting, Operations, FP&A and Portfolio Management,

Qualifications

• University degree in a quantitative discipline (Statistics, CS, IS, Math, Engineering) or related field.
• 2–3 years in a data analyst role, ideally in investment management or real estate.
• Strong analytical and communication skills; detail-oriented and able to handle large data sets.

Responsibilities

• Support scenario modelling, cash flow forecasting and leverage analysis using Anaplan and ad-hoc financial models.
• Analyze portfolio exposures, return attribution, and market trends; prepare AI-enhanced insights and visuals for presentations.
• Prepare monthly, quarterly and ad hoc management reports for senior management, Board of Directors and BCI.
• Provide portfolio impact analysis to support real estate debt investment underwriting.
• Conduct ad hoc research for benchmarking, peer analysis and risk assessment.
• Query and extract data from enterprise data platforms to support reporting and analytics.
• Develop and maintain business logic and data transformation rules underpinning reporting outputs.
• Act as liaison to IT and ED&A translating requirements and validating outputs.
• Support data governance and data enablement initiatives across the RE Debt portfolio.
• Validate and reconcile data from different systems using AI-powered anomaly detection.

Skills

SQL

Power Query

Excel

Power BI

Education

University degree in quantitative discipline

CFA or similar designation (plus)

Tools

Anaplan

Tableau

Python

Job description

About QuadReal Property Group

QuadReal Property Group is a global real estate investment, development and operating company headquartered in Vancouver, British Columbia. Its assets under management are $98.5 billion. From its foundation in Canada as a full-service real estate operating company, QuadReal has expanded its capabilities globally for investments in equity and debt in both the public and private markets. QuadReal invests directly through operating platforms in which it holds an ownership interest and via programmatic partnerships.
QuadReal seeks to deliver strong investment returns while creating sustainable environments that bring value to the people and communities it serves. Now and for generations to come.
QuadReal: Excellence lives here.
www.quadreal.com

Role Description:

The Data Analyst - Portfolio Reporting, Real Estate Debt (12 month Contract) will report directly to the Director, Portfolio Reporting, Real Estate Debt. We are seeking a highly motivated individual with a background in Data Science or Data Analytics who is looking to develop their career in an entrepreneurial and high-energy environment. Embedded within the business, this role supports management reporting, forecasting, and portfolio analysis across the RE Debt portfolio, in addition to being the primary liaison to ED&A and IT — translating reporting requirements into data specifications and building data flows from the Enterprise Data Platform through to the reporting layer. This position also works closely with the Real Estate Debt Investment, Accounting, and Operations teams, FP&A, and Portfolio Management teams across QuadReal.

Role Description:

• Support scenario modelling, cash flow forecasting, leverage and liquidity analysis through Anaplan, supplemented by ad-hoc financial models as needed, using AI-assisted development for efficiency and quality control
• Analyze portfolio exposures, return attribution, and market trends, and support the development of presentation materials with AIenhanced insights and visualization
• Assist in the preparation of monthly, quarterly and ad hoc management reports for senior management, Board of Directors and BCI
• Support real estate debt investment underwriting by providing portfolio impact analysis
• Assist with ad hoc research projects for benchmarking, peer analysis, risk analysis, and other relevant topics
• Query and extract data from enterprise data platforms to support portfolio reporting and analytics needs
• Develop and maintain business logic, portfolio calculations, and data transformation rules that underpin reporting outputs
• Serve as the primary business-side liaison to IT and ED&A, translating reporting requirements into data specifications and validating platform outputs
• Support data enablement initiatives and ongoing data management and governance priorities across the RE Debt portfolio
• Validate and reconcile data collected from different systems using AI-powered anomaly detection to improve data quality and identify process improvement opportunities

Experience And Qualifications:

• University degree in a quantitative discipline (e.g. Statistics, Computer Science, Information Systems, Mathematics, Engineering, or a related field) OR a background in Economics, Finance or a related business field. CFA or similar designation is a plus
• 2–3 years of experience working in a data analyst role, ideally in investment management or real estate.
• Analytical – Strong quantitative and analytical skills; detail-oriented and proficient in building and handling complicated data sets.
• Excellent communication and presentation skills; demonstrates an ability to effectively communicate and present results that articulate key themes and messages.
• Must be able to allocate time effectively and work under pressure to meet tight deadlines, handle multiple demands and competing priorities, and adapt to new ideas and change. Comfortable following direction but also contributing to the direction.
• Advanced knowledge of SQL, Power Query, Excel, and Power BI is required. Familiarity with Anaplan or a similar planning tool is an asset. Experience with Tableau or Python is considered a plus
• Proactive approach to leveraging technology for process improvement and analytical enhancement. Comfortable learning and applying new tools, automation techniques, GenAI applications (e.g., Claude, ChatGPT, Microsoft Copilot), and advanced analytics platforms to solve complex problems, automate data analysis, rapidly prototype financial models, and deliver higher-quality insights.
• Has a questioning frame of mind, asks "why" and challenges the status quo with improvements to drive change when needed.

The expected annualized base salary range for this role is $74,000-$84,000.

We value diverse experiences and perspectives. Even if your skills don’t align 100% with the listed qualifications or salary range, we encourage you to apply – you may be a great fit for this role or others in our community. Applicants may also be considered for alternative positions within the organization where their qualifications and experience align more closely with available opportunities.

We use artificial intelligence (AI) technology — alongside human review — to assist in screening and assessing applicants for this position. Our recruitment team remains involved in all decisions.

Candidates must be legally authorized to work in Canada as the company does not provide work permit sponsorship for this role.

QuadReal Property Group will provide reasonable accommodation at any time throughout the hiring process for applicants with disabilities or for those needing job postings in an alternate format. If you require accommodation, please advise the Talent Acquisition team member you are working with and include the following: Job posting #, your name and your preferred method of contact.