Developer, GenAI and Digital Workplace

Public Sector Pension Investment Board • Montreal, QC

2d • Hybrid

About The Position

As a Developer within the Gen AI & Digital Workplace team, you will join a dynamic and innovative group that leverages its intellectual leadership to create an engaging, efficient, and intuitive work environment. The Developer plays a key role within the Gen AI & Digital Workplace team to maximize the value delivered by the Technology, Data, and Operations (TDO) group to PSP’s various business lines. Our mission is to enable PSP employees to enhance their digital dexterity, deepen their knowledge of GenAI, and facilitate the secure adoption of AI and collaborative technologies in a constantly evolving technological landscape, as well as to ensure access to knowledge resources and collaboration channels anytime, anywhere, with contextual relevance. As a member of the GenAI & Digital Workplace team, you will have the opportunity to contribute to our vision of creating a human-centered and efficient digital experience. This experience helps our business partners invest with foresight, operate with excellence, and foster deeper technological integration. We are a curious team that stays continuously up to date on advanced AI and digital technologies, proactively identifying opportunities for efficiency gains, synergies, and operational benefits, and contributing to the skills development strategy and the evolution of PSP’s AI and collaboration ecosystem to accelerate toward coordinated excellence.

Requirements

• Bachelor's degree in Computer Science, Software Engineering, or equivalent
• A minimum of one (1) to two (2) years of relevant experience
• Familiarity with Snowflake and Databricks features and concepts such as warehouses, databases, roles, security, data sharing, performance tuning, and data engineering
• Experience in using Azure DevOps, Git, and CI/CD tools
• Experience in the financial industry and in monitoring industry development techniques and tools
• Strong analytical, problem-solving, and communication skills and the ability to challenge the status quo
• 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)

Nice To Haves

• Experience with web applications and services using C#, ASP.NET Core, Entity Framework Core, Angular to contribute to the delivery strategy (asset)

Responsibilities

• Develop highly scalable and reliable data pipelines and platforms to contribute to the delivery strategy
• Implement database schemas, tables, views, stored procedures, and functions using Snowflake and Databricks
• Participate in the evaluation and analysis of requests, such as change and/or evolution requests
• Perform unit testing, integration testing, and code reviews to ensure maintainability and sustainability of products
• Debug and troubleshoot issues and bugs to provide product evolution recommendations
• Document and communicate your work and progress
• Keep abreast of the latest technologies and trends in order to provide guidance to the team and improve existing products and efficiency

Benefits

• 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 with a mix of in-office and remote days

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level