Senior Data Engineer — Media Analytics & Cloud

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

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