Solution Designer, Total Fund Solutions

PSP Investments | Investissements PSP; Montreal (administrative region); Hybrid; CAD 110,000 - 150,000; Full time

Benefits offered by this job

Career development

Group insurance plans

Competitive pension plans

Virtual healthcare services

Family leave policy

Family-building support

Vacation days from day one

Hybrid work model

Opportunity to work from another site

Job summary

PSP Investments, headquartered in Ottawa with a principal office in Montréal, seeks a Solution Designer, Total Fund Solutions. You will design web apps, data platforms (Snowflake/Databricks), integrations, and AI-enabled solutions aligning with PSP architecture.

You’ll guide delivery teams in an Agile setting, evaluate security and performance, and drive decisions across analyses, development, and operations while exploring new technologies and maintaining governance standards.

Qualifications

• Bachelor’s degree in CS/SE/IS.
• 5–7 years designing enterprise technology solutions.
• Hands-on experience with web apps, APIs and cloud data platforms.
• Strong knowledge of SDLC, Agile, architecture principles.
• Ability to translate requirements into scalable, secure solutions.
• Experience with AI-enabled technologies and related tooling.
• English and French fluency for cross-border collaboration.

Responsibilities

• Design end-to-end technology solutions including web apps, data solutions, APIs and AI-enabled capabilities.
• Evaluate functional and non-functional requirements: security, resiliency, performance, scalability.
• Plan, document and maintain solution designs with dependencies and risks.
• Provide guidance to delivery teams and facilitate technical decision-making.
• Support implementation and resolve issues aligning with design.
• Research emerging technologies and make evidence-based recommendations.
• Ensure designs comply with SDLC, architecture standards and data governance.

Skills

Solution architecture

Web applications

APIs

Cloud-native solutions

Snowflake

Databricks

AI-enabled technologies

Agile delivery

SDLC

Bilingual English/French

Education

Bachelor’s degree in Computer Science

Bachelor’s degree in Software Engineering

Bachelor’s degree in Information Systems

Tools

Snowflake

Databricks

Job description

About Us

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

We invest funds for thepension plans of thefederalpublicservice, the Canadian Forces, the Royal Canadian Mounted Police and the ReserveForce. 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

Reporting to the Director, Total Fund Solutions, the Solution Designer acts as a technical lead and plays an important role by providing technical guidance within Total Fund Solutions. The Solution Designer is accountable for the quality, sustainability, maintainability, performance, security, supportability, and scalability of solution designs, with a particular focus on Web application solutions, Snowflake and Databricks data solutions, integrations, APIs, and AI-enabled capabilities.

In this capacity, the Solution Designer guides development teams, facilitates solution design decisions, and ensures that proposed and delivered solutions meet business, functional, non-functional, architecture, security, data, and operational requirements. The role works closely with business analysts, product owners, developers, architects, data teams, security, operations, and internal partners in an Agile delivery context.

About Your Role

As a Solution Designer, Total Fund Solutions, you’ll:

• Design end-to-end technology solutions, including Web applications, Snowflake and Databricks data solutions, integrations, APIs, and AI-enabled or agentic AI capabilities, ensuring alignment with business needs and PSP architecture principles
• Evaluate functional and non-functional requirements, including security, resiliency, performance, scalability, maintainability, supportability, data quality, integration impacts, and operational considerations
• Plan, architect, document, and maintain solution designs, including dependencies, integration points, technical decisions, risks, assumptions, implementation considerations, and alignment with guiding principles
• Provide technical guidance to delivery teams by facilitating design sessions, technical decision-making, and alignment between business analysts, developers, architects, data teams, security, operations and other stakeholders
• Actively support implementation and problem resolution, ensuring that delivered solutions remain aligned with the approved design and that issues are analyzed, resolved, and followed through effectively
• Research, assess, and experiment with emerging technologies, tools, design patterns, and market capabilities, including Proofs of Concept, and make recommendations based on benefits, risks, costs, and fit with PSP’s technology landscape
• Ensure solution designs comply with PSP’s SDLC, architecture standards, security requirements, data governance practices, operational support expectations, solution review processes, and applicable controls

What You’ll Need

• Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or an equivalent combination of education and experience
• Five to seven (5–7) years of experience designing, developing, and delivering enterprise technology solutions, including software development, solution architecture, and system integration
• Hands-on experience designing and delivering web applications, APIs, integrations, cloud-native solutions, and data platforms, including Snowflake or comparable cloud data technologies
• Strong understanding of SDLC, Agile delivery methodologies, architecture principles, design patterns, and software engineering best practices across the full software development lifecycle
• Ability to translate functional and non-functional requirements into scalable, secure, resilient, maintainable, and supportable technology solutions
• Experience leveraging AI-enabled technologies, including generative AI and agentic AI tools, to enhance software development, solution design, automation, productivity, and quality outcomes
• Strong analytical, problem-solving, communication, and stakeholder management skills, with the ability to influence decision-making and effectively communicate complex technical concepts to both technical and business audiences
• Knowledge of investment management, portfolio construction, performance and risk measurement or related financial services domains, with an understanding of technology delivery and application development practices in an Agile environment
• Bilingualism: English and French (frequent interactions in English with PSP employees based in our offices in Hong Kong, London and New York, and interactions in French with employees in our local offices in Montreal 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 that includes four in-office days, Monday through Thursday
• The opportunity to work temporarily from another location in accordance with the applicable policy
• 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