We’re one of Canada’s largest pension investors, with CAD$299.7 billion of net assets as of March 31, 2025.
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.
Reporting to the Senior Manager, Analytics Enablement and Total Funds Solutions Delivery, the Senior Developer will be a key member of the solutions delivery team by contributing their expertise and support in various development phases for the solutions of diverse clients.
As a Senior Developer, Analytics Enablement and Total Fund Solutions Delivery, you will:
Design and develop highly scalable and reliable data pipelines and platforms to contribute to the delivery strategy
Design and implement database schemas, tables, views, stored procedures, and functions using Snowflake and Databricks
Manage and 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
Bachelor's degree in Computer Science, Software Engineering, or equivalent
Five (5) years of relevant experience, with a minimum of three (3) years of experience in data engineering
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
Experience with web applications and services using C#, ASP.NET Core, Entity Framework Core, Angular to contribute to the delivery strategy (asset)
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)
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 with a mix of in-office and remote days
*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-GR1
The Public Sector Pension Investment Board (PSP Investments) is one of Canada's largest pension investors with $299.7 billion of net assets as of March 31, 2025. It manages a diversified global portfolio composed of investments in public financial markets, private equity, real estate, infrastructure, natural resources and private debt. Established in 1999, PSP Investments manages net contributions to the pension funds 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. For more information, visit investpsp.com or follow us on LinkedIn.
Social media community terms of use
At PSP Investments, we welcome respectful and constructive exchanges on our social media accounts.
While we encourage your comments on our posts, we reserve the right to delete, hide or block comments that are in violation of our Social Media Community Terms of Use: https://www.investpsp.com/en/footer/terms-use/
Violations of our Terms of Use may also result in the user being permanently blocked from commenting on our accounts.
