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

📌 Data and Analytics Manager (Bogotá)
🏢 Scotiabank Global Site
📍 Bogotá