Title: Reporting Engineer Specialist
Requisition ID: 244209
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 Global Fraud Authentications Technology team develops and manages innovative products designed to support the ever-changing threat landscape. We work in close partnership with our Fraud Authentications Business and key Technology Partners throughout Scotiabank to drive global technology delivery. We are key team members within Global Operations Technology to ensure business strategies, plans and initiatives are executed / delivered in compliance with governing regulations, internal policies and procedures.
Accountabilities
• Designing, building, operationalizing the Customer Profile Database using Google Cloud Platform (GCP) data services such as DataProc, Dataflow, CloudSQL, BigQuery, CloudSpanner in combination with third parties such as Spark, Apache Beam/ composer, DBT, Cloud PubSub, Confluent Kafka, Cloud storage Cloud Functions & Github
• Designing and implementing data ingestion patterns that will support batch, streaming and API interface on both the Ingress and Egress.
• Working with senior data engineers in developing framework and custom code using best practices that will meet the demanding performance requirements
• Working with minimum supervision in designing and building production data pipelines from data ingestion to consumption using GCP services, Java, Python, Scala, BigQuery, DBT, SQL etc.
• Experience using Cloud Dataflow using Java/Python for deploying streaming jobs in GCP as well as batch jobs using text/JSON files and writing them to BigQuery
• Building and managing data pipelines with a deep understanding of workflow orchestration, task scheduling and dependency management
• Ability to do proof of technology using GCP technologies and work with data architects, solution architects to achieve the desired results and performance.
Reporting Relationships
Primary Manager: -
Direct Reports: NA
Shared Reports (solid/dotted if applicable): NA
Dimensions NA
Education / Experience / Other Information (include only those that are specific to the role)
• 2+ years of experience in data engineering, performance optimization for large OLTP applications with a minimum of 4+ years of working experience as Google Cloud Platform (GCP) developer
• Experience with the primary managed data services within GCP, including DataProc, Dataflow, BigQuery/DBT, Cloud Spanner, Cloud SQL, Cloud Pub/Sub etc.
• Experience with Google Cloud Platform Databases (SQL, Spanner, PostgreSQL)
• Experience working with relational/NoSQL databases
Competencies
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.
Job Segment:
Database, SQL, Java, Developer, Engineer, Technology, Engineering