Data Engineer: GCP, BigQuery & ETL Automation

Publicis Groupe ANZ; Bogotá; Presencial; COP 60.000.000 - 110.000.000; Jornada completa

Descripción de la vacante

Publicis Groupe ANZ is seeking a Data Engineer to join the Data Operations team. You will manage data workflow automation and contribute to the development and delivery of the GCP platform, supporting end-to-end workflows and collaborating with internal stakeholders on data needs.

The role focuses on building and maintaining the BigQuery data lake, onboarding new data sources, and implementing data governance and quality checks. Strong Python, SQL, and Excel skills are essential.

Formación

• Hands-on experience with 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 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.

Responsabilidades

• Drive and advance existing end-to-end workflow processes.
• Take ownership of data governance and conduct data quality checks in collaboration 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 the data for use in 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.

Conocimientos

Python programming

ETL workflows

SQL databases

BigQuery

Google Cloud Platform (GCP)

Data pipelines

Excel

Herramientas

Looker Studio

Campaign Manager CM360

Alteryx

SA360

Descripción del empleo

Publicis Groupe ANZ is seeking a Data Engineer to join the Data Operations team. You will manage data workflow automation and contribute to the development and delivery of the GCP platform, supporting end-to-end workflows and collaborating with internal stakeholders on data needs.

The role focuses on building and maintaining the BigQuery data lake, onboarding new data sources, and implementing data governance and quality checks. Strong Python, SQL, and Excel skills are essential.