Associate, Business Intelligence

CPP Investments | Investissements RPC; Toronto; On-site; CAD 85,000 - 105,000; Full time

Benefits offered by this job

Cutting-edge AI tools

Dedicated learning time

Support for greater impact

Job summary

CPP Investments | Investissements RPC in Toronto is seeking an Associate in Business Intelligence to manage financial data analytics. The role involves gathering, analyzing, and reporting data to enable strategic decisions.

The ideal candidate will have a degree in a relevant field, with at least 5 years of experience in data analysis, proficiency in SQL and Python, and a collaborative mindset. The position offers exposure to investment products and advanced data tools.

Inclusive workplace culture, dedicated support for personal development and career growth.

Qualifications

• 5+ years of relevant experience required.
• Relevant professional designation (MBA, CPA, CFA) is an asset.
• Understanding of investment products is a plus.

Responsibilities

• Support the publishing of total fund level reporting.
• Leverage SQL and Python for complex data analysis.
• Collaborate with teams to identify reporting needs.

Skills

SQL

Python

Data analysis

Data visualization

Agile methodologies

Attention to detail

Education

Undergraduate degree or college diploma in a related field

Tools

AWS

Tableau

Job description

Purpose. Performance. People.

Joining CPP Investments means joining one of the world’s most admired and respected institutional investors to drive a single mandate: to deliver strong, sustainable returns for generations of Canadians.

With a long‑term horizon and global reach, we deploy capital at scale across public and private markets. Our size, stability, and disciplined investment philosophy allow us to pursue complex opportunities and build enduring partnerships worldwide.

For our people, this means meaningful work with tangible impact, real opportunity, and collaboration with exceptional colleagues who value partnership and performance. Here, you’ll contribute to outcomes that matter alongside team members committed to excellence and shared success.

Role Summary

As an Associate, Business Intelligence, you will lead in gathering, managing, analyzing, and reporting financial data to enable actionable insights and recommendations that support strategic decision‑making processes. You will also be responsible for delivering Total Fund reporting and analytics to consumers across the organization.

Accountabilities

• Support the timely and accurate publishing of total fund level reporting, including performing analysis to identify and explain significant changes to the Total Fund asset and exposure composition.
• Leverage technical tools (SQL, Python, AWS) to perform complex data analysis on large volumes of unstructured data to investigate and resolve reporting exceptions.
• Actively support partnerships with Enterprise Data Management and Technology to continuously enhance portfolio data quality & delivery and self‑serve reporting capabilities (e.g., data visualization, Tableau) based on end‑user requirements.
• Work with Investment Departments and Operations teams to identify evolving reporting needs, support investment decision‑making, gather business requirements, coordinate user acceptance testing, and provide ongoing training to downstream users.
• Work independently and as part of a fast‑paced team, building effective relationships within your team and across various groups at CPP Investments.
• Stay updated on industry trends, best practices, and emerging technologies in data analytics and reporting to enhance skills and capabilities.
• Develop tests and automate control checks to ensure the accuracy and completeness of information used.
• Lead cross‑functional projects and initiatives by identifying issues, assessing implications, recommending solutions, and proactively managing tasks and timelines.

Qualifications

• Undergraduate degree or college diploma in a related field.
• 5+ years of relevant experience.
• Understanding of investment products is an asset.
• Relevant professional designation (e.g., MBA, CPA, or CFA) or progression toward one is an asset.
• Advanced proficiency in SQL and Python; experience with AWS applications (e.g., QuickSight) is required.
• Demonstrated ability to produce insightful analysis of business issues and suggest potential solutions for complex situations.
• Knowledge or experience with Agile and Product Management concepts is an asset.
• Advanced experience working with large data sets, superior analytical skills, strong attention to detail, and the ability to communicate complex topics.

You are motivated to contribute to something larger than yourself, approach complex challenges with rigor, and hold yourself to high standards in a collaborative, performance‑driven environment.

We provide colleagues with cutting‑edge AI tools, dedicated learning time, and practical support to help them deliver with greater impact.

Inclusion & Accessibility

CPP Investments is committed to equitable access to employment and building a workforce that reflects diverse talent and perspectives. If you require accommodation at any stage of the recruitment process, please let us know and we will work with you to meet your needs.