Data Engineer, International Banking Analytics

Scotiabank; Bogotá ciudad; Presencial; COP 120.000.000 - 180.000.000; Jornada completa

Descripción de la vacante

Scotiabank is seeking a Data Engineer for International Banking Analytics to design and implement data pipelines and data models for BI and advanced analytics. You will collaborate with analytics and business teams to improve data accessibility and enable data-driven decisions, while ensuring governance, risk controls, and regulatory compliance.

The role requires hands-on coding with SQL, PySpark, Pandas and experience with BigQuery, Airflow, and cloud platforms.

Formación

• 3-6+ years experience as a Data Engineer or Technical Business Analyst.
• Bachelor’s degree in Computer Science, Engineering, or related field.
• Strong proficiency in Cloud computing, Data Quality and Governance.
• Proficiency with SQL, Python and Spark; BigQuery experience is essential.

Responsabilidades

• Design and implement data pipelines and data models for BI and analytics.
• Collaborate with analytics and business teams to improve data accessibility.
• Write and optimize code with SQL, PySpark, and Python.
• Ensure compliance with regulations, policies and risk controls.
• Work with Airflow for scheduling and orchestration; optimize performance.

Conocimientos

SQL

Python

Spark

BigQuery

Cloud computing

Data modelling

Agile

DevOps

Communication

Pandas

Educación

Bachelor's degree in Computer Science or Engineering

Herramientas

BigQuery

Airflow

Databricks

GCP

Hadoop

MinIO

Presto/Trino

Juipter Hub

Descripción del empleo

Data Engineer, International Banking Analytics

Purpose

Contributes to the overall success of the development of critical data assets/data models serving International Banking Analytics. The Data Engineer will be responsible for architecting, designing, and implementing data pipelines and data bases to be consumed for business intelligence and advanced analytics applications. Ensures all activities conducted are following governing regulations, internal policies and procedures.

Accountabilities

• Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• Functions as member of an agile team and helps drive consistent development practices, tools usage, common components, and patterns.
• Collaborates with analytics and business teams to build and improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.
• Direct the identification and recommendation of appropriate solutions.
• Performs hands-on design and development with SQL/Bigquery/PySpark/Pandas, Parquet files, Warehousing experience preferably with object storages and Airflow scheduling / orchestration and Big Query
• Spends significant amount of time writing code and testing.
• Works with the team to optimize code execution.
• Skilled with dimensional modeling and devops processes
• 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.
• Strong verbal and written communication skills, capable of conveying ideas clearly, concisely, and appropriately to different audiences.

Education / Experience / Other Information

• 3-6+ years experience working as a Data Engineer or Technical Business Analyst.
• Bachelor’s degree in Computer Science or Engineering, or related field or relevant experience.
• Strong proficiency in Cloud computing, Data Quality and Governance.
• Strong proficiency in GCP- NH (databricks), SQL, Python and Spark.
• Data modelling, Datalake and warehousing experience would be a plus
• Proficiency with relational databases (Oracle, DB2, Redshift, etc.)
• Proficiency with Big Query

Assets

• Experience with Big Data and Cloud Technologies (GCP, Hadoop, MinIO,Presto/Trino, Juipter Hub, AirFlow)
• Experience working in Retail/Risk Banking Domain is an asset
• Experience working in an Agile team environment

Working Conditions

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