Requisition ID: 264949
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
Role
As a Application / Database Engineer, the incumbent will work on the design, development, and support of robust database and data integration solutions supporting critical AML and compliance platforms. This role requires expertise in SQL Server and Python development, understanding of ETL and data warehousing, and the ability to drive end-to-end delivery working with senior resources and collaborating with cross-functional stakeholders.
What will we expect from you?
- The role demands strong ownership, proactive problem-solving, and the ability to operate effectively in a fast-paced, highly regulated environment.
- Work on design, development, and optimization of SQL Server database components, including stored procedures, functions, packages, triggers, and scripts supporting enterprise applications and reporting.
- Own troubleshooting, root cause analysis, and resolution of data-related issues across ad-hoc queries, ETL processes, and production environments.
- Design and develop scalable Python-based solutions for data processing, automation, and ETL workflows, ensuring performance and maintainability.
- Architect and implement ETL solutions, including staging layers, transformations, and handling of complex data scenarios such as slowly changing dimensions and high-volume data processing.
- Apply data warehousing concepts and multi-dimensional data modeling to build scalable, high-performance data platforms.
- Define and maintain source-to-target mappings, data lineage, and integration standards to ensure data integrity and consistency.
- Proactively identify opportunities for automation, performance optimization, and process improvement across data pipelines and operational processes.
- Ensure all deliverables comply with enterprise technology standards, security controls, regulatory requirements, and AML compliance obligations.
- Act as a key contributor during production incidents, releases, and change management activities, ensuring stability and minimal business impact.
- Foster a collaborative and high-performance team environment through strong communication, accountability, and professionalism.
What You Will Bring to Succeed
- Bachelor’s degree in computer science, Engineering, or a related field, or equivalent practical experience.
- Minimum 5+ years of experience in SQL Server development, including database design and performance tuning.
- Experience in troubleshooting data and application issues in production environments.
- Strong hands-on experience with Python for ETL, data processing, and automation use cases.
- Understanding of data warehousing concepts, dimensional modeling, and data architecture principles.
- Experience with C#/.NET and Visual Studio is considered an asset.
- Experience with shell scripting for automation and operational support.
Soft Skills & Leadership Competencies
- Strong ownership mindset with the ability to lead deliverables end-to-end.
- Excellent analytical and problem-solving skills, including the ability to manage ambiguity and drive resolution.
- Effective communication skills, with the ability to engage both technical and business stakeholders, including senior leadership.
The Workplace
- We are technology partners who help the business transform how our employees around the world work
- We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!
- You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world
- We foster an environment of innovation and continuous learning
- We care about our people, allowing them to design how they work to deliver amazing results
- We offer a competitive total rewards package, including a performance bonus, company matching programs (on pension & profit sharing), and generous vacation
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. 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.
