Data Engineer Associate

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

1. Ability to resolve highly complex, multi-faceted problems to meet business needs, provide recommendation on the design and methodologies, system solutions.
2. 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.
3. Provide input to the continuous improvement of processes and adopting latest technologies and methodologies.
4. Provide L1/L2/L3 support for ETL processes build on SSIS, DataStage and PLSQL
5. Ability to liase with different teams to fix data quality issues.
6. Co-ordinate and follow up with various other different teams, vendors and third party for issue resolution.
7. Work with Infrastructure teams to co-ordinate infrastructure/environment related upgrades, patches and migration activities.
8. Ensure the documentation of issues, solutions, root cause and findings for use in future problem resolutions.
9. Development techniques, such as debugging, testing, coding, use of version control tools like TFS.
10. Performance tuning skills is considered to be an asset
11. 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.