Associate, Business Intelligence

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 of 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 & Qualifications:

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.

Leveraging technical tools (i.e. SQL, Python, AWS), 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 in 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 to support investment decision-making. Assist in gathering business requirements, coordination the user acceptance testing and provide ongoing training to downstream users.

Strong ability to work independently and as part of the team in a fast-paced environment, while building effective working 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.

Assist in developing tests and automating control checks to ensure the accuracy and completeness of information being 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 related field

5+ year of relevant experience

Understanding of investment products is considered an asset

Relevant professional designation (e.g., MBA, CPA or CFA) or progression toward one considered an asset.

Advanced proficiency in SQL and Python; experience in AWS relevant applications (e.g. QuickSight, etc.)

Demonstrated ability to produce insightful analysis of business issues and suggest potential solutions for complex situations.

Knowledge and/or experience of Agile and Product Management concepts considered an asset.

Advanced experience working with large data sets, using superior analytical skills, having a strong attention to detail and 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.

Attention: Protect Yourself from Fraud

CPP Investments is committed to a secure and transparent recruitment process. We will never ask candidates for payment or financial information at any stage of hiring. All legitimate opportunities are posted on our careers page, and communications will come from our applicant tracking system, Workday.

CPP Investments may use AI tools to help screen and assess applicants by analyzing resumes and applications for relevant skills and experience. These tools support, but do not replace, human decision-making.

#LI-ONSITE