Data Engineer (Media experience)

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

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.