ABOUT US We’re one of Canada’s largest pension investment managers, with CAD$264.9 billion of net assets as of March 31, 2024. 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, 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 Senior Manager, Total Fund 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. ABOUT YOUR ROLE As a Senior Developer, Total Fund Solutions Delivery, you will: Design and 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 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 Provide guidance for their team in the development of the products according to the development patterns and solutions design while contributing to team effectiveness WHAT YOU’LL NEED Bachelor’s degree in computer science, Software Engineering, or equivalent Seven (7) years of relevant experience, with a minimum of four (4) 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, we aim to provide an inclusive workplace where we leverage diversity and 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-AM1 We’re one of Canada’s largest pension investment managers, with CAD$264.9 billion of net assets. We invest funds for the pension plans of the federal public service, the Canadian Forces, the Royal Canadian Mounted Police and the Reserve Force. We are committed to fostering an environment where experiences and learning opportunities provide you with the platform to grow. If you are having difficulty applying, you can reach us at careers@investpsp.ca
