Senior Associate, Analytics

Mindshare; New York (NY); On-site; USD 54,000 - 90,000; Full time

Job summary

WPP Media, the AI-driven media operating unit, seeks aSenior Associate, Analytics to support Church & Dwight across social, programmatic, digital, and e-commerce channels.

You will manage three large monthly brand reports, perform data cleansing and QA, and collaborate with internal investment teams to deliver actionable insights. This role offers growth within a large analytics team and a competitive US salary range.

Qualifications

• 1-3 years of relevant work experience in media analytics or a related role.
• Advanced Excel: pivot tables, VLOOKUPs, IF/THEN, and large data handling.
• Data QA, cleansing, validation, and taxonomy QA.
• Strong organizational and time-management skills for multiple projects.
• Familiarity with reporting across social, programmatic, search, and display.

Responsibilities

• Reporting & Analytics: Simultaneously manage and produce 3 large monthly brand reports with campaign wrap-up analyses.
• Data QA & Cleansing: Conduct taxonomy and benchmark validation and fix data discrepancies.
• Project & Stakeholder Management: Coordinate timelines and act as a key contact for internal teams.

Skills

Advanced Excel Proficiency

Data QA & Attention to Detail

Project Management Skills

Cross-Channel Knowledge

Communication Skills

Job description

About WPP Media

WPP is the trusted growth partner for the world's leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships - all united by our pioneering agentic marketing platform, WPP Open - we help clients navigate change, capture opportunity, and deliver transformational growth.

WPP Media is WPP's AI-driven media operating unit, bringing together media, data, and partnerships to deliver creative personalisation at scale. Connected through WPP Open and powered by Open Intelligence, clients see exactly where, how, and why their media investment is working.

For more information, visit wppmedia.com.

Role Summary & Impact

As a Senior Associate, Analytics, you will play a critical role in supporting Church & Dwight, a diverse CPG client and a stable WPP partner. You will be the analytical backbone for a portfolio of iconic brands (including ARM & HAMMER, OxiClean, Trojan, and Batiste), ensuring the accuracy and timeliness of media performance reporting across social, programmatic, digital, and e-commerce channels.

Your primary responsibility will be to manage and produce three large-scale brand reports simultaneously each month. This involves hands-on data cleansing, quality assurance, and collaborating closely with multiple internal investment teams to deliver actionable insights. This position offers a fantastic opportunity to develop robust project management skills, gain deep cross-channel analytics experience, and grow within a large, supportive analytics team.

Key Responsibilities

1. Reporting & Analytics
   • Simultaneously manage and produce 3 large monthly brand reports, creating campaign wrap-up analyses and performance summaries.
   • Aggregate and analyze large datasets from multiple media channels, including social, programmatic, digital investment, and e-commerce (search and display).
   • Utilize advanced Excel functions to manipulate data, create pivot tables, and generate insights for reporting.
2. Data Quality Assurance (QA) & Cleansing
   • Conduct rigorous and detail-oriented QA on campaign data, including taxonomy and benchmark validation.
   • Identify, troubleshoot, and flag data discrepancies (e.g., incorrect placement names, tracking issues) to the respective investment teams for correction.
   • Perform data cleansing and validation to ensure the highest level of accuracy before data is used in client-facing reports.
3. Project & Stakeholder Management
   • Act as a project manager for your reporting deliverables, coordinating staggered timelines and managing internal due dates across multiple teams.
   • Serve as a key point of contact for internal investment teams, communicating data needs and QA findings effectively.
   • Organize and maintain project schedules to ensure timely delivery of reports for internal reviews and client presentations.

Qualifications:

• Experience:1-3 years of relevant work experience in media analytics, data analysis, or a related role, ideally within a media agency.
• Advanced Excel Proficiency (Critical):Mastery of Excel, including pivot tables, VLOOKUPs, IF/THEN statements, and the ability to manage and analyze large, complex datasets.
• Data QA & Attention to Detail:A highly detail-oriented mindset with proven experience in data cleansing, validation, and quality assurance processes (e.g., taxonomy QA).
• Project Management Skills:Strong organizational and time-management skills with the demonstrated ability to manage multiple simultaneous projects and deadlines.
• Cross-Channel Knowledge:Familiarity with reporting and metrics across various media channels (e.g., social, programmatic, search, display).

Communication Skills:Excellent communication and interpersonal skills, with the ability to collaborate effectively with multiple internal teams.

The base salary range for this position at the time of this posting is indicated below. Individual compensation varies based on job-related factors, including location, business needs, level of responsibility, experience, and qualifications. We offer a competitive benefits package, go to https://mybenefits.wpp.com/public/welcome for more details.

US Pay Range $45,000—$90,000 USD

Please read our Privacy Notice for more information on how we process the information you provide.