Senior Data Engineer, Reference, Total Fund Management & Risk, Data Platforms

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:

The Senior Data Engineer plays a key role in building and evolving Reference and Index Data platforms within the enterprise Data Platform function. This role is responsible for designing and delivering high-quality, scalable data solutions on AWS, enabling trusted and governed data for analytics, investment, and risk use cases. Reporting to the Director, Engineering & Analysis, the Senior Data Engineer owns significant components of the platform, contributes to technical design decisions, and ensures reliable, efficient data pipelines and data products.

Accountabilities & Qualifications:

Accountabilities

• Design and implement components of reference and index data platforms aligned with target architecture
• Translate business and data requirements into scalable, production-grade solutions
• Contribute to solution design, technical documentation (e.g., LLDs, interface specs), and design reviews with Leads and Architects
• Build and maintain curated datasets and data products for enterprise consumption
• Develop, enhance, and operate robust data pipelines for ingesting and processing reference and index data
• Integrate vendor and internal data sources through MDM and AWS-based data platforms
• Deliver batch and near-real-time ingestion pipelines to meet business timelines (e.g., SOD processing)
• Build cloud-native data solutions leveraging AWS services (Glue, EMR, Athena, Redshift, Lake Formation)
• Optimize data pipelines and storage for performance, scalability, and cost efficiency
• Implement and maintain modern data lake solutions using table formats such as Apache Hudi and/or Apache Iceberg
• Support data governance practices including metadata management, lineage, access controls, and auditability
• Collaborate with Risk, Compliance, and Security teams to ensure adherence to enterprise standards
• Partner with product owners and stakeholders to understand requirements and drive adoption of data solutions
• Contribute to engineering best practices including CI/CD, automated testing, and infrastructure as code
• Support production operations including incident response, troubleshooting, and root-cause analysis
• Continuously improve technical capabilities and adopt modern data engineering practices

Qualifications

Required

• Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent experience)
• 5+ years of experience in data engineering or related roles
• Proven experience building and delivering scalable data pipelines and data platforms
• Hands-on experience with AWS data services (e.g., Glue, EMR, Athena, Redshift, Lake Formation)
• Strong programming skills in Python & SQL
• Experience with distributed data processing frameworks (e.g., Spark)
• Familiarity with modern data lake architectures and table formats (Apache Hudi and/or Apache Iceberg)
• Experience with CI/CD pipelines, automated testing, and Agile delivery practices
• Solid understanding of the software development lifecycle

Nice to Have

• Experience working with Reference Data, Index Data, or Master Data Management (MDM) domains
• Familiarity with EDM or similar enterprise data platforms
• Exposure to AI-assisted development tools and modern engineering workflows

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. 

 

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