Solution Designer, Corporate Functions Solutions Delivery

Location: Montreal

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

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 the pension plans of thefederalpublicservice, the Canadian Forces, the Royal Canadian Mounted Police andthe 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
Reporting to the Director Corporate Functions Solutions Delivery, the selected candidate will contribute to the team’s mandate. As a member of the Corporate Functions Solution team, you will support the corporate teams in delivering technological solutions, improving operational efficiency and enhancing employee productivity through automation, generative AI, and agentic solutions.

About Your Role
As a  Solution Designer, Corporate Functions Solutions Delivery , you’ll:

Translate functional requirements into end-to-end cloud solutions leveraging Microsoft Azure & Snowflake services

Develop solution documents, architecture diagrams, and technical specifications aligned with enterprise standards

Collaborate with Product Owners, Solution Architects, and development teams to identify scalable, right- sized, and compliant solutions addressing the business needs

Actively participate in the implementation of cloud solutions, develop core components, and ensure they are aligned with the solution design patterns

Embed security-by-design practices, contribute to Dev Ops automation (Azure Dev Ops, CI/CD, IaC with Bicep/Terraform), and cloud cost optimization (Fin Ops)

Design and deliver AI-enabled solutions on Azure AI Foundry and Azure, including Copilot Studio agents, with responsible AI guardrails in place

Design the integration and data foundations— APIs, event-driven patterns, Snowflake — with attention to scalability and continuous improvement

Demonstrate leadership abilities to support team members and engage with multiple stakeholders

What You’ll Need

Bachelor’s degree in computer science, Information Technology, or related field

Minimum five (5) to seven (7) years of experience in solution design, cloud architecture, or enterprise integration roles

Proven experience designing and delivering Azure cloud-based enterprise solutions

Strong understanding of SDLC practices, including responsible-AI practices, cloud cost management (Fin Ops) and security patterns

Excellent communication skills with the ability to bridge technical and non-technical audiences.

Experience with corporate functions such as Corporate Finance, Procurement, Legal, Compliance, HR and Communications, an asset

Familiarity with Azure Dev Ops and Agile delivery methods

Familiarity with delivering generative-AI or intelligent-automation solutions in an enterprise setting (Azure, Azure AI Foundry, Copilot Studio, Snowflake or comparable agent frameworks)

Strong understanding of agent development patterns using both low-code and pro-code approaches leveraging Power Platform stack

Knowledge of Microsoft Fabric — including Power BI semantic models and Fabric Data Factory (Dataflows Gen2 and data pipelines) for ingestion — with attention to scalability and continuous improvement

Bilingualism:
English and French (frequent interactions in English with PSP employees based in our offices in Hong Kong, London and New York, and…