Publicis Media is looking to solve the problem of turning complex data into clear, actionable insights that drive smarter decisions for their clients, specifically for a major sporting goods retailer.
Requirements
- Intermediate to advanced Excel skills required (pivot tables, IF statements, joins and lookups, etc.)
- Intermediate to advanced SQL skills required
- Proficiency visualizing data in Microsoft Excel and PowerPoint.
- Familiarity with BI/dashboard tools like Tableau, Power BI, or Google Data Studio strongly preferred.
- Exposure to Google Analytics, Adobe Analytics, Meta Ads Manager or similar platforms is helpful but not required.
- Experience with media metrics or marketing data sources via coursework, internships, or entry-level roles is a plus.
Responsibilities
- Analyze media performance across multiple channels and identify actionable insights.
- Calculate and compare KPIs using dashboards, Excel and other tools to support business reporting.
- Write basic SQL queries to extract data from internal databases.
- Produce campaign performance updates, hindsight reports and ad-hoc analysis.
- Summarize key findings and trends through clear and concise reports and presentations.
- Collaborate with internal teams to identify performance drivers and inform recommendations.
Other
- Bachelor's degree in quantitative, marketing, or communications-related field (e.g., Statistics, Economics, Marketing, Business, Data Science, etc.)
- 1+ year experience working with data sets using Excel and SQL in an academic, internship or professional capacity.
- Strong attention to detail with the ability to QA others’ work as well as your own.
- Ability to communicate effectively with a variety of audiences and management levels.
- Must be able to work in a fast-moving media landscape.
