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
Data Engineer
Who You Are:· You can demonstrate 5+ years of experience in designing and building data-centric and reporting applications· Good working knowledge of various Azure cloud services such as Azure data factory: Pipelines, data sets, linked services, integrated with Self-hosted integration runtime, mappi...
Azure Data Platform Engineer
Design, develop, and maintain data pipelines using Azure Data Factory, incorporating XML and JSON data formats for data exchange and transformation. Minimum of 3 years of experience with Azure data services, including Azure Data Factory, Azure Data Lake, and Databricks. Our client is a leading Consu...
Operating Engineer, Data Centre - Markham, ON
Operating Engineer, Data Centre. As an Operating Engineer, you’ll play a crucial role in ensuring the smooth operation of our facility. Collaborate with engineers, technicians, and support staff for seamless operations. Improve operational procedures and implement best practices for data cente...
Senior Data Engineer - Data Insights (Remote) (Canada)
Building and maintaining data infrastructure, including data lakes, data warehouses, and real-time streaming platforms. Proven experience as a big data engineer or a similar role, with a deep understanding of big data technologies, frameworks, and best practices. Developing and optimizing data pipel...
Actuarial Lead Data Scientist
As a Lead Data Scientist, you will be at the heart of our analytics revolution, leading and mentoring a team of data scientists working with vast amounts of data across multiple corporate functions, with a specific focus on actuarial and financial analyses. In this role, you will lead and mentor a t...
Data Engineer
As a Data Engineer at Clio, you will build data pipelines and data warehouses from scratch, as well as make data sets accessible to our partner teams by writing great production code. Design, build, and maintain data transformation pipelines consolidating various data sources (streaming or batch) in...
Supply Chain MTI & LogOps Data Governance Lead - S4/HANA
Role is focused on establishing and upholding an enterprise data governance framework, ensuring adherence to data policies, standards, and practices, crucial for maintaining consistency, quality, and safeguarding data to fulfil overall business requirements during the design, implementation and supp...
Senior Data Engineer
We are looking for an experienced data pipeline builder and data modeler who enjoys optimizing data system to join our Data Science & Management team. Prepare and manipulate data using a variety of data integration and data pipeline tools including Talend, SQL, Snowflake, Kafka, and Azure Data Facto...
Data Engineer
The Data Engineer should have extensive experience working with very large data sets from the insurance industry and knowledge of building programs/mappings that leverage the Azure and Databricks platforms and Data warehouses. Strong preference will be given to Databricks Certified Data Engineer Ass...
Senior Data Engineer
Job Title: Senior Data Engineer. Must have overall 8+ Years of experience in Data Engineering with a bachelor’s degree. Diverse and inspiring colleagues and approachable leaders. ...