Solution Designer, Corporate Functions Solutions Delivery

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

Benefits offered by this job

Hybrid work model four in-office days

Comprehensive group insurance plans

Competitive pension plans

Vacation days from day one

Job summary

PSP Investments is seeking a Solution Designer for Corporate Functions Solutions Delivery. You will translate business needs into cloud solutions on Azure, craft architecture diagrams, and collaborate with cross-functional teams to deliver scalable, compliant outcomes across Finance, Procurement, Legal, and HR operations.

The role emphasizes security-by-design, DevOps automation, and FinOps, with hands-on development of AI-enabled cloud components using Azure Foundry and Snowflake.

Qualifications

• Bachelor’s degree in computer science, IT, or related field.
• Minimum five to seven years of experience in solution design or cloud architecture.
• Proven experience delivering Azure cloud-based enterprise solutions.
• Knowledge of SDLC, FinOps, and security patterns.

Responsibilities

• Translate functional requirements into end-to-end cloud solutions using Azure & Snowflake services.
• Develop solution documents, architecture diagrams, and technical specifications.
• Collaborate with Product Owners, Solution Architects, and development teams to identify scalable, compliant solutions.
• Participate in the implementation of cloud solutions, develop core components, aligned with 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.
• Design integration and data foundations—APIs, event-driven patterns, Snowflake—with scalability.
• Demonstrate leadership to support team members and engage stakeholders.

Skills

Azure cloud

Cloud architecture

Solution design

Enterprise integration

SDLC practices

FinOps

Security by design

Agile delivery

Communication

Bilingual English/French

Education

Bachelor’s degree in computer science or IT

Tools

Azure DevOps

Snowflake

Bicep/Terraform

Power Platform

Copilot Studio

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.

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