Senior Engineer, Public

Company DescriptionMake an impact at a global and dynamic investment organizationWhen you join CPP Investments, you are joining one of the world’s most admired and respected institutional investors. As a professional investment management organization, CPP Investments invests the funds of the Canada Pension Plan (CPP) to help ensure its financial sustainability for generations of working and retired Canadians.CPP Investments invests across regions and asset classes to build a globally diversified portfolio. It holds assets in public equity, private equity, real estate, infrastructure, and fixed income, and the CPP Fund is projected to reach $ trillion in assets by 2050. The organization is headquartered in Toronto with offices in Hong Kong, London, Mumbai, New York City, San Francisco, São Paulo, and Sydney.CPP Investments successfully attracts, selects, and retains talented individuals from top-tier institutions worldwide. Join our team for access to:Stimulating work in a fast-paced and intellectually challenging environmentAccelerated exposure and responsibilityGlobal career development opportunitiesDiverse and inspiring colleagues and approachable leadersA hybrid-flexible work environment with an emphasis on in-person collaborationA culture rooted in principles of integrity, partnership, and high performanceAn organization with an important social purpose that positively impacts livesIf you have a passion for performance, value a collegial and collaborative culture, and approach work with the highest integrity, invest your career here. Job DescriptionOur Public & Alternative Investments Data Platforms team integrates diverse vendor data sources, builds robust and scalable data pipelines, and delivers strategy-neutral, enriched, and centrally governed data products that empower investment decision-making and research across both Public Markets and Alternative Assets.We also develop comprehensive carbon emissions datasets that help advance the Fund’s commitment to sustainable investing, enabling the integration of environmental insights into portfolio analysis and decision-making.As a Senior Data Engineer, you will lead pieces of work focused on developing, constructing, testing, and maintaining Enterprise Data and large-scale processing systems. You will drive engineering excellence and continuous improvement within your team applying data engineering best practices to support the organization's data initiatives and contribute to the enhancement of Enterprise Data Products.Accountabilities:Own aspects of designing, building, and maintaining scalable and efficient data pipelines to Data Products from various sources to storage and analytical systems.Provide on-call support for production systems, identify and create automation for reducing MTTR and mature operational runbooks.Help implement processes and tools to monitor and improve data quality, including data profiling, data freshness, and ensuring SLA adherence.Partner with Data Governance team to establish data governance policies and procedures to ensure data accuracy, privacy, and security.Advocate and drive adoption of DevOps & QE culture, supporting presentations in various internal forums and sessions on product releases, best practices, and provide consulting, guidance, and implementation assistance to users/application teams.Collaborate with cross-functional teams such as data scientists, analysts, and software engineers to understand data requirements and deliver solutions that meet business needs.Stay updated on emerging technologies, trends, and best practices in data engineering and related fields. Continuously evaluate and adopt new tools and techniques to enhance productivity and innovation.QualificationsUndergraduate degree or college diploma in related field ( Engineering, Computer Science). 4+ years of relevant experience. Experience working with Big Data, including change data capture. data quality, data lineage, etc. Solid programming skills with professional programming experience in AWS Data & Analytics context (EMR, Glue, Lakeformation, Airflow, PySpark, Trino, Hudi, Iceberg)Expertise with data quality principles, data profiling techniques, and data governance best practices.AWS Certified Data & Analytics Specialty