Media Analyst

PUBLICIS GROUPE•Minneapolis, MN

56d

About The Position

The Media Measurement and Analytics team supports the planning and investment teams in the measurement, analysis, and actionable insight work for both digital and traditional paid media campaigns. We're looking for a detail-oriented and data-savvy Data Operations Analyst to join our team. This role is ideal for someone who thrives in a fast-paced environment, loves solving data puzzles, and has deep expertise in SQL and Google BigQuery. You'll be the backbone of our data infrastructure-ensuring data integrity, optimizing queries, and enabling teams across the company to make data-driven decisions.

Requirements

2+ years of previous experience in a marketing analytics or business intelligence role.
Proficiency in Word/Excel/PowerPoint/Outlook
Strong written and verbal communication skills
Proficiency in SQL with experience writing complex queries and optimizing performance.
Hands-on experience with Google BigQuery in a production environment.
Experience with data mining and data visualization tools (e.g. Tableau, PowerBI, Google Data Studio, Google Big Query)
Working knowledge of media measurement & analytical tools (e.g. Google/Adobe Analytics, Google Campaign Manager, Facebook Ads, Google Ads, etc.)

Nice To Haves

Knowledge of digital media ecosystems and working knowledge of media buying platforms is a plus

Responsibilities

Develop, maintain, and optimize complex SQL queries and scripts for data extraction, transformation, and loading (ETL).
Work with infrastructure developer to manage and monitor API data pipelines (e.g., Snowflake, The Trade Desk) to BigQuery, ensuring timely and accurate data availability.
Conduct data cleansing and organization to support accurate creative and audience analytics, while maintaining scalable data infrastructures tailored to media content workflows and reports/dashboards.
Perform data quality checks, troubleshoot anomalies, and implement validation processes.
Maintain documentation for data processes, schemas, and workflows.
Support reporting needs by designing, developing, automating and maintaining reports with the aim of generating insights and fixes using BigQuery and connected BI tools (e.g., Looker, Tableau).
Identify opportunities for automation and performance improvements in data operations.
Willingness to fearlessly dive in and conduct analyses across various data sources to find insights and provide actionable recommendations to client and internal teams
Coordinate with team members to aggregate data, design custom reports, and present findings/related insights
Advise on pixel/tagging implementation

Benefits

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume