Requisition ID: 206960 We are committed to investing in our employees and helping you continue your career at ScotiaTech. Purpose Contributes to the overall success of the Global Wealth Engineering across wealth region ensuring specific individual goals, plans, initiatives are executed/delivered in support of the team's business strategies and objectives. Ensures all activities conducted are in compliance with governing regulations, internal policies and procedures. Accountabilities Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge. Develop ETL code and build packages based on existing standards and suggest improvements when possible. Develop and test code from design specifications, as well as implement and support enhancements to applications. Has some hands-on experience working in an agile environment and knowledge of waterfall as a methodology in team and organization standards. Works in close collaboration with Business Analyst and other cross functional team members in creating design documents, outlining overview, diagrams, technical requirements, and solution that best addresses a business need. Participate in technical discussions, client meetings and presentation of solutions to the technical team members as well as Business. Participate in code review of peers and junior team members and recommend suggestions for improvement where appropriate to ensure high quality product. Assist in production support issues and carry after-hours support phone on a rotational basis. Understand how the Bank's risk appetite and risk culture should be considered 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. Dimensions Approx. 10 to 12 team members (FTE + Cont) Data Integration, ETL, Data Engineering Practice, Data Governance activities 2 to 5 projects on the go at the same time (new, ongoing) IT Risk management, DBR Participation activities E2E SDLC knowledge to have big picture Education / Experience The incumbent must be a creative, self-starting, results-oriented, and highly motivated individual with very good analytical skills to apply this knowledge to assist in the resolution of complex business problems. 2+ years of ETL experience using ETL tools specifically Talend and DataStage. 2+ years reading and writing SQL Queries. 2+ years' experience with relational databases with a good knowledge of SQL Scripting, database structures, principles and design theories are a must have. Willing to learn Cloud Technologies like GCP and Azure. Must have some working knowledge with methods of release Management, change management and code promotion. Bachelor's degree in a technical field such as computer science, computer engineering or related field required. Nice to have experience in Wealth Management industry. 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. Note: All postings in me@Scotiabank will remain live for a minimum of 5 days. #J-18808-Ljbffr