Type de contrat
- Temps plein
Description de poste
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.
- 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
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.
- 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 (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