Portfolio Reporting, Real Estate Debt, Winter 2027 - Vancouver (Co-op/Internship) - 4 Months
Sign up free to see how well your resume matches this role.
What you'll do
- Advance QuadReal’s agenda for driving insight at the portfolio level by contributing to scenario modelling, cash flow forecasting, leverage and liquidity analysis
- Build and manage complex financial models to analyze the portfolio in Excel, Anaplan, or other tools
- Analyze portfolio exposures, return attribution, and market trends and present them in a concise way through written and verbal forms
- Validate and reconcile data collected from different systems, and assist with data process improvement projects
- Work with multiple teams to maintain and build upon proprietary databases and reporting dashboards for accurate and timely reporting
- Assist in the preparation of monthly, quarterly and ad hoc management reports for senior management, Board of Directors and BCI
- Assist with ad hoc research projects for benchmarking, peer analysis, risk analysis, and other relevant topics
- Build out new portfolio analytics in Power BI to help provide insights to portfolio managers and senior management
What they're looking for
- Currently enrolled in an academic program, preferably in Real Estate, Finance, Accounting, Mathematics/Statistic or Economics.
- Strong quantitative and analytical skills; detail-oriented and proficient in building and handling complicated data sets.
- Excellent communication and presentation skills; demonstrate an ability to effectively communicate and present results that articulate key themes and messages.
- Must have advanced knowledge of Excel (VBA a plus).
- Must be enrolled in their academic studies at a post-secondary institution (university/college) and must be returning to school after completion of their work term with QuadReal.
Nice to have
- Working towards CFA is considered an asset.
- Additional computer programming skills and Power BI knowledge is considered a plus.
- Previous experience working within a real estate company, real estate brokerage or advisory firm, appraisal firm, or real estate lender is desirable.
Summarised by NextRaise from the employer’s description, which follows in full below.
Full description from employer
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.
We are committed to providing our Co-ops/Interns with a student experience that provides a supportive and engaging learning environment while developing skills and business acumen. Students will have the opportunity to participate in a variety of experiences including our Speaker Series, Fireside Chats, Volunteer opportunities and Networking events.
Eligibility Note: To qualify for a student (Co-op/Internship) opportunity, students must be enrolled in their academic studies at a post-secondary institution (university/college) and must be returning to school after completion of their work term with QuadReal. If you are a student registered in an official co-op program at your post-secondary institution and completion of a final work term is a mandatory component for you to graduate, you are eligible to apply with the understanding that you will leave QuadReal at the end of your work term or have the possibility to be considered for full-time opportunities.
Based in Vancouver, the Co-op/Intern, Portfolio Reporting, Real Estate Debt, will report to the Senior Analyst, Portfolio Reporting, Real Estate Debt. The candidate will assist with advancing portfolio analytics, data management and reporting, as well as gain broad exposure to the investment process by working closely with multiple teams (Investment, FP&A, Valuations, Research and Accounting).
What We Offer:
An organization and leaders that support your development through meaningful work experience
A Student Mentorship Program designed to provide support throughout your experience
Opportunities to build your industry knowledge through weekly Speaker Series & Fireside Chats
Opportunities to participate in case competitions within QuadReal during your work term, fostering cross-functional collaboration with intern peers and enhancing exposure to real-world problem-solving.
Giving back to the community with your peers and team members through volunteering events
Opportunities to build long-lasting industry and professional relationships
What You Will Experience:
Advance QuadReal’s agenda for driving insight at the portfolio level by contributing to scenario modelling, cash flow forecasting, leverage and liquidity analysis
Build and manage complex financial models to analyze the portfolio in Excel, Anaplan, or other tools
Analyze portfolio exposures, return attribution, and market trends and present them in a concise way through written and verbal forms
Validate and reconcile data collected from different systems, and assist with data process improvement projects
Work with multiple teams to maintain and build upon proprietary databases and reporting dashboards for accurate and timely reporting
Assist in the preparation of monthly, quarterly and ad hoc management reports for senior management, Board of Directors and BCI
Assist with ad hoc research projects for benchmarking, peer analysis, risk analysis, and other relevant topics
Build out new portfolio analytics in Power BI to help provide insights to portfolio managers and senior management
What You Will Bring:
Currently enrolled in an academic program, preferably in Real Estate, Finance, Accounting, Mathematics/Statistic or Economics. Working towards CFA is considered an asset.
Strong quantitative and analytical skills; detail-oriented and proficient in building and handling complicated data sets.
Excellent communication and presentation skills; demonstrate an ability to effectively communicate and present results that articulate key themes and messages.
Must have advanced knowledge of Excel (VBA a plus); additional computer programming skills and Power BI knowledge is considered a plus.
Previous experience working within a real estate company, real estate brokerage or advisory firm, appraisal firm, or real estate lender is desirable. A strong interest in developing a career within real estate is essential.
The expected hourly range for this role is $23 to $25.
#LI-DNP
The actual salary offered will take into consideration a wide array of factors including, but not limited to, the individual’s skill, experience, education and training, the market compensation of the role, and the consideration to internal equity.
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.
Note to Recruiters: QuadReal does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to QuadReal, directly or indirectly, will be considered QuadReal property. QuadReal will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for engaged services to submit resumes.
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.
Company
Company facts come from this company's own listings. We only show what the postings themselves carry.