Senior Data Engineer - Media Analytics & AWS Redshift

Publicis Groupe; Bogotá; On-site; COP 194,401,000 - 291,602,000; Full time

Job summary

Publicis Global Delivery, the talent powerhouse of Publicis Groupe, seeks a Senior Data Engineer to design and optimize scalable data solutions supporting analytics and performance reporting. You will work with large datasets, production databases, APIs, and data processing frameworks, partnering with media, development, and research teams to ensure reliable data.

Responsibilities include assembling, processing, and analyzing data at scale, monitoring QA anomalies, maintaining production

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 similar technical role.
• English B2+ or higher.
• Strong SQL skills, including Amazon Redshift or comparable environments.
• Strong knowledge of ETL processes, techniques, and frameworks.
• Proficiency in Python; Java or C++ a plus.
• Hands-on AWS experience (S3, EC2, Redshift, Glue, Athena, Lambda).
• Experience with Tableau for reporting and dashboards.
• Experience with Hadoop, Spark, or similar frameworks.
• Understanding of advanced analytics, data mining, ML, and information retrieval.
• Strong analytical, troubleshooting, and problem-solving skills.
• Strong communication and leadership with cross-team collaboration.

Responsibilities

• Assemble, process, and analyze raw data at scale to support project requirements.
• Monitor data QA anomalies and resolve ingestion issues.
• Revise and adjust infrastructure as needed.
• Maintain production data systems for performance dashboards.
• Collaborate with internal media teams and external dev/research teams.
• Call APIs and write SQL queries across sources.
• Explore industry best practices, data modifications, and governance.
• Select and integrate data processing tools to improve performance.

Skills

SQL proficiency

Leadership

Communication

English proficiency

Python

Java or C++ (plus)

AWS

Tableau

Big data frameworks

Education

Bachelor's or Master's in CS/Data Science/related

Tools

Amazon Redshift

ETL tools

S3/EC2/Redshift/Glue/Athena/Lambda

Tableau

Hadoop/Spark

GCP/BigQuery (preferred)

Databricks/Alteryx (preferred)

Job description

Publicis Global Delivery, the talent powerhouse of Publicis Groupe, seeks a Senior Data Engineer to design and optimize scalable data solutions supporting analytics and performance reporting. You will work with large datasets, production databases, APIs, and data processing frameworks, partnering with media, development, and research teams to ensure reliable data.

Responsibilities include assembling, processing, and analyzing data at scale, monitoring QA anomalies, maintaining production