Solution Designer, Corporate Functions Solutions Delivery

investpsp; Montreal (administrative region); Hybrid; CAD 110,000 - 160,000; Full time

Benefits offered by this job

Hybrid work model

Vacation days from day one

Comprehensive group insurance

Competitive pension plans

Virtual healthcare access

Paid family leave

Career development

Job summary

PSP Investments in Montréal is seeking a Solution Designer to join the Corporate Functions Solutions Delivery team. You will translate functional requirements into end-to-end cloud solutions on Azure and Snowflake, document architecture, and collaborate with Product Owners, Solution Architects and development teams to deliver scalable, compliant solutions.

You will embed security-by-design, contribute to DevOps automation (Azure DevOps, CI/CD, IaC with Bicep/Terraform), and design AI-enabled

Qualifications

• Bachelor's degree in computer science or related field.
• 5–7 years in solution design, cloud architecture or enterprise integration.
• Proven Azure cloud-based enterprise solution experience.
• Knowledge of SDLC, responsible-AI, FinOps, and security patterns.
• Strong communication bridging technical and non-technical audiences.

Responsibilities

• Translate requirements into end-to-end cloud solutions on Azure & Snowflake.
• Develop architecture diagrams, technical specs, and design documents.
• Collaborate with Product Owners, Solution Architects, and development teams.
• Implement cloud solutions and ensure alignment with design patterns.
• Embed security-by-design and contribute to DevOps automation (CI/CD, IaC).
• Design AI-enabled solutions on Azure AI Foundry and Copilot Studio.
• Design APIs and data foundations with scalable patterns.
• Demonstrate leadership and engage with multiple stakeholders.

Skills

Azure cloud

Snowflake

DevOps

Communication

Agile delivery

Power Platform

Security-by-design

AI/Generative AI

API integration

Education

Bachelor's degree in computer science or IT

Tools

Azure DevOps

Bicep/Terraform

Snowflake

Copilot Studio

Power BI

Fabric

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 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

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 DevOps automation (Azure DevOps, CI/CD, IaC with Bicep/Terraform), and cloud cost optimization (FinOps)
• 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 (FinOps) 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 DevOps 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 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