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 _**:

- 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 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.