Senior Media Analyst

Publicis Groupe Holdings B.V; Chicago (IL); On-site; USD 73,000 - 101,000; Full time

Job summary

Spark Foundry, part of Publicis Groupe, Chicago, seeks a Senior Analyst – Media Data to provide analytic support and strategic recommendations for a client account. You will work with cross-functional teams to define objectives, track metrics, and translate data into actionable insights.

The role requires strong SQL, analytics skills, and experience with paid media data, QA, and large datasets. Collaboration with data engineers is essential in a fast-paced environment.

Qualifications

• 2+ years in analytics within the marketing or media industry, including online media.
• Strong understanding of paid-media data, measurement, and reporting requirements.
• Experience reviewing, validating, or troubleshooting data with attention to QA/QC.
• Strong analytical, critical thinking, and problem-solving skills; able to communicate findings.
• Interest in partnering with data engineers and handling large-scale data environments.
• Experience analyzing large data sets to derive insights and learnings.
• Resourceful with learning agility and adapting to new technologies.
• Ability to work in ambiguous environments and prioritize with limited direction.
• Hands-on SQL experience with multi-table joins, window functions, and data validation.
• Bachelor’s degree in Analytics, Statistic

Responsibilities

• Collaborate with Analytics Manager and media teams to define campaign objectives and key performance indicators.
• Specify data tracking requirements and support measurement systems for accurate data capture and reporting.
• Analyze campaigns to identify insights, support optimization, and inform decisions.
• Serve as a liaison between data engineers, analytics, and media stakeholders to translate requirements into data needs.
• Support data quality assurance processes and coordinate issue resolution across teams.
• Partner with technical teams to understand data workflows and ensure outputs are accurate, complete, and aligned with requirements.
• Develop understanding of paid-media data, taxonomy, and reporting processes.
• Communicate data issues clearly to both technical and non-technical partners across teams.
• Build knowledge on media performance to inform schedules, budgets, partners, and strategies.

Skills

SQL

Analytics

Paid Media

Data Validation

Quality Assurance

Problem Solving

Communication

Python (PySpark)

Big Data

Education

Bachelor’s degree in Analytics, Statistic

Tools

Databricks

Snowflake

PySpark

Job description

Company description

Spark Foundry was built during the most transformative time in the history of advertising and marketing. We deliver everything a traditional media agency has to offer and have grown into one of the world’s most successful agencies by helping brands evolve their marketing by leveraging identity, commerce, artificial intelligence, and more to connect with people. Transformation is part of our DNA. Spark Foundry’s start-up spirit delivers high-touch approaches and a never-ending desire to challenge the status quo. Combined with Publicis Media’s powerhouse soul leveraging connected data assets, advanced AI applications, and investment clout, we “Bring HEAT to Brands.” No other agency possesses the expertise that we do to address today’s most pressing challenges to drive business transformation through media.

Overview

The Senior Analyst – Media Data will provide analytic support and strategic recommendations for one of Spark Foundry’s client 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 media teams to create measurable online and offline campaign objectives and key performance indicators.
• Determine campaign data and tracking requirements and support measurement systems for accurate data capture and reporting.
• Perform ongoing campaign and client-specific analyses to identify insights, support optimization, and inform future media decisions.
• Serve as a key liaison between technical data-engineering resources, analytics teams, and media stakeholders, helping translate business and media requirements into clear data needs.
• Support the implementation and enforcement of data quality assurance and quality control processes, including validating data inputs, identifying discrepancies, and coordinating issue resolution across teams.
• Partner closely with technical teams to understand data workflows, investigate data-quality issues, and ensure outputs are accurate, complete, and aligned with business requirements.
• Develop a detailed understanding of paid-media data, campaign taxonomy, reporting requirements, and the processes through which data moves between platforms and teams.
• Communicate data issues and technical concepts clearly to both technical and non-technical partners, serving as connective tissue across teams with different areas of expertise.
• Build a body of knowledge on media, technology, and strategy performance to inform future decisions related to schedules, budgets, partners, and strategies.

Qualifications

• 2+ years of experience within an analytics function in the marketing or media industry, including experience working with online media.
• Strong understanding of paid-media data and the ability to discuss campaign data, measurement, and reporting requirements fluently.
• Experience reviewing, validating, or troubleshooting data, with strong attention to detail and an understanding of Quality Assurance/Quality Control principles.
• Strong analytical, critical thinking, and problem-solving skills, with the ability to investigate complex issues, identify root causes, evaluate contributing factors, and communicate findings to both technical and non-technical stakeholders.
• Interest in developing deeper technical expertise and partnering closely with data engineers, data workflows, and large-scale data environments.
• Experience analyzing large data sets to develop insights and learnings.
• Demonstrated resourcefulness and learning agility, with the ability to quickly adapt to new technologies, tools, and business domains.
• Ability to work effectively in ambiguous environments, independently prioritize competing demands, and drive solutions with limited direction.
• Strong hands-on SQL experience, including multi-table joins, window functions, aggregations, and data validation across large datasets.
• Bachelor’s degree in Analytics, Statistic

Preferred Qualifications

• Exposure to cloud-based data platforms and data workflow tools such as Databricks, Snowflake, or similar technologies.
• Experience with Python for data manipulation and analysis (PySpark or equivalent), including the ability to read, write, modify, and troubleshoot scripts and notebooks independently.

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.

#LI-EO1

Compensation Range: USD $73,150.00 - USD $101,010.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/23/2026.