Lead Data Engineer, Technology & Data

Company Description

Make an impact at a global and dynamic investment organization

When you join CPP Investments, you are joining one of the world’s most admired and respected institutional investors. With more than $600 billion in assets under management, CPP Investments is a professional investment management organization that globally invests the funds of the Canada Pension Plan (CPP) to help ensure it is financially sustainable for generations of working and retired Canadians.

CPP Investments invests across regions and asset classes to build a globally diversified portfolio. It holds assets in public equity, private equity, real estate, infrastructure, and fixed income, and the CPP Fund is projected to reach $3 trillion in assets by 2050. The organization is headquartered in Toronto with offices in Hong Kong, London, Mumbai, New York City, San Francisco, São Paulo, and Sydney.

CPP Investments successfully attracts, selects, and retains talented individuals from top-tier institutions worldwide. Join our team for access to:

• Stimulating work in a fast-paced and intellectually challenging environment
• Accelerated exposure and responsibility
• Global career development opportunities
• Diverse and inspiring colleagues and approachable leaders
• A hybrid-flexible work environment with an emphasis on in-person collaboration
• A culture rooted in principles of integrity, partnership, and high performance
• An organization with an important social purpose that positively impacts lives

If you have a passion for performance, value a collegial and collaborative culture, and approach work with the highest integrity, invest your career here. 

Job Description

The Data Engineering team is looking for people who are passionate about working in agile delivery environments and resolving the engineering challenges of building robust and scalable data systems aligned to enterprise data strategy.

As Senior Data Engineer You will be responsible for developing, constructing and testing large-scale data processing systems based on AWS cloud that will help address the disparate data consumption/integration/operation challenges of a growing organization. By supporting investment professionals, you will see firsthand how your contribution is delivering long-term value to the CPP Fund for the benefit of 20 million CPP contributors and beneficiaries. You are encouraged to bring an entrepreneurial, innovative mindset to tackle complex business requirements in the investment industry.

Accountabilities:

• 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.
• Work in a fast-paced environment collaborating with developers, data engineers and architects.
• Develop dataset processes for data modelling, mining and production.
• Ensure architecture will support the requirements of CPP Investments’ business.
• Prepare, transform, combine and manage structured and unstructured data for use by CPP Investments’ business users.
• Recommend ways to improve data reliability, efficiency and quality.
• Define and shape CPP Investments’ future technology and research process.

Qualifications

• University degree in Engineering or Computer Science preferred.
• Deep experience working with big data including cleaning/transforming/cataloging/mapping/ etc.
• Familiar with cloud technology best practices to enable the distribution and analysis of big data on the cloud (formatting/partitioning/etc.).
• Experience of ETL pipelines, managing multiple datasets and providing necessary support.
• Familiarity building applications in an AWS environment
• Familiarity working with data lakes using S3/Redshift.
• Exposure to big data workflows and analytics tools (Spark/EMR/Databricks/Cassandra).
• Deep proficiency in Python with experience using Spark, Pandas or PySpark.
• Familiar with one or more analytic tools such as Tableau or Qlik.
• An understanding of CI/CD pipelines and experience with DevOps.
• Experience building flexible solutions that can adapt quickly to changing requirements.
• Ability to work in an entrepreneurial environment and be a self-starter.
• Interests in the financial industry.
• Proven attention to accuracy and detail, highly organized with the ability to prioritize and multi-task
• Exceptional (written and verbal) communication skills and interpersonal skills.
• Ability to work in a high performing culture, under pressure and with time-sensitive deadlines
• Personable, easily interacts with all types of personalities and at all levels with a high degree of professionalism.
• Proven ability to work independently as well as to perform effectively in a team-oriented and open- concept environment.
• Exemplify our Guiding Principles of Integrity, Partnership, and High Performance.

Additional Information

Visit our LinkedIn Career Page or Follow us on LinkedIn. #LI-AC1 #LI-Onsite 

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.

Disclaimer:

CPP Investments does not accept resumes from employment placement agencies, head-hunters or recruitment suppliers that are not in a formal contractual arrangement with us. Our recruitment supplier arrangements are restricted to specific hiring needs and do not include this or other web-site job postings. Any resume or other information received from a supplier not approved by CPP Investments to provide resumes to this posting or web-site will be considered unsolicited and will not be considered.  CPP Investments will not pay any referral, placement or other fee for the supply of such unsolicited resumes or information.