Responsibilities

• Support in the development of competitive media insights through strategic analyses and performance reports. This includes large data set management, creating automated and semi-automated data cuts for faster analysis and building digestible visualizations of the data/analyses for executive client presentations.
• Monitor, track, analyze and report on competitive media performance and industry trends that identify issues and/or proactively lead to marketing ideas, opportunities and potential strategies and solutions.
• Ongoing analysis of primary and secondary research to develop a strong understanding of our clients’ marketplace and competitive environment.
• Ongoing support for client ad-hoc requests with critical deadlines.

Requirements

• 3+ years of experience working in data analytics or related role
• Media agency or ad agency experience REQUIRED
• Strong technical literacy and the ability to quickly pick up new tools and data platforms.
• Thrives in a fast-paced environment and can juggle multiple priorities without sacrificing quality.
• Ability to clearly communicate technical data analysis to marketing generalists.
• Understanding of media strategy and performance measurement, including comfort with core media metrics such as share of voice (SOV), share of impressions (SOI), and share of market (SOM).
• Tableau (or similar): setting up data sets and building clear, insightful visualizations and dashboards
• Excel: comfortable working with pivot tables, advanced formulas, and large data sets
• PowerPoint: building polished, executive-ready presentations
• SQL: writing queries to pull and/or transform data

Preferred

• Automotive experience preferred
• Bonus: experience with forecasting and modeling

Benefits

• Access to our health benefits after 91 days
• Paid sick days
• 401k match
• On-site Barista
• Beautiful campus across from the Pacific Ocean