Data Engineer (Media experience)

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

Company description

Publicis Global Delivery is the talent powerhouse of Publicis Groupe, the largest global communications group. We make sure to hire, boost and develop the best people worldwide to deliver outstanding work for the most prominent clients within the Groupe.

In LATAM, we are over 3.000 passionate employees that love to push boundaries and drive innovative solutions. If you are a risk-taker and love to develop intrepid ideas, PGD is the place for you.

We Move People, and People Move Us!

Overview

This role puts you at the heart of an innovative way of working within Publicis Groupe. It does require fast thinking, highly collaborative, and positive energy, but it will be gratifying for the right person.

As a Data Engineer on the Data Operations team, you are responsible for managing data workflow automation processes. You will be part of a team responsible for developing and delivering our GCP platform. You will support end-to-end workflows while actively collaborating with different internal stakeholders to assess data needs.

Responsibilities

• Drive and advance existing end-to-end workflow processes
• Take ownership of proper 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

Qualifications

Must have skills

• 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, 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.

Nice to have

• Experience building Data Studio / Looker Studio reports.
• Knowledge of Alteryx or other ETL-related tools.
• Familiarity with additional digital advertising platforms beyond Campaign Manager.
• Experience with social media advertising platforms and related tools.
• Knowledge of SA360 (Search Ads 360).
• Broader understanding of digital marketing platforms and marketing performance metrics.
• Advanced Excel expertise beyond core requirements.