Senior Data Engineer (Media Experience)

About the role

Publicis Global Delivery, the talent arm of Publicis Groupe, is hiring a Senior Data Engineer in Bogota. The engineer designs, maintains and optimises scalable data solutions that support analytics and performance reporting, working with large datasets, production databases, APIs and data processing frameworks alongside media, development and research teams.

Key responsibilities

• Assemble, process and analyse raw data at scale to meet project needs
• Monitor data quality anomalies and fix business-rule issues in ingestion processes
• Adjust infrastructure and keep production database systems running for performance dashboards
• Work with internal media teams and external development and research teams on API calls and SQL queries
• Explore industry best practices, data modifications and governance, and select and integrate data processing tools and frameworks

Required profile

• 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 Amazon Redshift or comparable environments
• Strong ETL knowledge and hands-on AWS experience (S3, EC2, Redshift, Glue, Athena, Lambda)
• Tableau experience for reporting and visualisation
• Experience with large datasets, Hadoop, Spark or similar frameworks, and with data mining, machine learning and information retrieval
• Strong analytical, troubleshooting and communication skills; preferred: GCP/BigQuery, Databricks, Alteryx, RDBMS design and programmatic advertising platform experience