ETL Develop Lead

Bogotá - Colombia

Monthly Salary: Not Disclosed

Posted on: 22 hours ago

Vacancies: 1 Vacancy

Job Summary

Requisition ID: 244048

Thanks for your interest in ScotiaTech Scotiabanks new and innovative Technology hub in Bogota.

Join a purpose driven winning team that promotes creativity and innovation in a fast-paced environment where were always committed to results in an inclusive diverse and high-performing culture.

The Role

Global Fraud Technology Team is looking for an energetic and results-oriented Senior BI developer with Azure exposure and deep data analysis background to join our team to help build our most innovative Fraud insights and data product.

Were looking to fill our team with influencers makers creators and leaders who are flexible curious adventurous versatile and responsive; and who are ready to roll up their sleeves in a collaborative and productive environment to get things done.

Accountabilities

Accountabilities will consist of release management technical coordination hands-on development and analysis activities

Build best in class BI solutions for the Fraud Analytics Architecture scrum team; working closely with Product Owners Developers Scrum Masters Project Management and Stakeholders to deliver on the product roadmap

Guide and assist team members to deliver optimal solutions through coordination with internal partners and resolution of dependencies

Ensure delivery of negotiated product/function while following BNS standards and methodologies. This includes ensuring proper documentation is created by the team including (but not limited to) design specifications developing programs test strategies peer reviews change control release preparation artefacts for operational readiness and steady state support

Work closely with stakeholders to understand business needs data specifications and translate highly complex requirements into technical design and implementation

Collaborate with data architect ETL development lead and data analysts to design optimal logical and physical data model for fast querying of large volume of data

Develop ETL process using MS SQL Server BI stack and MS Azure Data Factory to ingest transform cleanse and load data into on-prem SQL Server 2017 and/or Azure SQL DB

Develop and execute shell scripts with proficiency in Windows batch scripting.

Conduct source data analysis and profiling to complete source to target mapping

Provide Production Support on current environment and ETL data pipeline

Proven experience in resolving production (PRD) incidents.

Education/Experience

Post-secondary degree in Computer Science Engineering or similar degrees. Certification in Business Intelligence preferred.
You have 5-7 years of experience in working for large projects and have advanced experience with SQL Scripting ETL data analysis and profiling data mapping data modeling data lakes and analytics
You are an expert in dimensional data modeling methodology
You have extensive development experience with SQL Server SSIS Integration Services Catalog and project deployment
You have 57 years of experience in software development using Java and Spring Boot along with hands-on experience in microservices architecture.
You have experience working with an agile scrum team
You have experience working with Azure DevOps pipeline Azure Data Factory and Azure SQL MI
You are excellent in written and spoken English to clearly communicate complex issues and interface with all levels of the organization with ease
You are highly organized disciplined and responsive in a fast paced and demanding environment
You constantly and strongly demonstrate the core values that continuously advance the productivity of high-performing and self-organizing teams: respect commitment courage openness and focus

#LI-HYBRID

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 will remain live for a minimum of 5 days.

Requisition ID: 244048Thanks for your interest in ScotiaTech Scotiabanks new and innovative Technology hub in Bogota.Join a purpose driven winning team that promotes creativity and innovation in a fast-paced environment where were always committed to results in an inclusive diverse and high-performi...