Lead, Data Engineer

Company DescriptionMake 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 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 xc3 xa3o 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 The Data Engineering team is looking for people who are passionate about data and are looking to bring their expertise in big data and cloud by working in agile delivery environments to resolve engineering challenges of building robust and scalable data systems aligned to our enterprise data strategy As a Lead Data Engineer - you will be responsible for understanding the business requirements and translate the data engineering and analytics needs to support the development construction and testing of large-scale data processing systems based on AWS cloud to help address the disparate data consumption integration operation challenges of a growing organization By supporting investment professionals you will see first-hand 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 innovative mindset to tackle complex business requirements in the investment industry Role-specific 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 with data analysts to select and acquire non-traditional datasets and access clean and pre-process data as required by use cases Select appropriate datasets and data representation methods Collaborate with data analysts to have necessary data pipelines built Build train validate and test models using criteria relevant to business objectives Work in a fast-paced environment collaborating with data analysts data engineers and architects 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 Proven ability to work independently as well as to perform effectively in a team-oriented and open-concept environment Deep experience working with big data including cleaning transforming cataloguing mapping etc Experienced in 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 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 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 with time-sensitive deadlines Personable easily interacts with all types of personalities and at all levels with a high degree of professionalism Exemplify our Guiding Principles of Integrity Partnership and High Performance Additional InformationVisit our or Follow us on LinkedIn LI-AC LI-OnsiteAt 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