Data Analysis Specialist

Publicis Groupe; Bogotá; Hybrid; COP 36,000,000 - 54,000,000; Full time

Job summary

Publicis Global Delivery in Bogotá, Colombia is seeking a Data Analysis Specialist to transform media and retail data into actionable insights. You will build scalable reporting, work with diverse platforms, and collaborate with stakeholders to translate complex data into clear business recommendations.

The role requires 3+ years of data analysis experience, strong Python and SQL skills, and expertise with Power BI/Tableau/Looker for visualization.

Qualifications

• Fluent English (B2+) or higher.
• At least 3 years of experience in Data Analysis.
• Strong Python knowledge (NumPy, Pandas, cloud SDKs).
• Advanced SQL skills including window functions and DML.
• Experience with data visualization tools (Power BI, Tableau, Looker).

Responsibilities

• Define and automate data analysis extracts for media and retail within data clean rooms.
• Create data models to ingest and consolidate data for visualization and analysis.
• Collect, clean, and analyze data from multiple media platforms.
• Translate data into actionable insights for stakeholders and campaigns.
• Ensure accuracy and integrity of reports, dashboards, and visualizations.
• Support media planning and audience targeting with data-driven insights.
• Share knowledge via internal communications and trainings.

Skills

English proficiency

Data analysis

Python (NumPy, Pandas)

SQL (window functions, DML)

Data visualization (Power BI, Tableau,

Tools

Python

SQL

Power BI

Tableau

Looker

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 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