Job Information
Scotiabank Data Engineer Associate in Bogota, Colombia
Data Engineer Associate
Enviar candidatura ahora »
Fecha: 26 oct. 2024
Ubicación: Bogota, DC, CO
Empresa: Scotiabank
ID de la solicitud: 207469
Estamos comprometidos a invertir en nuestros colaboradores y ayudarles a continuar su carrera profesional en ScotiaTech.
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
Reporting Relationships
Primary Manager:
- Data Engineering Specialist lead
Direct Reports:
- Data Engineering Specialist lead
Shared Reports (solid/dotted if applicable):
Dimensions
The incumbent must have a high level of knowledge of all aspects of Information Technology and industry practices as well as a detailed understanding of systems architecture. The incumbent must have excellent analytical, problem solving and trouble shooting skills in order to quickly and effectively resolve problems. The incumbent must be highly creative in identifying and researching technical solutions to resolve business problems. The incumbent must be able to take abstract concepts and apply them to formulate solutions and often work in variable, precedent setting situations requiring the ability to quickly identify and resolve unique problems. The incumbent must have a detailed knowledge of all database technologies deployed by the department in order to provide effective support.
The incumbent must have good interpersonal and communication skills in order to deliver proposals, provide consultation to support staff and interact with diverse user groups from clerical to senior management level.
Education / Experience / Other Information
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, DataStage
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
Azure Data Factory
Development techniques, such as debugging, testing, coding, use of version control tools like TFS.
Performance tuning skills are a must
English level required B1
Cloud platform knowledge of Azure is good to have
Working Conditions
The incumbent must be fluent in English and Spanish (oral and written).
The position requires concentrated use of sight and touch at a computer terminal on average 5 - 6 hours/day.
The incumbent must work under tight deadlines, conflicting priorities and changing project requirements.
The incumbent must be able to react quickly to resolve problems and work overtime outside office hours on occasion to meet SLAs to resolve issues.
# LI - Hybrid
Ubicación(s): Colombia : Bogota : Bogota
ScotiaTech es una unidad de negocio de ScotiaGBS, un grupo de empresas de Scotiabank, ubicado en Bogotá, Colombia. ScotiaTech fue creado para apoyar diversos sistemas y procesos tecnológicos del Banco. Ofrecemos un entorno de trabajo inclusivo y positivo, además de ventajas competitivas.
En ScotiaTech, valoramos las habilidades y experiencias únicas que cada persona aporta y nos hemos comprometido a crear y mantener un entorno inclusivo y accesible para todos. Los candidatos deben postularse directamente en línea si desean ser tomados en cuenta para este puesto. Agradecemos a todos los candidatos por su interés en esta oportunidad profesional en ScotiaTech; sin embargo, solo contactaremos a quienes hayan sido seleccionados para una entrevista.
Nota: Todos los puestos que se publican en me@Scotiabank estarán disponibles durante al menos 5 días.