Solution Designer, Corporate Functions Solutions Delivery

Résumé du poste

The Solution Designer will translate functional requirements into end-to-end cloud solutions using Microsoft Azure and Snowflake services. They will also design and deliver AI-enabled solutions while collaborating with cross-functional teams to ensure scalability, security, and operational efficiency.

Détails du poste

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

Ce que vous ferez

The Solution Designer will translate functional requirements into end-to-end cloud solutions using Microsoft Azure and Snowflake services. They will also design and deliver AI-enabled solutions while collaborating with cross-functional teams to ensure scalability, security, and operational efficiency.

Exigences

Candidates must hold a bachelor's degree in computer science or a related field and possess at least five to seven years of experience in solution design or cloud architecture. Proficiency in Azure cloud services, DevOps practices, and generative AI frameworks is essential for this role.

Avantages

• Comprehensive group insurance plans • Competitive pension plans • Virtual healthcare services • Wellness programs • Gender-inclusive paid family leave • Family-building support • Vacation days • Summer Friday afternoons off

Compétences indiquées

• Microsoft Azure · Souhaitée
• CI/CD · Souhaitée

Autres compétences pertinentes

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• Solution design
• Cloud architecture
• Microsoft Azure
• Snowflake
• Generative AI
• Azure AI Foundry
• Copilot Studio
• DevOps
• CI/CD
• Infrastructure as Code
• FinOps
• Agile delivery
• Microsoft Fabric
• Power Platform
• Data integration
• Security-by-design
• Operational Efficiency
• Responsible AI
• Solution Design
• Generative Artificial Intelligence
• Azure Data Factory
• Intelligent Automation
• Microsoft Copilot Studio
• Virtual Health
• Enterprise Integration
• Snowflake (Data Warehouse)
• Microsoft Power Platform
• Bilingual (French/English)
• Cloud Financial Management (FinOps)
• Azure DevOps
• Application Programming Interface (API)
• Agile Methodology
• Artificial Intelligence
• Automation
• Corporate Finance
• Investments
• Textiles
• Cloud Computing Architecture
• Communication
• Procurement
• Regulatory Compliance
• Computer Science
• Information Technology
• Continuous Improvement Process
• English Language
• Event-Driven Programming
• French Language
• Functional Requirement
• Leadership
• Scalability

Domaines d’emploi

• Technology
• Software
• Data & Analytics
• Finance & Accounting
• Consulting
• Solution Designer
• Cloud Architect
• Systems Analysts
• Computer Systems Engineers/Architects
• Computer Occupations, All Other