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.

Reporting to the “Managing Director, Data Platforms”, the “Director, Subledger & Enterprise Reporting” leads the design and implementation on CPP Investments' data platform to support the strategic data needs related to Subledgers, ABOR (account booking of records) and support enterprise reporting needs including datamarts, reporting and business intelligence. In this role, you will lead a team of talented data engineers, data analysts & data stewards who’ll build data capabilities and support a wide range of data flows and usecases to advance the Fund’s data-driven investment decisioning and deliver transformational programs. 

You’ll be accountable for designing and implementing the end-to-end data platform needs from managing foundational processing and data storage, to building and operating scalable pipelines, to developing analytical tools, and enterprise reporting applications to support various usecases.

Key responsibilities include:

•  
• Build a high performing global team with appropriate competencies and skillsets to deliver services that meet and strive to exceed business expectations.
• Provide technical oversight to a team of diverse data engineers/analysts/stewards to drive design and implementation of transformational data initiatives, plan team activities and priorities, provide coaching to technical aspect of work.
• Applies knowledge, leadership experience and be the data engineering technical leader to drive design and implement appropriate data architectures, infrastructure, data ingestion pipelines and enablement tools, processes, and controls to meet business needs and to help team to scale.
• Seeks and incorporates diverse perspectives to guide the team to resolve complex multi-dimensional problems and enhance overall business process or program value
• Drive team engagement, performance management, provide feedback and opportunities to help team members grow and achieve their professional development goals.
• Work collaboratively with business stakeholders, senior IT management, Data Engineering Teams, Data Architecture, Data solutions, and Data Operations
• Experience in hiring, organizing, and motivating teams and directing multiple priorities simultaneously serving multiple stakeholders
• Build clean software and systems abstractions, and understand that modular, reusable components are key to manageably supporting thousands of pipelines and beyond as we scale.
• Work cross-functionally: with upstream teams to guide and consult them on how to structure their data to expose good data contracts, and with downstream including data consumers and data teams to expose well-designed and well-documented data models and metrics.
• Closely partner with other data engineering, and data governance team to provide design recommendation for usecases and drive execution excellence by resolving increasingly complex issues
• Promote a DevOps & Quality Engineering culture within the team to increase automation while decreasing manual interventions and incidents.
• Evaluate emerging tech trends, experimenting with and learning new technologies, participating in internal & external technology communities, and mentoring other members of the engineering community
• Act as a role model, demonstrating the CPP Investments values, providing clear management support and development to the team, and following all CPP Investments people processes.

If you possess the following, we’d like to hear from you:

• University degree in Engineering or Computer Science preferred.
• 8+  years’ experience in technology with experience in architecture/engineering
• Hands-on expertise with AWS Data & Analytics, Cloud data platforms, data warehouse, business intelligence, data lakes and analytics products
• Experience working with database query languages and cloud data warehouses/MPP databases (Redshift/Spectrum, Snowflake, etc)
• Experience with batch job scheduling, leveraging Apache Airflow, AWS EMR, PySpark, YARN, EKS, S3, HDFS, AWS Athena, AWS Glue, Lakeformation, AWS Step Functions
• Experience building data exploratory interfaces using Notebooks (JupyterHub/Lab, Enterprise Gateway, matplotlib, Plotly/Dash, etc.) with Spark Integration using Livy, Sparkmagic
• Experience in data modeling, data architecture, data engineering, data analysis and familiarity with ETL tools, data warehousing & big data architecture and business intelligence reporting/analytics.
• Must have experience in data modeling, data visualization design and development including legacy ETL and modern ELT constructs and BI tools like Tableau, QlikView etc.
• Knowledge of cloud-native approaches to build fast, flexible, and cost-effective data applications on any data lake, open source column oriented DBMS and/or big data OLAP engines for analytical processing (like Clickhouse, Apache Kylin, Apache Pinot, etc.)
• Experience with DataOps and various continuous delivery practices to deploy, support and operate data pipelines
• Polished communication skills with experience presenting at the executive level. Ability to communicate credibly and persuasively with the broader organization and helping overcome the inevitable barriers to behavioral change.
• A “change agent” with proven ability to lead change across an organization in matters that require a major shift in thought and behavior.
• Proven ability to build strategic relationship and influence key stakeholders.
• Strong knowledge of software development best practices and patterns.
• Demonstrate strong facilitation, communication, interpersonal and collaboration skills.
• Exemplifies our Guiding Principles of partnership, integrity and high performance

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

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.