Scotiabank
Data Engineer Associate
Scotiabank, Floral Park, New York, United States, 11005
ID de la solicitud:
207469Estamos comprometidos a invertir en nuestros colaboradores y ayudarles a continuar su carrera profesional en ScotiaTech.
PurposeThe 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 PLSQLAbility 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 assetCloud platform knowledge of Azure is good to haveReporting RelationshipsPrimary Manager:
Data Engineering Specialist leadDirect Reports:
Data Engineering Specialist leadShared 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 InformationBachelor’s degree in computer science, Information Technology, Engineering or a related field is preferredA minimum of 3 years’ IT industry experience and 3 years’ experience in an
ETL (Extract Transform Load)
role is essentialStrong working experience with Microsoft BI tools - SSIS, SSRS, SSAS, Power BI, DataStageWorking knowledge of computing platforms, such as Windows, LinuxStrong experience in Data Warehousing methodologies and concepts like Inmon and KimballExperienced in creating Database objects like - Procedures, Functions, Triggers, Views, JobsAdvance knowledge on working with different type of datasets -CSV, XML, JSONExperience in Object oriented programming as (C# with .Net) and SQL programming language.Strong experience in on premise relational Database technologies like MS-SQL ServerNetworking, communications, on-line transaction processing (OLTP) technologyAzure Data FactoryDevelopment techniques, such as debugging, testing, coding, use of version control tools like TFS.Performance tuning skills are a mustEnglish level required B1Cloud platform knowledge of Azure is good to haveWorking 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.
207469Estamos comprometidos a invertir en nuestros colaboradores y ayudarles a continuar su carrera profesional en ScotiaTech.
PurposeThe 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 PLSQLAbility 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 assetCloud platform knowledge of Azure is good to haveReporting RelationshipsPrimary Manager:
Data Engineering Specialist leadDirect Reports:
Data Engineering Specialist leadShared 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 InformationBachelor’s degree in computer science, Information Technology, Engineering or a related field is preferredA minimum of 3 years’ IT industry experience and 3 years’ experience in an
ETL (Extract Transform Load)
role is essentialStrong working experience with Microsoft BI tools - SSIS, SSRS, SSAS, Power BI, DataStageWorking knowledge of computing platforms, such as Windows, LinuxStrong experience in Data Warehousing methodologies and concepts like Inmon and KimballExperienced in creating Database objects like - Procedures, Functions, Triggers, Views, JobsAdvance knowledge on working with different type of datasets -CSV, XML, JSONExperience in Object oriented programming as (C# with .Net) and SQL programming language.Strong experience in on premise relational Database technologies like MS-SQL ServerNetworking, communications, on-line transaction processing (OLTP) technologyAzure Data FactoryDevelopment techniques, such as debugging, testing, coding, use of version control tools like TFS.Performance tuning skills are a mustEnglish level required B1Cloud platform knowledge of Azure is good to haveWorking 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.