Sql analyst Jobs in Vaughan, ON

Attendance Hybrid Job number 27370 Category Intermediate Professional Status: Permanent Type of Contract Permanent Schedule: Full-Time Full Time / Part Time? Full-Time Posting date 09-Jul-2025 Location: Richmond Hill, Ontario City Richmond Hill Province/State Ontario Area(s) of interest: Risk management

Where talent thrives and careers soar. Live your ambitions.

Ready to take your banking career to the next level? Join us and experience a workplace where your skills, drive, and innovation can truly shine.

A career as a Senior Analyst, in the Risk Analytics team at National Bank means playing a pivotal role in reporting and model development for credit economic capital, concentration risk, and credit risk analytics . This job offers you the opportunity to make a real impact by producing and analyzing risk capital metrics, supporting regulatory compliance, and contributing to strategic decision-making. If you're passionate about data, modelling, risk, and innovation, this role is your chance to grow your expertise and influence across the organization.

Your role

• Economic Capital Management: Accurately produce and report Economic Capital (EC) and enhance its underlying models and methodologies.
• Concentration Risk Monitoring: Quantify and monitor concentration risk within the bank's credit portfolio, including developing and enhancing related models.
• Credit Model Support: Provide support for model development, implementation, and back-testing in other credit-related areas like IFRS 9 and stress testing.
• Risk Analysis & Reporting: Conduct in-depth analysis of risk results and prepare insightful reports for senior management and regulators.
• Documentation & Compliance: Develop and maintain comprehensive documentation for models and risk processes to meet internal and regulatory standards.
• Process improvement: Identify, recommend, and implement improvements across models, risk calculation, reporting, analysis, and control.
• Stakeholder Collaboration: Coordinate with internal teams and collaborate with various stakeholders, including Risk, Capital, Business, IT, Model Validation, and Internal Audit, while also addressing ad-hoc requests from management and regulators.

Your team

The Risk Analytics team is made up of over 20 professionals who work collaboratively to stay ahead of regulatory expectations and industry best practices. You’ll report to the Senior Manager, and be part of a dynamic environment that values innovation, continuous improvement, and strategic thinking.

National Bank values continuous development and internal mobility. Our personalized training programs, based on hands-on learning, help you master your role and explore new areas of expertise. Tools like the Data Academy, language training, Harvard Learning Center, and access to coaching and mentoring are always available to support your growth.

What you need to succeed

• A master’s or Ph.D degree in a relevant field such as Financial Engineering, Finance, Economics, Statistics, Mathematics, or Computer Science.
• At least 2–3 years of experience in risk management, ideally with exposure to model development, implementation, validation or data analytics in economic capital, stress testing, IFRS-9 or A-IRB.
• Hands-on experience with SAS, SQL, and Excel (including VBA), and familiarity with Moody’s RiskFrontier is an asset.
• Strong analytical and critical thinking skills, with the ability to interpret complex data and communicate insights clearly.
• Experience in risk capital production, and regulatory reporting (Pillar I and II).
• Working knowledge of regulatory requirements such as OSFI CAR, E19, E23 guidelines.

Soft skills to highlight in your application

• Autonomy and initiative
• Strong communication and collaboration skills
• Ability to manage multiple priorities under pressure
• Strategic thinking and problem-solving
• Attention to detail and commitment to quality

Be Part of a Bold New Chapter
As we transition from Canadian Western Bank (CWB) to National Bank of Canada (NBC), we’re looking for talented individuals to join us on this exciting journey. While you’ll begin your role at a CWB location, you’ll be part of a forward-thinking team preparing for a seamless move to NBC.

This is more than a job—it’s an opportunity to grow, connect, and help shape the future of banking in Canada.
Join us. Grow with us. Change with us.

Languages: English

Skills

Artificial Intelligence Capital Markets Data Analysis Diversity & Inclusion Modeling Product Development Teamwork Cybersecurity Empathy Initiative Learning Agility Resiliency Stress Testing Your benefits In addition to competitive compensation, upon hiring you’ll be eligible for a wide range of flexible benefits to help promote your wellbeing and that of your family. * Health and wellness program, including many options * Flexible group insurance * Generous pension plan * Employee Share Ownership Plan * Employee and Family Assistance Program * Preferential banking services * Opportunities to get involved in community initiatives * Telemedicine service * Virtual sleep clinic These are a few of the benefits available to you. We have an offer that keeps up with trends as well as your needs and those of your family. Our dynamic work environments and cutting-edge collaboration tools foster a positive employee experience. We actively listen to employees’ ideas. Whether through our surveys or programs, regular feedback and ongoing communication is encouraged. We're putting people first We're a bank on a human scale that stands out for its courage, entrepreneurial culture, and passion for people. Our mission is to have a positive impact on peoples' lives. Our core values of partnership, agility, and empowerment inspire us, and inclusivity is central to our commitments. We offer a barrier-free workplace that is accessible to all employees. We want our recruitment process to be fully accessible. If you require accommodation, feel free to let us know during your first conversations with us. We welcome all candidates! What can you bring to our team? Come live your ambitions with us!