Senior Business Analyst, Real Assets, Alternative Investment Technology

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. As a professional investment management organization, CPP Investments invests the funds of the Canada Pension Plan (CPP) to help ensure its financial sustainability 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.6 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 Real Asset Engineering Team is looking for a Sr Business Analyst with experience in data analysis and SQL. The successful candidate will be experienced in working closely with the business to gather and document detailed requirements and help iteratively provide solutions. This position requires someone with high attention to detail, strong sense of creativity, ownership, integrity and strong analytical & problem-solving skills. The candidate is expected to possess working knowledge in data analytics and financial reporting, coupled with the ability to translate business requirements into solutions while working with engineering. The position also requires experience in SQL to create efficient queries and/or views to support the building of reports within the RA applications.

Accountabilities:

• Facilitate requirements gathering sessions. Document and validate results with subject matter experts and drive the creation of strong system specifications that enable the development and/or acquisition of appropriate systems to meet business requirements.
• Liaise with application developers and CPP Investments’ business subject matter experts to brainstorm and document innovative solutions alternatives. Evaluate alternatives relative to business requirements and provide advice that is rooted in deep subject matter expertise.
• Participate in process design meetings and translating outcomes into as-is and to-be process design flows, identifying efficiencies and leveraging the capability of digital resources. 
• Conduct process walkthroughs and validation with business subject matter experts. Document the key risks, mitigating controls, performance measures, cost drivers and business continuity plans for processes.
• Apply analytical and technical skills to investigate day-to-day system and business issues, determine the root cause and deliver viable solutions.
• Maintain accurate and comprehensive documentation of business requirements, functional specifications, and project deliverables. Generate reports and updates for stakeholders, executive leadership, and project sponsors to communicate project status, risks, and issues.

Qualifications

• 5+ years of experience as a Business Analyst, working directly with the business stakeholders, product owners, and engineering team to build complex solutions in the financial/investment industry
• 5+ years of experience and working with relational database technologies (e.g. Oracle, MS SQL Server or AWS Athena). Proficiency with SQL is a must.
• Experience working with non-relational databases (such as ElasticSearch, MongoDB, or AWS DynamoDB) is a plus.
• Experience with Big-Data technologies such as Apache Spark is a plus.
• Experience with one or more programming languages is required (preferably Python).
• Ability to perform data mapping, blending and ETL design using available programming languages.
• Developing and executing tests to ensure the accuracy and completeness of solutions delivered.
• Develop and maintain technical documentation related to application requirements and data analysis.
• Ability to develop Data Visualizations using Python and/or Tableau is a plus.
• Other duties as required, such as participating in Scrum process by acting as Scrum Master for team as needed.
• Previous work experience in an investments operational role would be a strong asset
• Undergraduate degree or equivalent credentials in Business Intelligence, Data Analytics, Data Visualization or relevant discipline with a strong appetite for quantitative and statistical data
• Proven process development skills and solid understanding of project life cycle and the capability to apply best practices knowledge to unique and dynamic situations.
• Proven ability to liaise with business subject matters in gathering of business requirements.
• Exceptional (written and verbal) communication skills and interpersonal skills
• Strong analytical skills and problem-solving abilities
• Able to deliver in a constantly changing and fast paced organization

Additional Information

Visit our LinkedIn Career Page or Follow us on LinkedIn. #LI-EK1 #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.