Data Engineer: GCP, BigQuery & Data Pipelines

Publicis Groupe; Bogotá; On-site; COP 60,000,000 - 100,000,000; Full time

Job summary

Publicis Global Delivery is seeking a Data Engineer to join the Data Operations team in Bogotá. You will manage data workflow automation, support end-to-end ETL pipelines, and contribute to building the GCP platform and data lake.

The role emphasizes data governance, collaboration with stakeholders, and delivering scalable data solutions using BigQuery, Python, and SQL within a fast-paced advertising environment.

Qualifications

• Hands-on Python programming.
• Experience developing ETL solutions and data engineering workflows.
• Strong SQL and database experience.
• Experience with BigQuery.
• Working knowledge of Google Cloud Platform (GCP).
• Ability to create scripts, stored procedures, and manage data pipelines.
• Basic knowledge of the advertising/marketing industry and digital marketing metrics.
• Experience using Campaign Manager (CM360) or understanding its functionality.
• Proficiency in Excel.

Responsibilities

• Drive and advance existing end-to-end workflow processes.
• Take ownership of proper data governance and conduct data quality checks with teams.
• Prepare documentation for workflow automation and new pipeline development.
• Drive the audit process automation to ensure accuracy and efficiency.
• Utilize ETL tools to extract data from data sources, filter, and transform data for reporting and analysis (BigQuery, Python, GCP).
• Develop, deliver, and maintain the BigQuery data lake.
• On-board new data sources to the data lake.
• Collaborate with the project management team for key data operation projects.

Skills

Python programming

ETL workflows

SQL/database

BigQuery

GCP

Data pipelines

advertising knowledge

CM360

Excel

Tools

Looker Studio

Alteryx

CM360

Job description

Publicis Global Delivery is seeking a Data Engineer to join the Data Operations team in Bogotá. You will manage data workflow automation, support end-to-end ETL pipelines, and contribute to building the GCP platform and data lake.

The role emphasizes data governance, collaboration with stakeholders, and delivering scalable data solutions using BigQuery, Python, and SQL within a fast-paced advertising environment.