Analyst, Market Risk

Laurentian Bank; Montreal (administrative region); On-site; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Hybrid work model

Stock purchase plan

Floating days and paid birthday leave

Health & wellness programs (EFAP)

Group insurance and pension

Job summary

Laurentian Bank is seeking an analyst in Montreal to support the Treasury Risk Management and Capital Markets team. The role focuses on designing and optimizing data management solutions, building dashboards, and automating processes using SQL, VBA, and Power BI.

The incumbent will liaise between business users and IT across multiple projects, ensuring data quality and governance. Responsibilities include market risk analyses, data validation, and reporting to aid strategic decisions.

Qualifications

• Bachelor’s degree in a related field.
• Proficiency in SQL and VBA.
• Experience with relational databases and data modeling.
• Power BI experience is an asset.

Responsibilities

• Perform market risk analyses and valuations for Treasury and Capital Markets products.
• Gather and verify market data from multiple sources for accuracy.
• Develop, optimize, and maintain data management and analytics solutions using SQL and VBA.
• Design dashboards and reports to support decision-making.
• Ensure data governance, integrity, and quality across risk management activities.
• Collaborate with business partners to translate requirements into technical solutions.

Skills

SQL

Excel

VBA

Relational databases

Power BI

English & French

Education

Bachelor’s degree in Computer Science/Information Systems/Finance

Job description

Founded in Montreal in 1846, Laurentian Bank is committed to serving its customers and fostering deep relationships with specialized groups. Laurentian Bank runs operations across Canada – primarily in Québec and Ontario – as well as in the United States and competes where it sees market opportunity and has an edge, while harnessing the power of partnerships and collaboration.

This role sits within Laurentian Bank.

The analyst will participate in the development, maintenance, and enhancement of data management solutions supporting the Treasury Risk Management and Capital Markets team. The analyst, Market Risk, assists in evaluating financial products and preparing and developing reports.

He will act as an SQL Developer responsible for designing and optimizing queries, reports, and automation processes, while also playing a key liaison role between business users and Information Technology teams across various projects.

The candidate will be responsible for understanding business needs, translating them into functional and technical requirements, monitoring requests and project deliverables, and contributing to the implementation of solutions that support organizational objectives.

Responsibilities

• Perform, on a daily basis, rigorous market risks analyses and valuations for Treasury and Capital Markets products.
• Gather, compile and verify the accuracy of the market data and data taken from various source systems. Analyze the information gathered to ensure the quality of the management information and clarify variances.
• Develop, optimize, and maintain data management and analytics solutions using SQL, VBA, and other analytical tools.
• Ensure the integrity, quality, and governance of data used in risk management activities.
• Perform data validation, analysis, and quality monitoring, while contributing to the identification and resolution of data issues.
• Design and produce dashboards, reports, and management information tools to support business decision-making.
• Automate and enhance operational processes to improve efficiency, accuracy, and overall performance.
• Analyze and monitor market risk, counterparty risk, and Treasury and Capital Markets activities through reporting and analytical tools.
• Collaborate with business partners to understand requirements, document needs, and translate them into functional solutions.
• Participate in strategic projects and continuous improvement initiatives that support risk management and organizational performance.
• Contribute to the enhancement of risk management frameworks, processes, controls, and tools.
• Build and maintain strong collaborative relationships with internal stakeholders and cross-functional teams.

Qualifications

• Bachelor’s degree in computer science, Information Systems, Software Engineering, Mathematics, Statistics, Finance, or a related field.
• Up to two years of relevant experience.
• Good knowledge of SQL programming and database querying.
• Proficiency in advanced Microsoft Excel and VBA development.
• Understanding of relational database concepts and structures.
• Experience with Power BI is considered an asset.
• Demonstrates curiosity, attention to detail, and the ability to work independently.
• Strong communication skills, with the ability to explain technical concepts to non-technical audiences.
• Excellent teamwork and collaboration skills.
• Proficiency in English and French, spoken and written*

*Professional working proficiency in French and English languages required as position involves frequent written and oral communication on complex matterswith internal and external parties in both languages.

What Laurentian Bank has to offer you

The total compensation offered by Laurentian Bank encompasses a comprehensive range of benefits, highlighting our commitment to the well-being and success of our employees. Here are some of the key points of our offering:

• Total compensation: Earn a comprehensive compensation package that includes annual reviews and performance-based bonuses.
• Work model: We prioritize a hybrid work model based on business needs.
• Stock purchase plan: Become not just an employee, but a Laurentian Bank shareholder. Employer matching takes your investment even further.
• Time off: In addition to paid vacation, we provide floating days and leave options to accommodate the diverse needs of our employees. Plus, as an extra perk, you also get a paid day off to celebrate your birthday.
• Health and wellness: Take care of your health and well-being with access to healthcare professionals, our Employee and Family Assistance Program (EFAP), and a Stress Management and Well-Being Program.
• Group insurance and pension: We offer a competitive insurance program based on your family’s needs and a defined contribution pension plan to help prepare for your future.
• Financial benefits: As a Laurentian Bank employee, you’re also the best ambassador for our products and services. Take advantage of employee-only offers on a wide range of products. Enjoy exclusive deals and preferred rates on products and services including insurance, hotels, train tickets, spas and many more.

We are committed to creating a fulfilling professional environment where your skills are valued, and your well-being is a priority. Join us for a rewarding career at Laurentian Bank.

Inclusion and Accessibility

At Laurentian Bank, we believe everyone belongs. We are committed to fostering an inclusive work environment that reflects the diversity of our customers and our communities and where everyone feels like they belong and can thrive. To this end, we encourage applications from individuals from equity-deserving groups, including Indigenous persons, racialized and persons with disabilities, marginalized genders and the 2SLGBTQIA+ community.

We strive to offer a flexible and accessible work experience that is inclusive of everyone. If at any time you need an accommodation, please let us know.

PIPEDA

We may collect, use or disclose your personal information for the purpose of establishing an employment relationship with you.

We also use artificial intelligence (AI) tools during parts of our recruitment process to support fair and efficient hiring decisions.