Data Engineering Applications Specialist ETL

Requisition ID: 235898

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 ETL Developer will contribute to the overall success of the Global Enterprise Technology – Corporate Security globally by designing and implementing end to end ETL solutions from data analysis, data modeling to ETL.

Accountabilities

• Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• Build best in class ETL solutions, and will be working closely with Product Owners, Developers, Scrum Masters, Project Management and Stakeholders.
• Analyze highly complex business rules and logic and translating those into technical implementations
• Perform data wrangling to merge disjointed data sources and implement complex data transformation
• Develop ETL process using MS SQL Server BI stack, SQL Server Integration Services and MS Azure Data Factory to ingest, transform, cleanse and load data into on-prem SQL Server 2017, 2019 and/or Azure SQL DB
• Conduct source data analysis and profiling to complete source to target mapping
• Logical and physical data modeling to develop highly optimized data infrastructure for fast querying of large volume of data
  • Assure data quality, security, and compliance requirements are met
• Provide proactive support and maintenance to the existent ETL solutions to keep them at its best of quality
• Take ownership of bugs, defects, enhancements or any assignment end to end
• Understand how the Bank's risk appetite and risk culture should be incorporate into in day-to-day activities and decisions.
• Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabank's Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.
• Champions a high-performance environment and contributes to an inclusive work environment.

Education / Experience / Other Information

• Bachelor's degree in a technical field such as computer science, computer engineering or related field required
• 3 years of experience in designing, developing, and deployment of large-scale data warehouse projects from end to end
• Expert knowledge and hands on experience with SQL Scripting: 3 years
• Expert knowledge working with SQL Server SSIS, Integration Services Catalog and project deployment and Azure Suite – 3 years
• Experience working with Agile methodology – 3 years
• Experience working with BitBucket or TFS, and creating DevOps pipeline (preferred)
• Working knowledge of dimensional data modeling methodology
• Strong English verbal and written communication skills
• Nice to have Skills:
• Experience working with data warehouse within Google Cloud Platform Degrees or certifications
• Experience in Splunk (SPL)
• Power BI
• B1+ level of English.

Working Conditions

Work in a standard office-based environment; non-standard hours are a common occurrence.

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. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at ScotiaTech; however, only those candidates who are selected for an interview will be contacted.