Senior Data Analyst (Media Experience)

Publicis Groupe; Bogotá; On-site; COP 60,000,000 - 90,000,000; Full time

Job summary

Publicis Global Delivery is seeking a Senior Data Analyst to provide analytic support and strategic recommendations for a client account. You will work with the Analytics Manager and media teams, leveraging data to define campaign objectives and measure success across online and offline channels.

Responsibilities include data tracking, ongoing analysis with Excel/Python, and building a knowledge base to guide future media decisions.

Qualifications

• English proficiency at least B2+
• Experience with visualization tools (DV360/CM360/Tableau/Power BI)
• Strong Python and Excel skills
• Experience analyzing large data sets
• Database analysis skills (MS Access/SQL)

Responsibilities

• Work with Analytics Manager and media teams to create measurable online and offline campaign objectives and KPIs.
• Determine campaign data and tracking requirements – manage measurement systems for data capture and reporting.
• Perform ongoing analysis using Excel, Python, and statistics software to optimize campaigns and provide client insights.
• Build knowledge on media, technology, and strategy to inform future media decisions on schedules, budgets, partners, and strategies.

Skills

English proficiency

Python

Advanced Excel

PowerPoint

Data analysis

SQL data analysis

Tools

Datorama

Tableau

Power BI

DV360

CM360

Meta Ads

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 Senior Data Analyst will provide analytic support and strategic recommendations for one of our client's accounts. This position requires an eye for numbers, intellectual curiosity, proficiency at problem solving, a strong command of online media, and an understanding of traditional media. The candidate must be a team player and responsive in a client service environment.

Responsibilities

• Work with the Analytics Manager and the media teams to create measurable online and offline campaign objectives and key performance indicators
• Determine campaign data and tracking requirements – manage measurement systems for data capture and reporting
• Work with the Analytics Manager to perform ongoing analysis using Excel, SPSS, SAS, etc. to ensure the timely adjustment/optimization of campaigns, along with other client-specific analyses (such as campaign analysis, customer segmentation, and profiling and competitive market research)
• Build a body of knowledge on media, technology, and strategy performance with the objective of informing future media decisions on schedules, budgets, partners, and strategies

Qualifications

• English B2+ or higher.
• Datorama experience (preferred) or experience with other visualization tools such as Tableau or Power BI.
• Python
• Online media and digital marketing experience
  • Tools: DV360, CM360, Meta Ads, or similar.
• Advanced Excel skills
• Power Point
• Experience in the analysis of large data sets
• Database analysis skills (eg. MS Access/SQL)