Senior Data Engineer — BigQuery, ETL & APIs (Hybrid)

SAMY Latam; Bogotá ciudad; Presencial; COP 120.000.000 - 240.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible schedule

Hybrid work

3 weeks per year to work from any SAMY

Birthday off

Descripción de la vacante

SAMY Latam in Bogotá is seeking a Senior Data Engineer to design, build, and optimize scalable data solutions that empower business decision‑making. You will own data pipelines, ETL/ELT processes, and data models within the Google Cloud Platform to ensure data quality, availability, and performance across teams.

Collaborating with Analytics, BI, and Engineering, you will integrate multiple data sources using Fivetran and BigQuery, write Python scripts for data ingestion, and continuously improve

Formación

• 5+ years of experience as a Data Engineer or similar role.
• Strong hands-on experience with Google BigQuery.
• Advanced SQL skills, including complex transformations and query optimization.
• Experience developing Python scripts for API integrations and data ingestion.
• Solid experience designing and maintaining ETL/ELT pipelines.
• Experience with data integration tools such as Fivetran, Supermetrics, or similar.
• General knowledge of the Google Cloud Platform (GCP) ecosystem.
• Strong understanding of Data Warehousing concepts.
• Experience with dimensional data modeling, including Star Schema and Snowflake Schema.

Responsabilidades

• Develop and optimize complex SQL queries for data transformation and analysis.
• Design and maintain Data Warehouse models.
• Develop Python scripts to ingest data from APIs.
• Automate data ingestion, transformation, and validation processes.
• Manage and optimize large datasets using Google BigQuery.
• Integrate multiple data sources using tools such as Fivetran, Supermetrics, or similar platforms.
• Ensure data quality, consistency, and reliability across data pipelines.
• Collaborate with Analytics, BI, and Engineering teams to deliver scalable data solutions.
• Identify opportunities to improve data architecture, performance, and operational efficiency.

Conocimientos

Strong SQL

Google BigQuery

Python

ETL/ELT design

Data modeling

Data integration tools

GCP knowledge

Data warehousing concepts

Star/Snowflake schema

Herramientas

Google BigQuery

Fivetran

Supermetrics

Python

Descripción del empleo

SAMY Latam in Bogotá is seeking a Senior Data Engineer to design, build, and optimize scalable data solutions that empower business decision‑making. You will own data pipelines, ETL/ELT processes, and data models within the Google Cloud Platform to ensure data quality, availability, and performance across teams.

Collaborating with Analytics, BI, and Engineering, you will integrate multiple data sources using Fivetran and BigQuery, write Python scripts for data ingestion, and continuously improve