InvestPSP

Advisor, Private Markets Solutions Delivery (Temporary - 15 Months)

Montreal Full time

ABOUT US

We’re one of Canada’s largest pension investors, with CAD$299.7 billion of net assets as of March 31, 2025.


We invest funds for the pension plans of the federal public service, the Canadian Forces, the Royal Canadian Mounted Police and the Reserve Force. Headquartered in Ottawa, PSP Investments has its principal business office in Montréal and offices in New York, London and Hong Kong. 

Capturing and leading complex global investments requires us to work as one to seize valuable opportunities, in close collaboration with some of the world’s top companies. At PSP Investments, you’ll join a team of motivated and engaged professionals, dedicated to propelling our organization further than ever before.

ABOUT THE TEAM

The Advisor, Private Markets Solutions Delivery plays a key role in the Private Markets agile team to maximize the value delivered by the Technology, Data and Operations’ (TDO) group. The Private Markets Advisor collaborates with various clients (business partners) delivering on Private Markets Asset Classes and Operations areas such as Natural Resources, Investment Finance, Real Estate and Private Risk.

ABOUT YOUR ROLE

As an Advisor, Private Markets Solutions Delivery, you’ll:

  • Provide Guidance and Technical Support to team members on analytical tools and best practices

  • Analyze and influence business partner needs, lead requirements analysis, validation, and verification

  • Design and deliver reliable, scalable visualization and reporting solutions using tools such as Snowflake and Power BI

  • Collaborate with the delivery team to develop and maintain optimized data models that support performance analysis and insight generation

  • Supervise daily operational tasks (support and maintenance, incident/problem resolution, operational requests) ensuring alignment with business needs and the company’s vision

WHAT YOU’LL NEED

  • Bachelor’s degree in computer science, Software Engineering, or a related field

  • Minimum of five (5) years of experience in designing and developing analytical solutions or dashboards

  • Proven experience in implementing end-to-end analytical solutions

  • Proficiency in Power BI (DAX, data modeling, report optimization)

  • Experience with Snowflake, and data analysis

  • Knowledge of the investment domain, particularly private markets, is an asset

  • Knowledge of CI/CD/CT pipelines using Azure DevOps

  • Experience with identity and access services (Azure AD) and version control tools

  • Excellent communications skills, both written and spoken (bilingualism French and English)

  • Bilingual in English and French (Frequent interactions in English with PSP employees based in our Hong Kong, London, and New York offices, and interactions in French with employees in our local offices in Montréal and Ottawa)

We offer a tailored employee experience and competitive total rewards and benefits package* designed to attract and retain global diverse talent, reward performance, and reinforce business strategies and priorities. Beyond salary and incentive pay eligibility, you have access to:

  • Investment in career development

  • Comprehensive group insurance plans

  • Competitive pension plans

  • Unlimited access to virtual healthcare services and wellness programs

  • Gender-inclusive paid family leave policy: up to 26 weeks for primary caregivers, 5 weeks for secondary caregivers

  • A personalized family-building support, from pre-pregnancy to menopause, with available financial assistance

  • Vacation days available on day one with additional days on milestone service anniversaries, and summer Friday afternoons off

  • A hybrid work model with a mix of in-office and remote days

*Benefits package may vary based on your employee type.


At PSP Investments, we aim to provide a workplace where everyone feels valued, safe, respected and empowered to grow. As part of this leadership commitment, we strongly encourage applications from all qualified applicants and strive to offer an inclusive and accessible candidate experience. If you require any accommodation for any part of the recruitment process, please let us know.

Visit us on www.investpsp.com/en/

Follow us on LinkedIn

#LI-MJ1