Requisition ID: 204618
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
Purpose
Contributes to the overall success of the IB Retail and Small Business Collections in Canada ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives. Ensures all activities conducted are in compliance with governing regulations, internal policies and procedures.
Accountabilities:
-
Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems, and knowledge.
-
Accountable for supporting data development, coding, analysis, design, and implementation activities including:
-
Design, develop, test, deploy, maintain, and improve current data models and automated tasks for different countries and line of business.
-
Collaborate with Business partners, business lines to document and developing of collections operations and senior management reporting.
-
Work/hands-on experience in building complex SQL Queries using MS SQL , ETLs, data partition, data indexes, end-to-end data connections.
-
Monitor, troubleshoot, research data solutions to complex problems in existing data pipelines using SQL and/or SSIS.
-
Collaborate with Solution Architect, Business Analyst, database administrators to influence data-driven decisions and institute new processes.
-
Support to enhance the design and development of existing database architecture for information system projects.
-
Design, construct, modify, integrate, implement, and test data models and data sources.
-
Understand current ETL processes, data models, production jobs and documentation.
-
Support to extract data from various sources, integrate in existing databases to further feed to reports for data analysis.
-
Create complex stored procedures and optimize existing ones using SQL Scripts.
-
Coordinate with fellow data practitioners in the team.
-
Collect and document data requirements.
-
Collaborate with data team members to automate and optimize data services.
-
Able to develop tabular and multidimensional models that are compatible with warehouse standards.
-
Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
-
Relationship management with internal and external stakeholders to ensure all data processes meet business needs.
-
Collaborate with development team to map and integrate data sources in existing data models.
-
Write and complement current technical, data, modelling documentation that will allow to improve the contents follow-up and the evolution of the data models and analytics.
-
Understand and leverage tools and methods to provide solutions to questions from the business.
-
Innovate and optimize data flows, data models, current processes and integrate new data sources and new tools following best practices and development.
-
Write process documentation and complement current technical documentation that will allow to improve the contents follow-up and the evolution of the data models, data insights and systems.
-
Demonstrated ownership for their personal development.
-
Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
-
Actively pursues effective and efficient operations of his/her respective areas, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational risk, regulatory compliance risk, AML/ATF risk and conduct risk, including but not limited to responsibilities under the Operational Risk Management Framework, Regulatory Compliance Risk Management Framework, AML/ATF Global Handbook, and the Guidelines for Business Conduct.
-
Champions a high-performance environment and implements a people strategy that attracts, retains, develops and motivates their team by fostering an inclusive work environment, communicating vison/values/business strategy and managing succession and development planning for the team.
Dimensions:
-
Collections data analysis, integration and data management for Caribbean, Colombia, Mexico, Peru, Chile, Costa Rica, Panama.
-
7+ systems / applications / Platforms (SCS, Dialer, Work Force Management, QA applications, data lake, core system data warehouse, portfolio, payments, Local country inputs among others);
-
IST/UAT/PROD infrastructure and environments, 20+ databases and 25+ data schemas in scope.
-
Collection and Recoveries Policies.
-
Total Outstanding for countries in scope approx. CAD$80B, Reportable Delinquency approx. CAD$5B, Cash Collected for International Banking CAD$4B/year.
Education and Experience Requirements:
-
Bachelor’s and/or master’s degree in computer science, Information Technology, Engineering or a related field is preferred.
-
Proficient in Visual Studio, SQL 2017/2019 and/or up, proficient in SSIS, SSRS, SSAS, PL/SQL, T-SQL queries, stored procedures, functions, cursors, user defined functions, triggers, index, view, SQL data warehouse, Power Shell. Required 5+ years’ experience.
-
Strong performance analysis and data structure optimization and the ability to troubleshoot queries, suggest indexes or design modifications, and help to incorporate best practices of database design.
-
Experience and strong knowledge in writing complex SQL statements, Phyton, DAX.
-
Knowledge in creating batch files, scheduling jobs.
-
Experience with Big data, Hadoop, Microsoft Azure and/or GCP.
-
Experience in Online Transactional Processing (OLTP) databases and Online Analytical Processing (OLAP) databases.
-
Experience with designs and implementation of ETL (Extract, transform, load) components to.
-
Strong problem solving, learning agility, and logical thinking skills.
-
Excellent written, verbal communication and interpersonal skills in both English and Spanish.
-
Writing skills in documenting user requirements and liaise well with counterparts or divisions to address the matter at hand.
-
Business acumen and organizational awareness.
-
Knowledge in Power BI.
Working Conditions:
-
Work in a standard office-based environment including hybrid
-
Non-standard hours are a common occurrence.
-
Working Hours: Monday - Friday, 9 am - 5 pm EST
-
Location: 44 King St West, Toronto
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. 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.
