Software Engineer (Azure)

Scotiabank; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading bank in the Americas is seeking a technical contributor for Cloud migration, focusing on developing and improving Azure ETL processes. The role includes providing support for ETL processes, resolving complex problems, and ensuring documentation for future solutions. The ideal candidate has hands-on experience with Azure Data Factory and strong SQL Server skills. The bank values diversity and offers a competitive rewards program and opportunities for community engagement.

Benefits

Diversity, Equity, Inclusion & Allyship

Upskilling opportunities

Competitive Rewards program

Community Engagement opportunities

Qualifications

• 2 years Azure Data Factory pipeline development experience (highly desirable).
• Experience in developing CI/CD pipelines for Azure Data Factory.
• Support/integration experience with SaaS solutions and vendor‑driven technology.

Responsibilities

• Develop new solutions for Collections data processing.
• Provide L1/L2/L3 support for ETL processes.
• Liaise with teams bank-wide to fix data quality issues.

Skills

Hands-on experience on Azure Data Factory/Synapse ETL pipelines

Strong SQL Server development experience

SQL code optimization techniques

Fundamentals of security and IAM on Azure Cloud

Understanding of Active Directory and Azure Key Vault

CI/CD pipelines development on Azure DevOps

Debugging and testing techniques

Linux SSH Scripting

.NET Core Development (C#, ASP)

Excellent problem solving and troubleshooting skills

Strong communication skills

Tools

Azure Data Factory

Jira

Confluence

Job description

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

Global Collections Technology provides solutions and support to the retail Collections business operations in Canada, LATAM and Caribbean countries. We support mission critical applications and technology processes across the global landscape of the bank to help our business partners provide customer service excellence with regards to the collection of delinquent payments.

A key technical contributor to the Cloud migration journey for Global Collections. Designs and develops ETL processes on pipelines using Azure Data Factory / Azure SQL Managed Instance platforms. Refines processes and pipelines for code and infrastructure delivery, ensuring protection of sensitive Bank data as it relates to Collections data processing.

Provides Azure ETL processing on‑call support for Canada Collections.

In this role you will:

• Develop new solutions and improve existing technology capabilities to ensure Collections data processing activities are executed in accordance with business requirements
• Provide L1/L2/L3 support for ETL processes built on SSIS, DataStage and PLSQL
• Provide Cloud technology support to Collections, including new and existing portfolios, ad hoc queries, and assisting with the design and implementation of systems enhancements
• Work with Infrastructure teams to co‑ordinate infrastructure/environment related upgrades, patches and migration activities
• Resolve highly complex, multi‑faceted problems to meet Collections business needs, providing recommendations on design, methodologies and system solutions
• Co‑coordinate and follow up with various other different teams, vendors and third party for issue resolution
• Liaise with appropriate teams bank‑wide to fix data quality issues
• Provide input to the continuous improvement of processes and adopting latest technologies and methodologies
• Ensure the documentation of issues, solutions, root cause and findings for use in future problem resolutions
• Understand how the Bank's risk appetite and risk culture should be considered in day‑to‑day activities and decisions
• Champion a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge
• Champion a high‑performance environment and contribute to an inclusive work environment
• Actively pursue effective and efficient operations of his/her respective areas in accordance with Scotiabank's Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day‑to‑day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk

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

• Hands‑on experience on Azure Data Factory/Synapse ETL pipelines creation from scratch and troubleshooting cloud configuration issues
• Strong SQL Server development experience, including designing efficient stored procedure‑based dataflows, building DB objects such as tables, indexes, partitions
• Strong knowledge on SQL code optimisation techniques, leveraging tools such as SQL execution plans
• Strong fundamentals of security and IAM on Azure Cloud
• Solid practical understanding of Active Directory, Service principles, Secrets, Private End Points, Azure Key Vault
• Experience developing CI/CD pipelines on Azure DevOps for deployment of Azure Data Factory/SQL ML code base to higher environments (UAT/PROD)
• Development techniques, such as debugging, testing, coding, use of version control tools like TFS
• 2 years Azure Data Factory pipeline development experience (highly desirable)
• Performance tuning skills are considered a valuable asset
• DevOps process orientation
• Experience in Linux SSH Scripting
• Experience in .NET Core Development (C#, ASP)
• Practical experience with technology integrations, using best practice methods to establish secure connectivity (i.e. APIs/Microservices) for data exchange
• Support/integration experience with SaaS solutions and vendor‑driven technology
• Basic knowledge of Jira and Confluence
• Excellent analytical, problem solving and troubleshooting skills in order to quickly and effectively resolve problems in a demanding environment
• Strong communication skills (written and verbal) related to technology solutions, project deliverables and ongoing communication

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 provide opportunities for all employees to learn, grow & participate through our Employee Resource Groups that span 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.