Senior Software Developer - SQL/Python

RBC; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading financial institution in Toronto is seeking an experienced Senior Software Developer to join its Wealth Management Global IT Data Services team. You'll design and develop large-scale projects using database technologies like SQL Server and Snowflake, collaborating with teams to ensure high-quality applications. Candidates should have over 5 years of experience in database technologies, strong SQL skills, and backend programming experience. The role offers competitive compensation and flexible benefits.

Benefits

Competitive compensation

Flexible benefits

Coaching and development opportunities

Qualifications

• 5+ years of experience in database and SQL Server technologies, including Python and Snowflake.
• Solid experience in Microsoft SQL Server, including its various versions and editions.
• Solid SQL experience - including querying, indexing, and performance optimization.

Responsibilities

• Design and develop applications ensuring timely completion.
• Develop high-quality, scalable, and maintainable code.
• Identify and resolve technical issues during solution development.

Skills

Active Learning

Agile Methodology

Detail-Oriented

Programming Languages

Software Development Life Cycle (SDLC)

Tools

SQL Server

Snowflake

Python

Java

Docker

AWS

Azure

Google Cloud

Job description

Job Description

WHAT IS THE OPPORTUNITY?

We are seeking an experienced Senior Software Developer to join our dynamic team in Wealth Management Global IT Data Services. The successful candidate will be responsible for designing and developing large-scale projects and programs, leveraging database technologies such as SQL Server, Snowflake, and Python.

Provide information on the detailed technical design and development of applications using existing and emerging technology platforms. Apply experience and seasoned knowledge, skills, and practices to perform a variety of assignments.

WHAT WILL YOU DO?

• Design and develop small to large applications and programs, ensuring design, reusability, defect-free, and timely completion
• Develop high-quality, scalable, and maintainable code that meets the requirements and standards
• Identify, track, and resolve technical issues, and develop/recommend mitigation strategies to ensure successful solution development and delivery
• Collaborate with other teams to resolve technical issues and improve overall system performance
• Collaborate with other teams to create new and modify existing database or infrastructure objects based on required functionality.
• Participate in walkthrough reviews of technical design, specifications, programs, and unit test plans
• Assist DevOps/support teams in troubleshooting high-priority implementation issues, production investigations, and other activities
• Provide technical guidance and mentorship to junior team members on database and Python development

WHAT DO YOU NEED TO SUCCEED?

Must have:

• 5+ years of experience in database and SQL Server technologies, including Python and Snowflake
• Solid experience in Microsoft SQL Server, including its various versions and editions, database design, Implementation and maintenance
• Solid SQL experience - including querying, indexing, and performance optimization
• Solid experience with Transact-SQL (T-SQL) for stored procedures, functions and triggers
• Knowledge of security best practices, including user management, roles, and permissions.
• Understanding of backup strategies and recovery models to ensure data integrity and availability.
• Ability to analyze and improve database performance, including query optimization and index management

Nice to have:

• Java: Experience with Java programming language
• Cloud: Experience with cloud platforms such as AWS, Azure, Google Cloud
• Database: SQL Server, Snowflake
• Programming Language: Python
• DevOps: Experience with DevOps tools and methodologies
• Containerization: Experience with containerization tools such as Docker

WHAT'S IN IT FOR YOU?

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
• Leaders who support your development through coaching and managing opportunities
• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• A world-class training program in financial services
• Flexible work/life balance options
• Opportunities to do challenging work

#LI-POST #TECHPJ

Job Skills

Active Learning, Agile Methodology, Application Integrations, Detail-Oriented, Enterprise Application Delivery, Group Problem Solving, Programming Languages, Software Development Life Cycle (SDLC)

Additional Job Details

Address: RBC CENTRE, 155 WELLINGTON ST W:TORONTO

City: Toronto

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: TECHNOLOGY AND OPERATIONS

Job Type: Regular

Pay Type: Salaried

Posted Date: 2026-01-15

Application Deadline: 2026-02-06

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

Join our Talent Community

Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.