Lead Data Engineer, Public & Alternative Investments, Data Platforms
- Full-time
- Function : Information Technology
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 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
- 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.
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
Minimum 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 (e.
g. 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
- Good understanding of financial data; CFA is a plus
At CPP Investments, we are committed to diversity and equitable access to employment opportunities based on ability.
We thank all applicants for their interest but will only contact candidates selected to advance in the hiring process.
Our Commitment to Inclusion and Diversity :
In addition to being dedicated to building a workforce that reflects diverse talent, we are committed to fostering an inclusive and accessible experience.
If you require an accommodation for any part of the recruitment process (including alternate formats of materials, accessible meeting rooms, etc.
please let us know and we will work with you to meet your needs.
J-18808-Ljbffr