Data Engineer Associate

Scotiabank; Bogotá; Presencial; COP 90.000.000 - 130.000.000; Jornada completa

Descripción de la vacante

ScotiaTech in Bogota, Colombia, is ScotiaBank's technology hub focused on data engineering and ETL operations.

The role supports daily ETL pipelines, data warehousing, and BI tooling, requiring SQL, SSIS/SSRS/SSAS, and cloud knowledge.

Formación

• Bachelor’s degree in Computer Science, Information Technology, Engineering or a related field preferred.
• Experience: minimum 3 years in IT and 3 years in an ETL role.

Responsabilidades

• Resolve complex problems to meet business needs and provide design recommendations.
• Provide L1/L2/L3 support for ETL processes built on SSIS, DataStage and PL/SQL.
• Coordinate with multiple teams and vendors for issue resolution.
• Document issues, solutions, root causes and findings for future reference.
• Performance tuning and Azure cloud knowledge are desirable.

Conocimientos

ETL

SQL

C#/.NET

Data Warehousing

Power BI

Educación

Bachelor’s degree in CS/IT/Engineering

Herramientas

SSIS

SSRS

SSAS

DataStage

TFS

PL/SQL

MS-SQL Server

Descripción del empleo

Select how often (in days) to receive an alert:

Select how often (in days) to receive an alert:

Please be advised that our Careers site will be unavailable from November 28 at 12am ET to November 29 12am ET for scheduled system maintenance.

Requisition ID: 266579

Thanks for your interest in ScotiaTech, Scotiabank's new and innovative Technology hub in Bogota.

Join a purpose driven winning team that promotes creativity and innovation in a fast-paced environment, where we’re always committed to results, in an inclusive, diverse, and high-performing culture.

Purpose

The Support data engineers are responsible for the day-to-day support and operations of the ETL jobs. These technology pros have deep knowledge of various data storage technologies such as SQL and ETL technologies. Their jobs are to maintain and support the plumbing -- data pipelines that clean, aggregate, and organize data from different sources, and then load them into databases or data warehouses/lakes.

Accountabilities

• Ability to resolve highly complex, multi-faceted problems to meet business needs, provide recommendation on the design and methodologies, system solutions.
• Provide business support to all units globally, including new and existing portfolios, ad hoc queries, and assisting with the design and implementation of systems enhancements. The incumbent is responsible for ensuring that management is kept informed, and that problems and issues are escalated appropriately.
• Provide input to the continuous improvement of processes and adopting latest technologies and methodologies.
• Provide L1/L2/L3 support for ETL processes build on SSIS, DataStage and PLSQL
• Ability to liase with different teams to fix data quality issues.
• Co-ordinate and follow up with various other different teams, vendors and third party for issue resolution.
• Work with Infrastructure teams to co-ordinate infrastructure/environment related upgrades, patches and migration activities.
• Ensure the documentation of issues, solutions, root cause and findings for use in future problem resolutions.
• Development techniques, such as debugging, testing, coding, use of version control tools like TFS.
• Performance tuning skills is considered to be an asset
• Cloud platform knowledge of Azure is good to have

Requirements

• Bachelor’s degree in computer science, Information Technology, Engineering or a related field is preferred
• A minimum of 3 years’ IT industry experience and 3 years’ experience in an ETL (Extract Transform Load) role is essential
• Strong working experience with Microsoft BI tools - SSIS, SSRS, SSAS, Power BI
• Working knowledge of computing platforms, such as Windows, Linux
• Strong experience in Data Warehousing methodologies and concepts like Inmon and Kimball
• Experienced in creating Database objects like - Procedures, Functions, Triggers, Views, Jobs
• Advance knowledge on working with different type of datasets -CSV, XML, JSON
• Experience in Object oriented programming as (C# with .Net) and SQL programming language.
• Strong experience in on premise relational Database technologies like MS-SQL Server
• Networking, communications, on-line transaction processing (OLTP) technology
• Development techniques, such as debugging, testing, coding, use of version control tools like TFS.
• Performance tuning skills are a must
• Cloud platform knowledge of Azure is good to have

Location(s): Colombia : Bogota : Bogota
ScotiaTech is a business unit within ScotiaGBS, a Scotiabank Group company located in Bogota, Colombia. The ScotiaTech hub was created to support different technology systems and processes of the Bank. We offer an inclusive, positive work environment, and competitive benefits.

At ScotiaTech, we value the unique skills and experiences each individual brings and are committed to creating and maintaining an inclusive and accessible environment for everyone.

Job Segment: Cloud, Computer Science, Database, Data Warehouse, Developer, Technology