Senior Analyst, Data Science

Zenith is one of Publicis Groupe’s largest media agencies, spanning 95 markets globally with US offices in New York, Burbank, Chicago, Atlanta and Detroit. For over 30 years, we’ve been at the forefront of media, helping to evolve and reshape the industry. We partner with high-profile brands for our expertise across numerous categories and unparalleled capabilities, including strategic planning, investment, measurement, content, commerce, multicultural, and future-proofed data solutions.

About the role

The Senior Analyst transforms complex media and audience data into actionable insights through data wrangling, exploratory analysis, and workflow automation. This role partners closely with Analytics, Strategy, Activation, and Data Science teams to solve business problems, develop scalable analytical solutions, and improve the efficiency of recurring processes. The ideal candidate combines strong technical skills in SQL and Python with deep familiarity with digital media datasets and taxonomies.

Responsibilities

• Develop complex SQL and Python-based solutions to prepare, transform, and analyze large media and audience datasets.
• Perform ad hoc analyses to answer business, client, and campaign performance questions.
• Build and maintain reusable datasets that support reporting, analytics, and strategic decision-making.
• Design and automate recurring analytical processes and workflows to improve efficiency and scalability.
• Work extensively with media taxonomies and reporting dimensions including channel, publisher, DSP, creative size, placement, audience, and daypart.
• Identify data quality issues and implement processes to improve consistency and reliability across datasets.
• Collaborate with stakeholders to translate ambiguous business questions into analytical approaches and recommendations.
• Present findings and insights to both technical and non-technical audiences.
• Document analytical methodologies, data definitions, and workflow processes to support long-term team scalability.

Requirements

• 2+ years of experience in Analytics, Data Engineering, Marketing Analytics, Media Analytics, or a related field.
• Advanced proficiency in SQL and Python.
• Strong experience manipulating, transforming, and analyzing large datasets.
• Experience building automated workflows, reusable analytical tools, and scalable data processes.
• Required experience working with digital media data and media taxonomies.
• Experience with PySpark and cloud-based data environments (Databricks, Snowflake, etc) preferred.
• Strong problem-solving skills and ability to work independently in ambiguous environments.
• Excellent communication and presentation skills.

Benefits

• Medical, dental, and vision coverage.
• Disability insurance.
• 401K retirement plan.
• Parental and family care leave.
• Family forming assistance.
• Tuition reimbursement.
• Flexible time off.

Pay

USD $73,150.00 - USD $112,554.00/Annually.