Senior Media Data Insights Lead

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

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.