Data Engineering Specialist
Bogota, DC, CO
Scotiabank
Requisition ID: 200862
We are committed to investing in our employees and helping you continue your career at ScotiaTech.
Purpose
Data Engineers are responsible for the development of ETL jobs that provides/process information to/from businesses within the Bank and its partners. Experts in Azure Data Factory and have an in-depth knowledge on Cloud solutioning and data lineage technologies. Strong skills on SQL Server programming. Solid experience on ETL tools such as SSIS and similar technologies. These professionals are experts in data processes such as aggregating, cleansing and enrichment, lookup and referencing, pivoting and grouping, and process optimization with on-point compliance to security and CAB (Change Admin Board) standards.
Accountabilities
- Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
- 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 Liaise 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.
- DevOps process oriented
- 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.
Reporting Relationships
Primary Manager:
- Data Engineering Lead
Direct Reports:
- N/A
Shared Reports:
- N/A
Dimensions
- Supporting and collaborating within the Global HR Technology teams, businesses within the Bank and its partners.
Education / Experience / Other Information
- Bachelor’s degree in technology and/or engineering course
- 2+ years of solid TSQL programming experience
- Optional: 2 years Azure Data Factory pipeline development experience
- 2 years experience in ETL tools such as SSIS
- Knowledge on Cloud solutions particularly on MS Azure Technologies
- In-depth understanding of modern Datahub and Data warehousing concepts
- Extensive knowledge on ETL standards concerning data security and run time process optimization.
- Result-oriented, highly motivated, have a keen eye to details, and have a very good analytical skills to deliver efficient solutions.
- Curious about technologies, adaptive to changes, a good team player, works efficiently even under pressure, takes ownership of the tasks, and with a good interpersonal and communication skills
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Azure Data quality Data Warehousing DevOps Engineering ETL Security SQL SSIS Testing T-SQL
Perks/benefits: Career development
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Business Intelligence Developer jobs
- Open Data Engineer II jobs
- Open Data Science Manager jobs
- Open BI Analyst jobs
- Open Principal Data Scientist jobs
- Open Business Data Analyst jobs
- Open Data Scientist II jobs
- Open Business Intelligence Engineer jobs
- Open Sr Data Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Lead Data Analyst jobs
- Open Data Science Intern jobs
- Open Sr. Data Scientist jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open Software Engineer, Machine Learning jobs
- Open Data Analytics Engineer jobs
- Open Marketing Data Analyst jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Engineer III jobs
- Open Junior Data Engineer jobs
- Open Data Analyst II jobs
- Open Product Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Data management-related jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Privacy-related jobs
- Open Data pipelines-related jobs
- Open ML models-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open LLMs-related jobs
- Open Data visualization-related jobs
- Open Business Intelligence-related jobs
- Open TensorFlow-related jobs
- Open Deep Learning-related jobs
- Open Consulting-related jobs
- Open Generative AI-related jobs
- Open Data governance-related jobs
- Open NLP-related jobs
- Open CI/CD-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs
- Open Snowflake-related jobs
- Open Git-related jobs
- Open Hadoop-related jobs