Lead Developer with Azure Data Factory and ETL

Requisition ID: 266162 

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

The Team

Global Operations Technology – Fraud, Collections & System Reliability Office 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.

The Role

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.

Is this role right for you? 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-ordinate 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
• Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge
• Champions a high-performance environment and contributes to an inclusive work environment.
• Actively pursues 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

What You Will Bring to Succeed

• Hands on experience on Azure Data Factory/Synapse ETL pipelines creation from scratch and troubleshooting cloud configuration issues
• Strong SQL Server development experience including (but not limited to) designing efficient stored procedure-based dataflows, building DB objects such as tables, indexes, partitions
• Strong knowledge on SQL code optimization 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 to be an asset
• DevOps process oriented
• Experience in Linux SSH Scripting
• Experience in .NET Core Development (C#, ASP)
• Practical experience of 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 trouble shooting 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 on-going communication

What’s in it for you?

• We are strategic technology partners dedicated to transforming the way our global workforce operates.
• Our inclusive and collaborative work environment fosters creativity, curiosity, and celebrates achievements.
• You will have the opportunity to collaborate with and learn from diverse industry leaders who have experience at top technology companies worldwide.
• We cultivate a culture of innovation and continuous learning.
• We prioritize the well-being of our employees, empowering them to design their work processes to achieve outstanding results.
• We offer a competitive total rewards package, which includes a performance bonus, company matching programs (for pension and profit sharing), and generous vacation benefits.

#LI-Hybrid

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.