SQL Developer / Data Engineer

The Toronto-Dominion Bank (Canada); Toronto; On-site; CAD 82,000 - 115,000; Full time

Job summary

The Toronto-Dominion Bank (TD) in Toronto, ON is seeking a Senior SQL Developer / Data Engineer to support a business-critical reporting platform used across Treasury & Balance Sheet Management. You will design, optimize, and maintain data pipelines, data models, and SQL queries in a large enterprise data warehouse.

Collaborate with stakeholders and developers to deliver analytics solutions, contribute to cloud modernization, and apply CI/CD and automated testing practices.

Qualifications

• 5+ years of experience in software development, database engineering, data engineering, or related technical disciplines.

Responsibilities

• Design, develop, and support scalable database solutions, reporting data models, and data pipelines supporting business-critical reporting and analytics.
• Develop and optimize complex SQL queries, stored procedures, views, and ETL processes to ensure high performance and reliability.
• Perform data modeling, database design, performance tuning, and troubleshooting within large-scale enterprise data environments.
• Collaborate with business stakeholders, analysts, and developers to deliver reporting, data integration, and analytics solutions.
• Support production investigations, root cause analysis, and ongoing platform enhancements.
• Contribute to modernization initiatives involving big data technologies, cloud platforms, automation, and DevOps practices.
• Apply software engineering best practices including source control, automated testing, CI/CD, and AI-assisted development tools.

Skills

SQL Server

ETL/Data pipelines

Data modeling

Performance tuning

CI/CD

AI-assisted tools

Communication

Tools

Hadoop/Spark

Azure

GitHub Copilot

CI/CD pipelines

Job description

Work Location: Toronto, Ontario, Canada Hours: 37.5 Line of Business: Technology Solutions Pay Details: $81,600 - $115,200 CAD This role is temporarily eligible for a pay premium above the posted salary range that is reassessed annually. TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary range over time as they progress in their role. The base pay actually offered may vary based upon the candidate's skills and experience, job-related knowledge, geographic location, and other specific business and organizational needs.

Job Description

Position Title: Senior SQL Developer / Data Engineer

Reporting Line: Treasury & Balance Sheet Management (TBSM)

TD Bank Group Headquartered in Toronto, Canada, with more than 100,000 employees in offices around the world, The Toronto-Dominion Bank and its subsidiaries are collectively known as TD Bank Group ("TD"). TD offers a full range of financial products and services to more than 26.5 million customers worldwide through three key business lines: Canadian Retail including TD Canada Trust, Business Banking, TD Auto Finance, TD Wealth, TD Direct Investing, and TD Insurance U.S. Retail including TD Bank, America’s Most Convenient Bank, TD Auto Finance, TD Wealth, and TD’s investment in Schwab Wholesale Banking through TD Securities TD had C$2.1 trillion in assets as of April 30, 2025. TD also ranks among the world’s leading online financial services firms, with approximately 14 million active online and mobile customers. The Toronto-Dominion Bank trades on the Toronto and New York stock exchanges under the symbol "TD".

About the Team

The Treasury & Balance Sheet Management (TBSM) Technology team delivers critical data, reporting, and analytics solutions that support Treasury, Finance, Risk, and regulatory functions across TD. As part of the Reporting Platform team, you will be a key developer supporting a business-critical reporting ecosystem used across TBSM. The platform includes a large-scale SQL data warehouse, data integration services, reporting solutions, and cloud modernization initiatives. You will work closely with business stakeholders, developers, architects, and data specialists across multiple locations to deliver scalable and reliable data solutions.

What You’ll Do

As a Senior SQL Developer / Data Engineer you will support and evolve a business-critical reporting and data platform used across the Treasury and Balance Sheet Management department (TBSM).

• Design, develop, and support scalable database solutions, reporting data models, and data pipelines supporting business-critical reporting and analytics.
• Develop and optimize complex SQL queries, stored procedures, views, and ETL processes to ensure high performance and reliability.
• Perform data modeling, database design, performance tuning, and troubleshooting within large-scale enterprise data environments.
• Collaborate with business stakeholders, analysts, and developers to deliver reporting, data integration, and analytics solutions.
• Support production investigations, root cause analysis, and ongoing platform enhancements.
• Contribute to modernization initiatives involving big data technologies, cloud platforms, automation, and DevOps practices.
• Apply software engineering best practices including source control, automated testing, CI/CD, and AI-assisted development tools.

Required Qualifications

