Company description

Publicis Global Delivery is the talent powerhouse of Publicis Groupe, the largest integral 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 Data Analysis Specialist will transform media and retail data into actionable insights that support campaign measurement, audience strategy, and media planning. This role will work with data from multiple platforms, build scalable reporting and measurement solutions, and collaborate with stakeholders to translate complex data into clear business recommendations

Responsibilities

- Definition and automation of data analysis extracts for media and retail within data clean rooms.
- Creation of a data model enabling the ingestion and consolidation of data from various retail sources for visualization and analysis purposes.

- Collect, clean, and analyze data from various media platforms.
- Work with stakeholders to understand data needs and deliver actionable insights.
- Ensure data accuracy and integrity across all reports, dashboards, and visualizations.
- Critical thinking to analyze data and derive meaningful media insights.




- Communicate findings and recommendations clearly to stakeholders.
- Support media planning initiatives, including tactical and audience planning.
- Assist in knowledge sharing through internal communication events, training, and other written materials.
- Maintain relevant marketing certifications and stay informed of media trends, tools, and methodologies.
- Write queries in clean rooms and other platforms to build custom audiences and measurement models such as Multi-touch attribution, Markov Chain, Incrementality models, etc.
- Support wider agency and client initiatives.
- Show up - be accountable, take responsibility, and get back up when you are down.
- Share so others can see what’s happening

Qualifications

Must have skills:

- English B2+ or higher
- 3 years of experience in Data Analysis
- Advanced knowledge of Python (NumPy, Pandas, cloud SDKs)
- Advanced knowledge of SQL (window functions, DML)
- Knowledge of Data Visualization, in Python and/or with data visualization tools (Power BI, Tableau, Looker

Additional skills:

- Familiarity with Amazon Marketing Cloud (AMC)
- Familiarity with clean room technologies
- Knowledge of a cloud analytics stack (GCP/AWS), ideally GCP:
- Data storage services (data lake & data warehouse), data transfer, data processing, machine learning
- Knowledge of API querying (Python “requests” library, cloud SDKs, Postman)
- Critical thinking and experience with exploratory data analysis

📌 Data Analysis Specialist (Bogotá)
🏢 Publicis Groupe Holdings
📍 Bogotá