Senior Data Engineer, Reference, Total Fund Management & Risk, Data Platforms
CPP Investments | Investissements RPC•Toronto, ON
•Onsite
About The Position
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.
Requirements
- 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 Haves
- 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
Responsibilities
- 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
Benefits
- Competitive total rewards and benefits
- Comprehensive wellness programs
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