• 5+ years of experience in software development, database engineering, data engineering, or related technical disciplines.
• Strong hands-on Microsoft SQL Server development experience, including complex SQL development, stored procedures, functions, and database programming.
• Experience designing and maintaining scalable data models and enterprise data warehouse solutions.
• Expertise in query optimization, performance tuning, indexing strategies, and database performance troubleshooting.
• Experience building and supporting ETL, data integration, or data engineering solutions.
• Familiarity with Hadoop, Spark, Spark SQL, or other big data technologies.
• Experience with CI/CD pipelines, DevOps practices, and automated testing frameworks.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent verbal and written communication skills.
• Experience leveraging AI-assisted development tools such as GitHub Copilot.

Preferred Qualifications

• Java and Spring Boot development experience.
• .NET / C# development experience.
• Azure Databricks experience.
• Python development experience.
• Experience with Tableau and/or Power BI.
• Experience with cloud data platforms and modernization programs.
• Financial services, treasury, risk management, or regulatory reporting experience.

Who We Are

TD is one of the world's leading global financial institutions and is the fifth largest bank in North America by branches/stores. Every day, we strive to make every interaction, product, and experience remarkably human and refreshingly simple for over 27 million households and businesses in Canada, the United States and around the world. More than 95,000 TD colleagues bring their skills, talent and creativity to foster deeper relationships, ensure disciplined execution, and build a simpler, faster banking experience. TD is deeply committed to being a leader in client experience, that is why we believe that all colleagues, no matter where they work, are client facing. Together, we are reimagining what banking can be for our clients, colleagues and communities.

Our Total Rewards Package

Our Total Rewards package reflects the investments we make in our colleagues to help them and their families achieve their financial, physical, and mental well-being goals. Total Rewards at TD includes a base salary, variable compensation, and several other key plans such as health and well-being benefits, savings and retirement programs, paid time off, banking benefits and discounts, career development, and reward and recognition programs.

Learn more

Additional Information

We’re delighted that you’re considering building a career with TD. Through regular development conversations, training programs, and a competitive benefits plan, we’re committed to providing the support our colleagues need to thrive both at work and at home.

Please be advised that this job opportunity is subject to provincial regulation for employment purposes. It is imperative to acknowledge that each province or territory within the jurisdiction of Canada may have its own set of regulations, requirements.

Colleague Development

If you’re interested in a specific career path or are looking to build certain skills, we want to help you succeed. You’ll have regular career, development, and performance conversations with your manager, as well as access to an online learning platform and a variety of mentoring programs to help you unlock future opportunities. If you’re passionate about helping clients and building deep, lasting relationships, TD offers diverse career paths where you can grow your expertise and make a meaningful impact. We're committed to your success and foster a respectful workplace where diverse perspectives are valued, everyone has fair opportunities to grow, and you can unlock your full potential to achieve your career goals.

Training & Onboarding

We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.

Interview Process

We’ll reach out to candidates of interest to schedule an interview. We do our best to communicate outcomes to all applicants by email or phone call.

Accommodation

Your accessibility is important to us. Please let us know if you’d like accommodations (including accessible meeting rooms, captioning for virtual interviews, etc.) to help us remove barriers so that you can participate throughout the interview process.

Language Requirement (Quebec only)

Sans Objet US Labor & Employment Posters | California Privacy | Accessibility | FAQ

Our Values

At TD we’re guided by our purpose to enrich the lives of our customers, communities and colleagues, and share a set of values that shape our culture and guide our behavior. In exchange for how our colleagues show up to help TD succeed, we are committed to delivering a colleague experience grounded in Impact, Growth and a Culture of Care. No matter where you work across TD, we empower you to make an impact at work and in your community, explore and grow your career and be part of our caring and inclusive culture.

Our Commitment to Diversity, Equity, and Inclusion

At TD, we’re committed to fostering an environment where all colleagues are encouraged to bring their authentic selves to work, experience equitable opportunities, and feel respected and supported. We’re dedicated to building an inclusive workforce that reflects the diversity of the customers and the communities in which we live and serve.

Helping to Make an Impact in Communities – TD Ready Commitment

TD has a long-standing commitment to help drive progress towards a more inclusive and sustainable future. That’s why we launched the TD Ready Commitment in 2018, now a multi-year North American initiative. Under the TD Ready Commitment, we are targeting a total of C$1 billion by 2030 in community giving across four key, interconnected drivers of change: Financial Security, Vibrant Planet, Connected Communities, and Better Health. It’s our goal to help support change, nurture progress, and contribute to making the world a better, more inclusive place for our customers, colleagues, and communities. Learn more: Canada | US | Europe & Asia Pacific