Lead Data Engineer, Public & Alternative Investments, Data Platforms

Company Description

Make an impact at a global and dynamic investment organization

When you invest your career in CPP Investments, you join one of the most respected and fastest growing institutional investors in the world.

With current assets under management valued in excess of $500 billion, CPP Investments is a professional investment management organization that globally invests the funds of the Canada Pension Plan (CPP) to help ensure long-term sustainability.

The CPP Fund is projected to reach $3 trillion by 2050. CPP Investments invests in all major asset classes, including public equity, private equity, real estate, infrastructure and fixed-income instruments, and is headquartered in Toronto with offices in Hong Kong, London, Luxembourg, Mumbai, New York City, San Francisco, São Paulo and Sydney.

CPP Investments attracts and selects high-calibre individuals from top-tier institutions around the globe. Join our team and look forward to :

• Diverse and inspiring colleagues and approachable leaders
• Stimulating work in a fast-paced, intellectually challenging environment
• Accelerated exposure and responsibility
• Global career development opportunities
• Being motivated every day by CPP Investments’ important social purpose and unshakable principles
• A flexible / hybrid work environment combining in office collaboration and remote working
• A deeply rooted culture of Integrity, Partnership and High Performance

If you share a passion for performance, value a collegial and collaborative culture, and approach everything with the highest integrity, here’s an opportunity for you to invest your career at CPP Investments.

Job Description

As a Lead Data Engineer, you will be working on the Data Service Applications for Public Markets and Alternative Assets.

The role will involve -

Role-Specific Accountabilities :

• Leading the design, implementation and deployment of data pipelines to transform (structure and map) vendor data into CPPIB standard format
• Design solutions aligned with long-term architecture and technology strategy using Amazon Web Services (AWS) for Cloud development
• Participate in the development life cycle from start to completion - requirements analysis, development, testing, and deployment
• Design and implement the data model and enriched strategy neutral data
• Design and implement the data service using Amazon Web Service (AWS)
• Design and implement data related tools and analytics, in addition to operational processes
• Address daily data exceptions on a timely basis and provide L3 operation support
• Stay current with new data vendor product offerings and how they might be used by the quantitative investment groups
• Manage and enhance investment data infrastructure through initiatives such as improving metadata and data integrity
• Work in a fast-paced environment collaborating with business users, engineers, architects, researchers, and data scientists

Qualifications

• A Bachelor’s degree in computer science or engineering
• Hands on Experience with data engineering technologies such as AWS Glue, EMR, Athena, Redshift, Lake Formation, Apache Spark, Apache Hive, Apache Airflow, S3, CloudWatch, Lambda, Apache Hudi, API Gateway, GraphQL, Elastic Search, Elastic Cache and Trino
• Hands on experience with CI / CD pipeline using Terraform, Jenkins, Github actions, Gitflow
• Experience working with RESTful APIs. Familiarity with microservices architecture
• Strong programming skills in Python, pyspark, SQL, Java with professional programming experience in a data context is a must ( data extraction, data manipulation, joins, data analysis, data model design etc.)
• Experience of building data pipelines using orchestration tool like Apache Airflow
• Experience in ML and Generative AI is a big plus
• Ability to deliver time-sensitive deadlines
• Good understanding of financial data; CFA is a plus
• Passionate to learn new technology
30+ days ago