Senior Data Engineer (Media Experience)

Publicis Groupe; Bogotá; Hybrid; COP 90,000,000 - 180,000,000; Full time

Job summary

Publicis Global Delivery is seeking a Senior Data Engineer to design, maintain and optimize scalable data solutions supporting analytics and dashboards. You will work with large datasets, production databases, APIs, and data processing frameworks while partnering with media, development, and research teams to ensure high-quality data.

The ideal candidate has 4+ years in data engineering, strong SQL (Redshift or equivalent), Python (Java/C++ a plus), and hands-on AWS experience plus Tableau for

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Computer Engineering, Data Science, or a related field.
• 4+ years of experience in Data Engineering or a similar technical role.
• English B2+ or higher.
• Strong SQL skills, including experience with Amazon Redshift or comparable advanced SQL environments.
• Strong knowledge of ETL processes, techniques, and frameworks.
• Proficiency in Python; experience with Java or C++ is a plus.
• Hands-on experience with AWS services (S3, EC2, Redshift, Glue, Athena, Lambda).
• Experience with Tableau for reporting, dashboarding, and data visualization.
• Experience processing, integrating, and analyzing large datasets from multiple sources.
• Experience with Hadoop, Spark, or similar large-scale data processing frameworks.
• Understanding of advanced analytics, data mining, machine learning, and information retrieval.
• Strong analytical, troubleshooting, and problem-solving skills.
• Strong communication and leadership skills, with the ability to collaborate with multiple teams and agencies.

Responsibilities

• Assemble, process, and analyze raw data at scale to support different project requirements.
• Monitor for data QA anomalies and solve business-rules related issues in ingestion processes.
• Revise and adjust infrastructure where required.
• Maintain the data base production systems for performance dashboards.
• Work closely with internal business media teams.
• Work with external development and research team for calling APIs, and writing SQL queries.
• Explore new ideas from industry best practices, data modifications and governance.
• Select and integrate required data processing tools and frameworks to improve performance.

Skills

SQL

Python

AWS

Tableau

Hadoop/Spark

English (B2+)

Java/C++ (plus)

Education

Bachelor’s or Master’s degree in CS/CE/Data Science or related field

Tools

Amazon Redshift

S3

EC2

Redshift

Glue

Athena

Lambda

Tableau

GCP/BigQuery

Databricks

Alteryx

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

The Senior Data Engineer will design, maintain, and optimize scalable data solutions that support analytics and performance reporting. This role will work with large datasets, production databases, APIs, and data processing frameworks while partnering with media, development, and research teams to ensure reliable and high-quality data.

Responsibilities

• Assemble, process, and analyze raw data at scale to support different project requirements


• Monitor for data QA anomalies and solve business-rules related issues in ingestion processes


• Revise and adjust infrastructure where required


• Maintain the data base production systems for performance dashboards


• Work closely with internal business media teams


• Work with external development and research team for calling APIs, and writing SQL queries


• Explore new ideas from industry best practices, data modifications and governance


• Select and integrate required data processing tools and frameworks to improve performance

Qualifications

Minimum Requirements

• Bachelor’s or Master’s degree in Computer Science, Computer Engineering, Data Science, or a related field.


• 4+ years of experience in Data Engineering or a similar technical role.


• English B2+ or higher.


• Strong SQL skills, including experience with Amazon Redshift or comparable advanced SQL environments.


• Strong knowledge of ETL processes, techniques, and frameworks.


• Proficiency in Python and strong coding practices. Experience with Java or C++ is a plus.


• Hands-on experience with AWS, particularly services such as S3, EC2, Redshift, Glue, Athena, and Lambda.


• Experience with Tableau for reporting, dashboarding, and data visualization.


• Experience processing, integrating, and analyzing large datasets from multiple sources.


• Experience with Hadoop, Spark, or similar large-scale data processing frameworks.


• Understanding of advanced analytics, data mining, machine learning, and information retrieval.


• Strong analytical, troubleshooting, and problem-solving skills.


• Strong communication and leadership skills, with the ability to collaborate with multiple teams and agencies and support complex analytical initiatives.

Preferred Qualifications

• Experience with Google Cloud Platform (GCP) and BigQuery.


• Experience with Databricks and Alteryx.


• Knowledge of RDBMS, data warehouse design, and data lake environments.


• Experience integrating data from multiple internal and third-party sources.


• Strong project management and technical troubleshooting capabilities.


• Ability to investigate and resolve complex data, software, and networking issues.

Media & Advertising Platform Experience

Experience with the following platforms is a plus.

• Ad Servers: Flashtalking, Innovid, Campaign Manager 360 (CM360), including exposure to creative-level versioning or dynamic creative.


• Social: Meta Business Manager, TikTok Business Manager, Pinterest Ads, Snap Ads, Reddit Ads Manager, and Sprinklr.


• Search: Google Ads and Search Ads 360 (SA360).


• DSPs / Programmatic: The Trade Desk, Amazon DSP, and Display & Video 360 (DV360).