Cloud Developer - Scotiabank, Toronto

Position summary

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. As a key technical contributor to the Cloud migration journey for Global Collections, you will design and develop ETL processes on pipelines using Azure Data Factory and Azure SQL Managed Instance platforms.

Responsibilities

• 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
• Design, develop, and support APIs and integrations between Collections applications, cloud platforms, and vendor solutions
• Support cloud modernization initiatives, including Azure and GCP-based solutions
• 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
• Provide Azure ETL processing on-call support for Canada Collections

Requirements

• 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 optimization techniques, leveraging tools such as SQL execution plans
• Strong fundamentals of security and IAM on Azure Cloud
• Experience developing and supporting REST APIs and microservices for enterprise application integration
• Working knowledge of Google Cloud Platform (GCP) and multi-cloud architecture patterns
• Experience with API management, secure connectivity, and vendor/SaaS integrations
• 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
• Development techniques, such as debugging, testing, coding, use of version control tools like TFS
• 2 years Azure Data Factory pipeline development experience
• Performance tuning skills
• 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 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 related to technology solutions, project deliverables and on-going communication

Why you'll love it here

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.

• Collaborate with and learn from diverse industry leaders who have experience at top technology companies worldwide
• Culture of innovation and continuous learning
• Prioritization of employee well-being, empowering staff to design their work processes to achieve outstanding results
• Competitive total rewards package, including a performance bonus, company matching programs for pension and profit sharing, and generous vacation benefits