Title:  Software Engineer

Requisition ID: 261761 

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

Purpose of the Role

Application / Database Developer, the incumbent will be responsible for the design, development, and support of database and data integration solutions supporting critical AML and compliance applications. This role requires strong hands-on SQL Server and Python development skills, solid experience in ETL and data warehousing, and the ability to work independently while collaborating effectively across technology and business teams. An excellent attitude, strong ownership, and professional conduct are essential for success in this role.

Accountabilities:

• Design, develop, enhance, and support SQL Server database components, including stored procedures, functions, packages, triggers, and scripts to support application and reporting requirements.
• Perform in-depth troubleshooting and debugging of ad-hoc queries, stored procedures, and data migration scripts, ensuring accuracy, performance, and data integrity.
• Develop and maintain Python-based solutions (mandatory) for data processing, automation, ETL workflows, and operational support activities.
• Design, build, and support ETL (Extract, Transform, Load) processes, including staging architectures, data transformations, and handling of slowly changing dimensions.
• Apply data warehousing principles and multi-dimensional data modeling concepts to enable scalable, reliable data solutions.
• Produce and maintain source-to-target mappings and contribute to data integration architecture and implementation.
• Support automation and operational processes using shell scripting where applicable.
• Work closely with solution architects, business analysts, project teams, and production support teams to understand requirements and deliver high-quality, sustainable solutions.
• Independently analyze and resolve complex technical and data-related issues, demonstrating sound judgment and accountability.
• Ensure deliverables align with Scotiabank’s technology standards, risk appetite, security, and regulatory requirements, including AML obligations.
• Actively contribute to a positive team culture by demonstrating professionalism, collaboration, and an excellent attitude in all interactions.

Qualifications

Education & Experience

• Bachelor’s degree in computer science, Engineering, or a related technical field, or equivalent practical experience.
• Minimum 5 years of hands-on experience managing and developing SQL Server databases, including stored procedures, functions, packages, and triggers.
• Minimum 5 years of experience debugging ad-hoc queries, stored procedures, and executing data migration scripts in complex environments.
• Strong Python development experience, with demonstrated use of Python for ETL, data processing, automation, or integration activities.
• Working experience with C#/.NET and Visual Studio IDE.
• Proven understanding of ETL strategies and design, including staging layers, transformations, and slowly changing dimensions.
• Solid understanding of data warehousing concepts, multi-dimensional data modeling, and data integration architecture.
• Experience with shell scripting for automation and operational support.

Soft Skills & Behavioral Competencies

• Excellent attitude, with a strong sense of ownership, accountability, and professionalism.
• Self-motivated, results-oriented, and able to work independently with minimal supervision.
• Strong analytical and problem-solving skills, with the ability to resolve complex technical and business problems.
• Excellent interpersonal and communication skills, with the ability to work effectively with diverse stakeholders including business users, developers, project teams, and senior management.
• Ability to build consensus, collaborate effectively, and operate successfully in a fast-paced, regulated environment.

Assets (Nice to Have)

• Prior experience in the banking or financial services industry.
• Previous experience with LexisNexis/Fircosoft products or AML/compliance-related platforms.

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

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.