Lead Data Engineer, Data Products

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

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 Lead, Data Engineer you will be responsible for developing, constructing, and testing large-scale data analytics systems based on AWS cloud that will help address the disparate analytics needs of a growing organization. 

Through close partnership with 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.

The opportunity:

• Conceptualize, design, and implement analytics products that enhance CPP Investments analytics capabilities.
• 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, architects, researchers, and data scientists.
• Ensure architecture will support the requirements of CPP Investments business.
• Develop tools that prepare, transform, combine, and manage structured and unstructured data for use by CPP Investments business users.
• Define and shape CPP Investments’ future technology and research process.

Qualifications

• University degree in Engineering or Computer Science preferred.
• Hands-on experience building data exploratory interfaces using Notebooks (JupyterHub/Lab, Spark/Livy, Sparkmagic, Enterprise Gateway, matplotlib, Plotly/Dash, etc.).
• Hands-on expertise with building data pipelines and applications, leveraging Kubernetes, Python, AWS Sagemaker, PySpark, YARN, S3, Athena, Glue, Lakeformation, Step Functions, Airflow, Serverless frameworks.
• Experience with Cloud based data and analytics platforms, warehouses (Redshift/Spectrum, Databricks, Snowflake), BI Tools, OLAP systems (Clickhouse, Druid), including a mix of relational, non-relational, streaming and event-based architectures.
• 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.
• Knowledge & experience with driving IaC concepts within an organization, leveraging Terraform, Ansible, Packer, Puppet/Chef, etc.
• Deep proficiency in Python with experience using Spark, Pandas or PySpark.
• Ability to work in an entrepreneurial environment and be a self-starter.
• Demonstrated ability to easily deal with both abstract and concrete concepts and be able to reconcile them for the appropriate audience and context preferred.
• Quickly understand organizational dynamics and management priorities, and to be able to work effectively in a fast paced, results driven company.
• Demonstrate strong facilitation, negotiation, interpersonal, communication and collaboration skills.
• Experience with front-end framework ie. Angular, React is a plus
• Interests in the financial industry.
• Exemplify CPP Investments’ Guiding Principles of Integrity, Partnership and High Performance.

Additional Information

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

#LI-Hybrid

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.