Title: Software Engineer (Azure)
Requisition ID: 246265
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-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
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 (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?
- 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 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.
Job Segment:
Software Engineer, Cloud, Bank, Banking, Investment Banking, Engineering, Technology, Finance