Share this Job

Title:  Data Engineer

 

 

Requisition ID: 90168

Cost Centre: COLOMBIAN CENTRE OF EXCELLENCE AP 

Employee Referral Program - Probable Payment:

 

Thank you for your interest in GSGlobales!


Our group has a strong commitment to promoting a workplace where you feel supported by your supervisors, in a way that ensures your success and that of each customer.

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:
    • Understand current ETL processes, data models, production jobs and documentation.
    • Design, develop, test, deploy, maintain and improve current data models for different countries.
    • Develop and test extraction, transformation, and load (ETL) processes form different source systems and/or from new business user requirements;
    • Map source system data to data warehouse models;
    • Conduct root cause analysis for production ETL issues to identify enhancements and optimizations;
    • Collaborate with Production support team to improve stability and reliability of the ETL pipeline;
    • Work/hands-on experience in building complex SQL Queries using MS SQL
    • Design, develop and maintain database objects (tables, views, stored procedures, triggers) in SQL Server 2017 environment
    • Analysis, design and development of new data models and customization of current data models based on business user needs.
    • Support all the data development, code improvement, new coding, testing, QAT processes and pass to production to maintain data elements and data models
    • 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
    • Liaise with reporting lead within the team to design, build and test dashboards
    • Collaborate with data team members to automate and optimize data services
    • Design, build and test data for reporting, applications and portal interfaces including SSIS packages for ETL processes, SSAS Cubes, SQL Agent jobs, SSRS automated reports, SQL code/stored procedures, triggers
    • Improve performance, scalability and stability of databases and application processes
    • Determine the logical design characteristics and information management strategies to store, move, and manage data
    • Maintain Data warehouse best practices documentation, data model documentation and database sizing recommendations
    • 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
    • Write and complement current technical documentation that will allow to improve the contents follow-up and the evolution of the data models 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.

sb_blk

 

                                       

   Position:  Data Developer, IB Retail and Small Business Collections

 

     Reporting Relationships (Job Titles only)

Primary Manager:

(include secondary Manager if applicable)

Data Integration Manager

Sr. Manager, Data and Business Intelligence

 

Direct Reports:

None

Shared Reports (solid/dotted if applicable):

None

         Dimensions

  • Collections data analysis, integration and data management for Caribbean, Colombia, Mexico, Peru, Chile, Costa Rica, Panama
  • 7+ systems / applications (SCS, Debt Manager, Dialer, Genesys, PPES, Property Tracker, Agency Tracker, Local country Collection systems 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 International Banking CAD$4B/year

 

Education / Experience / Other Information (include only those that are specific to the role)

  • Bachelor’s and/or Master’s degree in Computer Science, Information Technology, Engineering or a related field is preferred
  • Proficient in SQL2008/2012/2014//2017 (SSIS, SSRS, SSAS, PL/SQL, T-SQL queries, stored procedures, functions, cursors, user defined functions, triggers, index, view). 2+ years’ experience
  • Strong performance analysis and optimization tools 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, VBA scripts, DAX
  • Knowledge in creating batch files, scheduling jobs
  • Experience with Microsoft Azure Databricks OR Databricks
  • 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 load data from disparate source systems using SQL Server and Microsoft BI tools  
  • Knowledge in Power BI, Tableau
  • 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 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 || Colombia : Cundinamarca : Bogotá
We offer a positive work environment, competitive benefits, social responsibility activities and/or volunteering opportunities. Scotiabank is considered the best financial group to work for in Colombia, having an international presence.
We appreciate your interest; however, only candidates selected for an interview will be contacted.
**GSGlobales is an inclusive company that respects diversity and does not engage in any form of discrimination**