Senior Analyst, Analytics

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

Company description

Who is Zenith Analytics?

At Zenith, we put data-driven understanding of our clients’ customers first, so we know whom to reach and when to talk to them. And by keeping our finger on the pulse of consumer attitudes and reactions, we know how to keep that conversation on track. That’s at the heart of Live ROI, and it all starts with Analytics.

Why Join the Edgewell Team at Publicis?

This is an opportunity to help shape the future of some of the most recognized brands in personal care while working in a truly integrated environment. At Publicis, our Power of One model brings creative strategy & development, media strategy, commerce, analytics, and activation together as one team. That means you will have a voice earlier in the process, work across disciplines, and help drive business decisions, not just execute against them. You will work on an exceptional portfolio of brands including Schick, Cremo, Banana Boat, Hawaiian Tropic, Billie, Wet Ones, and Jack Black. From reinvigorating iconic brands with fresh thinking and innovative media strategies to accelerating emerging brands and embedding them into culture, the opportunities for impact are significant. And most importantly, we are evolving the client-agency partnership. Together, we are focused on driving real business outcomes, connecting media and commerce performance to growth, and operating as a true extension of the Edgewell team. This is a chance to do meaningful work, influence the future of great brands, and help take the business to the next level.

What does Zenith Analytics do?

Working closely with both the Business Planning and Activation teams, Analytics designs the data strategy to tie our clients’ marketing to real-world business goals. We then mine that data to optimize campaigns and tell the stories that bring our clients closer to their marketing, helping them understand if they’re talking to the people they want, and if they’re doing it the right way.

What does a successful Analyst look like?

We don’t all look the same, and we don’t expect you to, either. But a successful Analyst should share our passion for emerging tech and media, bring a data-driven approach to decision-making, determine a point of view and share it in a positive way, gear up for a challenge, and always crave to learn more and improve. Familiarity with media analytics helps, especially digital media, but isn’t necessarily a requirement. Prior professional experience is highly desired.

What does an Analyst do day-to-day?

The Senior Analysts form the foundation of the Analytics team. They pull and arrange data from a multitude of sources to feed business-improving insights, then build thoughtful presentations and reports that bring the story home to our clients. They work closely with their Associate Director to learn the most efficient and effective ways of wrangling with data as they learn to become full-fledged story tellers.

Responsibilities

• Collect data from various 3rd -party ad servers, like Google Campaign Manager and others, to feed a centralized database Page 2 of 2


• Pull digital media performance data (e.g., programmatic and social) from a centralized database applying SQL


• Clean and analyze the data to derive actionable insights for media performance reports


• Write clear concise PowerPoint presentations summarizing data insights including their outcomes and implications in a straight-forward and actionable way


• Cross-functional team coordination and communication (Advertising Operations, Media Strategy and Investment, Creative Partners, etc.)


• Manage and use our proprietary business intelligence tools (e.g., Power BI, Tableau, Datorama, Looker)

Qualifications

• B.A. or B.S., preferably in Mathematics, Statistics, Computer Science, Data Science, Social Sciences, Business Analytics, Marketing/Advertising or related field


• 2+ years of experience working with large data sets or conducting quantitative analysis


• Advanced Excel (pivot tables, index/match, string parsing formulas)


• Experience working with relational databases, SQL


• Ability to derive insight from data and develop data stories


• Ability to communicate complex ideas to internal clients


• Ability to respond to feedback from internal stakeholders


• Demonstrated strong project management skills


• Attention to detail, proactivity, and dependability

Desired Experience

• Agency experience highly preferred


• Knowledge of digital media, marketing/advertising industries


• Knowledge of digital media metrics (Impressions, Clicks, CTR, CPM, etc.)


• Experience in managing or analyzing online advertising media channels, especially Display, Video, Programmatic, and Social


• Familiarity with ad-servers (e.g., Google Campaign Manager, DSPs, Social platforms)


• Experience with third-party research partners such as Nielsen, ComScore, Millward Brown Digital, GfK, or Dynata


• Experience in BI tools (PowerBI, Tableau, Datorama, Looker)


• Knowledge of basic statistics (descriptive, linear regression)

Additional information

Our Publicis Groupe motto "Viva La Différence" means we’re better together, and we believe that our differences make us stronger. It means we honor and celebrate all identities, across all facets of intersectionality, and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent.

Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.

If you require accommodation or assistance with the application or onboarding process specifically, please contact [e-mail].

All your information will be kept confidential according to EEO guidelines.

Compensation Range

USD $73,150.00 - USD $112,554.00/Annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 11/3/2026.