Senior Bi Developer Jobs in Quebec (NOW HIRING)

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 thepension plans of thefederalpublicservice, the Canadian Forces, theRoyal Canadian Mounted Police andthe ReserveForce. Headquartered in Ottawa, PSP Investments has its principal business office in Montreal 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.

The Risk Analytics team is responsible for producing advanced analytics and providing quantitative insight to support valuation, pricing, and risk assessment activities across Public Markets portfolios.

Risk Analytics plays a critical role in ensuring fair market valuation of financial instruments, developing and maintaining analytical tools and methodologies, and supporting disciplined monitoring of portfolio risk exposures. The team partners closely with Asset class stakeholders, Risk, and Technology teams to deliver analytics that support decision making, regulatory compliance, model governance, and the integrity of valuation and risk outputs across the Total Fund.

As a Senior Analyst, Risk Analytics, you will be a hands-on contributor within this team, combining strong operational execution with a growing financial engineering mindset. Your work will span the full analytics lifecycle: helping develop and internalize sound risk analytics, running and enhancing quantitative pipelines, and ensuring efficient and optimized quantitative processes that produce reliable outputs across asset classes.

You will work closely with senior team members, Risk stakeholders, and Technology partners to maintain data quality throughout the analytics chain, support the improvement of risk methodologies and deliver reporting outputs that support Total Fund decision-making. While daily production rigor is central to the role, you will also be expected to contribute a financial engineering perspective - translating analytical requirements into implementable solutions, assessing the inputs and assumptions that drive risk measures, and supporting the evolution of the team's quantitative frameworks. The role demands operational discipline, strong technical execution in SQL and Python, and the ability to work reliably within evolving data environments.

Key responsibilities:

• Run and monitor daily risk analytics production processes - ensuring risk exposures, sensitivities, stress metrics, and decompositions are produced accurately and delivered on time

• Contribute to the development and internalization of risk analytics, help translate analytical requirements into clear specifications, validation criteria, and implementable solutions that Risk Analytics delivery teams and technology partners can act on

• Support the review and refinement of risk methodologies and measures, including clarity on key inputs, assumptions, and analytical dependencies - ensuring outputs are consistent and explainable

• Investigate and resolve production issues: diagnose data breaks, pipeline failures, and anomalous outputs; apply fixes and escalate when needed

• Validate daily data inputs and outputs across the analytics chain; flag and remediate data quality issues before they reach downstream consumers

• Maintain and update risk reports and dashboards (Power BI or equivalent) to reflect current portfolio positions and methodological parameters

• Execute data quality controls (accuracy, completeness, consistency, timeliness) as part of the daily production cycle

• Implement incremental enhancements to existing analytics pipelines in SQL and Python - improving reliability, performance, or coverage in alignment with the team's target architecture.

• Document production processes, methodological decisions, known issues, and remediation steps to support operational continuity and audit readiness

• Participate in requirements discussions with Risk, Performance, CIO stakeholders and technology partners to ensure production outputs meet their needs

Mandatory requirements:

• Master's degree in Financial Engineering, Quantitative Finance, Finance, or a closely related field

• At least 2-5 years of experience in capital markets, asset management, or a closely related analytical role

• Solid understanding of financial markets, risk measures (exposures, sensitivities, stress testing, decompositions), and the data inputs that drive them

• Experience operating in a daily production environment - comfortable with production monitoring, troubleshooting, and time-sensitive delivery

• Demonstrated ability to translate analytical or financial engineering concepts into practical, testable solutions

• Strong attention to detail and a rigorous approach to data validation, documentation, and issue resolution

Technical skills:

• Advanced SQL, with experience writing and maintaining production queries in Snowflake or similar analytical databases

• Programming experience in Python for data validation, pipeline maintenance, and analytical workflows

• Experience with relational databases and working with large-scale datasets in a production context

• Familiarity with BI tools (Power BI) for building and maintaining dashboards and reports

• Experience with data quality monitoring - defining checks, tracking issues, and supporting remediation workflows considered an asset

• Exposure to AI-assisted development tools and platforms (e.g., Databricks) considered an asset

• Professional designations (FRM, PRM, CFA, CQF) considered an asset

• Bilingualism in English and French *Frequent interactions in English with PSP employees based in our Hong Kong, London and New York offices, and interactions in French with employees in our local Montreal and Ottawa offices

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