Software Engineer

Scotiabank

Toronto, ON

Salary: Information not available

Requisition ID: 227286

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

The Transformation Office plays a critical role in enabling Enterprise Technology to deliver against its mission to bring innovation and value to the Bank with confidence and reliability, by acting as a catalyst for Risk Management across the division.

Analyze data needs and produce an effective database system to meet the needs.

In this role you will:

Database Architect: Designing, implementing, and maintaining database solutions that are scalable, reliable and secure; while ensuring they integrate seamlessly with applications and adhere to established best practices for storage, backup, and disaster recovery.
Data Modeling: Analyze business processes and requirements to create conceptual, logical, and physical data models that define entity relationships, optimize data structures for performance and integrity, and align with corporate data governance and quality standards.
Schema design: Developing efficient, maintainable, and scalable database schemas with appropriate indexing, partitioning, and constraints, while applying consistent naming conventions, enforcing access controls, and refining structures to meet evolving business needs.
SQL code development: Write clean, efficient, and well-documented SQL scripts, stored procedures, functions, and triggers to support applications and analytics, while also building ETL processes to transform and load data from various sources in compliance with version control and testing standards.
SQL query tuning: Analyzing and optimizing process, SQL queries, execution plans, and indexing strategies to enhance performance, proactively resolving bottlenecks, conducting regular performance audits, and using tuning best practices.

Do you have the skills that will enable you to succeed in this role?

BSc degree in Computer Science or relevant information technology field
5 Years Database Development (Oracle PL/SQL development, MS SQL Server etc.)
5 Years Data Modeling/Data Architect/Data Integration/Data Interface/Database Design
5 Years Database/SQL tuning
5 Years experience with data models in ERP (EBS, PeopleSoft, etc.) or CRM (Siebel, SFC, etc.) or other large OLTP applications
5 Years experience with data models in large Data Warehouse or OLAP (Essbase/SSAS/Oracle OLAP) system.
Excellent verbal and written communication skills
An ability to understand front-end users requirements and a problem-solving attitude
Excellent analytical and organization skills
Hands on experience of ETL tools (ODI, Data Stage, Informatica, SSIS)
Hands on experience with Business Intelligence tools (OBIEE, PowerBI, Tableau)
Solid Knowledge of Web Services/XML/SOAP/REST/API
Experience with Linux shell scripting.

What's in it for you?

Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove, and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
Competitive Rewards program including bonus, flexible vacation, personal, sick days, and benefits will start on day one.
Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.

We are committed to hiring military and Veteran spouses and encourage you to identify your connection with the MSEN when reaching out to us or applying to any of our open roles.

Have questions or want to learn more about us? We would love to hear from you!

rochelle.mendonca@scotiabank.com

Whenever possible, reach out to a named contact rather than a general inbox - it helps ensure a quicker, more personalized response. If you hit a bounce-back, let us know at

employment.Emploi@cfmws.com

About Scotiabank

The Scotiabank Veterans Network (SVN) is committed to supporting veterans, reservists, and military spouses by recognizing and valuing their unique skills and experiences. As a military-friendly employer, Scotiabank actively promotes the integration of veterans into civilian careers by offering a wide range of employment opportunities across the Bank. SVN plays a key role in this effort, leading initiatives such as a mentorship program designed to support both current and transitioning veterans.

The team was instrumental in driving recent enhancements to Scotiabank’s reservist leave policy and organized the inaugural Valour and Vision Expo in Q4 2024, where industry leaders pledged to support veterans entering the civilian workforce. In February 2025, Scotiabank proudly served as the lead Banking Sponsor of the Invictus Games, an international multi-sport event that aids in the rehabilitation of wounded, injured, and ill service members—both active and retired.

Additionally, SVN hosts a variety of events throughout the year, including leadership symposiums and annual Remembrance Day ceremonies, to honor and support the military community.

Job Detail