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 formatDesign solutions aligned with long-term architecture and technology strategy using Amazon Web Services (AWS) for Cloud developmentParticipate in the development life cycle from start to completion - requirements analysis, development, testing, and deploymentDesign and implement the data model and enriched strategy neutral dataDesign and implement the data service using Amazon Web Service (AWS)Design and implement data related tools and analytics, in addition to operational processesAddress daily data exceptions on a timely basis and provide L3 operation supportStay current with new data vendor product offerings and how they might be used by the quantitative investment groupsManage and enhance investment data infrastructure through initiatives such as improving metadata and data integrityWork in a fast-paced environment collaborating with business users, engineers, architects, researchers, and data scientistsQualifications
A Bachelor’s degree in computer science or engineeringHands 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 TrinoHands on experience with CI / CD pipeline using Terraform, Jenkins, Github actions, GitflowExperience working with RESTful APIs. Familiarity with microservices architectureStrong 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 AirflowExperience in ML and Generative AI is a big plusAbility to deliver time-sensitive deadlinesGood understanding of financial data; CFA is a plusPassionate to learn new technology