Lead Data Engineer, Public

4 months ago


Old Toronto, Canada CPP Investments Full time
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-caliber individuals from top-tier institutions around the globe.

Join our team and look forward to:

  1. Diverse and inspiring colleagues and approachable leaders
  2. Stimulating work in a fast-paced, intellectually challenging environment
  3. Accelerated exposure and responsibility
  4. Global career development opportunities
  5. Being motivated every day by CPP Investments' important social purpose and unshakable principles
  6. A flexible/hybrid work environment combining in-office collaboration and remote working
  7. A deeply rooted culture of Integrity, Partnership, and High Performance
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:
  1. Leading the design, implementation, and deployment of data pipelines to transform (structure and map) vendor data into CPPIB standard format
  2. Design solutions aligned with long-term architecture and technology strategy using Amazon Web Services (AWS) for Cloud development
  3. Participate in the development life cycle from start to completion - requirements analysis, development, testing, and deployment
  4. Design and implement the data model and enriched strategy neutral data
  5. Design and implement the data service using Amazon Web Service (AWS)
  6. Design and implement data related tools and analytics, in addition to operational processes
  7. Address daily data exceptions on a timely basis and provide L3 operation support
  8. Stay current with new data vendor product offerings and how they might be used by the quantitative investment groups
  9. Manage and enhance investment data infrastructure through initiatives such as improving metadata and data integrity
  10. 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 an 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

#J-18808-Ljbffr

  • Old Toronto, Ontario, Canada CPP Investments Full time

    Job Title: Lead Data Engineer, Public MarketsAt CPP Investments, we're seeking a highly skilled Lead Data Engineer to join our team in Public Markets. As a key member of our data engineering team, you will be responsible for designing, implementing, and deploying data pipelines to transform vendor data into our standard format.Key Responsibilities:Lead the...


  • Old Toronto, Ontario, Canada CPP Investments Full time

    Job Title: Lead Data Engineer, Public MarketsAt CPP Investments, we're seeking a highly skilled Lead Data Engineer to join our team in Public Markets. As a key member of our data engineering team, you will be responsible for designing, implementing, and deploying data pipelines to transform vendor data into our standard format.Key Responsibilities:Lead the...


  • Old Toronto, Ontario, Canada CPP Investments Full time

    Job Title: Lead Data Engineer, Public MarketsAt CPP Investments, we're seeking a highly skilled Lead Data Engineer to join our team in Public Markets. As a key member of our data engineering team, you will be responsible for designing, implementing, and deploying data pipelines to transform vendor data into our standard format.Key Responsibilities:Lead the...


  • Old Toronto, Ontario, Canada CPP Investments Full time

    Job Title: Lead Data Engineer, Public MarketsAt CPP Investments, we're seeking a highly skilled Lead Data Engineer to join our team in Public Markets. As a key member of our data engineering team, you will be responsible for designing, implementing, and deploying data pipelines to transform vendor data into our standard format.Key Responsibilities:Lead the...


  • Old Toronto, Canada CPP Investments Full time

    Lead Data Engineer, Public & Alternative Investments, Data PlatformsFull-timeFunction: Information TechnologyMake an impact at a global and dynamic investment organizationWhen 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...


  • Old Toronto, Canada CPP Investments Full time

    Lead Data Engineer, Public & Alternative Investments, Data PlatformsFull-timeFunction: Information TechnologyMake an impact at a global and dynamic investment organizationWhen 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...


  • Old Toronto, Canada CPP Investments Full time

    Lead Data Engineer, Public & Alternative Investments, Data PlatformsFull-timeFunction: Information TechnologyMake an impact at a global and dynamic investment organizationWhen 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...


  • Old Toronto, Canada CPP Investments Full time

    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...


  • Old Toronto, Ontario, CA CPP Investments Full time

    Lead Data Engineer, Public & Alternative Investments, Data PlatformsFull-timeFunction: Information TechnologyMake an impact at a global and dynamic investment organizationWhen 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...


  • Old Toronto, Ontario, CA CPP Investments Full time

    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...

  • Lead Data Engineer

    3 weeks ago


    Toronto, Ontario, Canada CPP Investments Full time

    About CPP Investments CPP Investments is a leading global investment management organization, managing the funds of the Canada Pension Plan (CPP) to ensure long-term sustainability. With assets under management exceeding $500 billion and projected to reach $3 trillion by 2050, CPP Investments invests across all major asset classes, including public equity,...

  • Data Engineer

    1 week ago


    Toronto, Canada Pacific Data Integrators Full time

    The Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer. Role and Responsibilities: Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a

  • Data Engineer

    1 week ago


    Toronto, Canada Pacific Data Integrators Full time

    The Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer. Role and Responsibilities: Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a business relationship that assists in meeting business...

  • Data Engineer

    7 days ago


    Toronto, Canada Pacific Data Integrators Full time

    The Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer.Role and Responsibilities:Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a business relationship that assists in meeting business...

  • Data Engineer

    1 week ago


    Toronto, Canada Pacific Data Integrators Full time

    The Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer.Role and Responsibilities:Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a business relationship that assists in meeting business...

  • Data Engineer

    1 week ago


    Toronto, Canada Pacific Data Integrators Full time

    The Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer.Role and Responsibilities:Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a business relationship that assists in meeting business...

  • Data Engineering Lead

    2 weeks ago


    Old Toronto, Ontario, Canada Royal Bank of Canada> Full time

    Job SummaryJob DescriptionWhat is the Opportunity?This is an exciting opportunity within the Data & Analytics team at Royal Bank of Canada. We are seeking a highly skilled and motivated individual to join our dynamic team as a Data Engineering Lead. As a key member of our data engineering team, you will play a crucial role in leading a team of talented data...

  • Data Engineering Lead

    2 weeks ago


    Old Toronto, Ontario, Canada Royal Bank of Canada> Full time

    Job SummaryJob DescriptionWhat is the Opportunity?This is an exciting opportunity within the Data & Analytics team at Royal Bank of Canada. We are seeking a highly skilled and motivated individual to join our dynamic team as a Data Engineering Lead. As a key member of our data engineering team, you will play a crucial role in leading a team of talented data...


  • Toronto, Canada CPP Investments Full time

    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...

  • Data Engineer

    1 week ago


    Toronto, ON, Canada Pacific Data Integrators Full time

    The Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer. Role and Responsibilities: Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a business relationship that assists in meeting...