Senior Analytics Lead, Digital Media Insights

Publicis Groupe; New York (NY); On-site; USD 73,000 - 113,000; Full time

Job summary

Publicis Groupe is seeking a Senior Analyst for Zenith Analytics in New York. The role involves collecting and wrangling data from multiple sources, building data-based insights, and delivering clear storytelling through presentations.

You’ll work with Power BI, Tableau, Datorama, and Looker, collaborating with cross-functional teams to drive business outcomes in marketing analytics. The ideal candidate has 2+ years in data analysis, strong Excel and SQL skills, and the ability to translate

Qualifications

• 2+ years of experience working with large data sets or conducting quantitative analysis.
• Advanced Excel (pivot tables, index/match, string parsing).
• Experience working with relational databases, SQL.
• Ability to derive insight from data and develop data stories.
• Ability to communicate complex ideas to internal clients.
• Demonstrated strong project management skills.
• Attention to detail, proactivity, and dependability.

Responsibilities

• Collect data from various 3rd-party ad servers to feed a centralized database.
• Pull digital media performance data from a centralized database using SQL.
• Clean and analyze data to derive actionable insights for reports.
• Write clear concise PowerPoint presentations summarizing data insights.
• Coordinate and communicate with cross-functional teams (Advertising Operations, Media Strategy, etc.).
• Manage and use BI tools (Power BI, Tableau, Datorama, Looker).

Skills

Advanced Excel

SQL

Data storytelling

Communication

Project management

Attention to detail

Education

Bachelor's degree in Mathematics, Statistics, CS, Data Science, or related field

Tools

Power BI

Tableau

Datorama

Looker

Google Campaign Manager

Job description

Publicis Groupe is seeking a Senior Analyst for Zenith Analytics in New York. The role involves collecting and wrangling data from multiple sources, building data-based insights, and delivering clear storytelling through presentations.

You’ll work with Power BI, Tableau, Datorama, and Looker, collaborating with cross-functional teams to drive business outcomes in marketing analytics. The ideal candidate has 2+ years in data analysis, strong Excel and SQL skills, and the ability to translate