Title:  Data and Analytics Manager - Collections

Requisition ID: 259148  


We are committed to investing in our employees and helping you continue your career at ScotiaGBS
 

Purpose

Contributes to the overall success of the IB Retail and Small Business Collections 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.

Accountability 

•    Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
•    Accountable for leading data management, development and analysis activities including: 
•    Design, modeling of data, develop, test, implement, optimize and maintain data elements and data models
•    Liaise with Reporting lead within the team to design, build and test dashboards
•    Design, build and test data for reporting, applications and portal interfaces including SSIS packages for ETL processes, SQL Agent jobs, SQL code/stored procedures, triggers
•    Support Big Data environments and the transition from on-premises to cloud, databases to databricks 
•    Work/hands-on experience in building complex SQL Queries using MS SQL
•    Improve performance, scalability and stability of databases and application processes
•    Design, develop and maintain database objects (tables, views, stored procedures, triggers) in SQL environments
•    Identify issues and improvements to existing SQL processes for optimal efficiency
•    Create and suggest indexes, data structures, in-memory tables, and other performance tuning concepts to incorporate best industry practices into the product suite
•    Determine the logical design characteristics and information management strategies to store, move, and manage data
•    Design and maintain data warehouse best practices documentation, data model documentation and database sizing recommendations
•    Design, implement and distribute monthly, quarterly and yearly dashboard reporting to various business stakeholders
•    Relationship management with internal and external stakeholders to ensure all data processes meet business needs 
•    Collaborate with teams to integrate systems and to bring data sources
•    Discover efficient ways to organize, store and analyze data with attention to security and confidentiality
•    Manage data engineer’s development team that supports Global data models, databases, ETLs and automated processed
•    Design and ensure data quality processes are in place for each of the data models by country
•    Collaborate with different local and global teams to identify, develop, improve and customize data models and data for reports for each country and for the division
•    Prioritize and resolve production issues raised for different databases, data in reports, ETLs and production jobs.
•    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. 
     

Reporting Relationships 

Primary Manager: Sr. Manager, Data and Business Intelligence
Director, Reports and Analytics
Direct Reports:    None
Shared Reports:    None

Dimensions

•    Collections data analysis, integration and data management for 11+ Caribbean countries, Mexico, Peru, Chile, 
•    5+ systems / applications / data inputs (SCS, Dialer, FICO, Core systems, local countries other business areas, among others); 
•    IST/UAT/PROD environments, 20+ databases and 25+ data schemas in scope
•    Collection and Recoveries Policies 
•    Total Outstanding for countries in scope approx. CAD$51B, Reportable Delinquency approx. CAD$3B, Cash Collected for Mexico, Peru & Chile approx. CAD$348MM

Education / Experience / Other Information

•    Bachelor’s and/or Master’s Degree in Computer Science, Information Technology, Engineering or a related field is preferred 
•    Proficient in SQL, SSIS, PL/SQL, T-SQL queries, stored procedures, functions, cursors, user defined functions, triggers, index, view). 4+ years’ experience
•    Experience on Big Data Technologies like Databricks/Sparck, Databricks workspace, Databricks notebooks, Data Lakes
•    Strong performance analysis and optimization tools and the ability to troubleshoot queries, suggest optimization or design modifications, and help to incorporate best practices of database design
•    Experience and strong knowledge in writing complex SQL statements, VBA scripts. 
•    Knowledge in creating batch files, scheduling jobs
•    Knowledge in Online Transactional Processing (OLTP) databases and Online Analytical Processing (OLAP) databases
•    Experience and knowledge in dimensional data model design
•    Experience with designs and implementation of ETL (Extract, transform, load) components to load data from disparate source systems using SQL Server and Microsoft BI tools  
•    Knowledge in Power BI
•    Strong problem solving, learning agility, and logical thinking skills
•    Excellent written, verbal communication and interpersonal skills
•    Writing skills in documenting user requirements and liaise well with counter-parts or divisions to address the matter at hand.
•    Business acumen and organizational awareness
•    Experience in MS Azure is a plus
•    Knowledge of Big data, Hadoop, Hive, SAS is a plus

Location(s):  Colombia : Bogota : Bogota 

Scotia GBS is a Scotiabank Group company located in Bogota, Colombia created to support different processes of the Bank and the development and execution of its global services strategy in 15 countries in the Americas. It is composed of 7 service units. We offer an inclusive, positive work environment, and competitive benefits.

At ScotiaGBS, 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. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at ScotiaGBS; however, only those candidates who are selected for an interview will be contacted.