back to careers


This position serves as the day-to-day Media Analyst for the Mercury Insurance and Arlo media accounts and reports into the 005 (Palisades Business Intelligence Division) Director. This role manages Tableau dashboards, API connections, and performance insights and works closely with discipline experts across the Digital and Strategy teams to formulate these reports. Additionally, there will be opportunities to support 005 department initiatives and other accounts for continued professional development.


  • Design and execute measurement strategies for media programs including but not limited to digital, video (TV, OTT, streaming and social video) strategy and distribution, content partnerships, client data, external studies, internal modeling, and more
  • Manage data ETL from various sources (Google Campaign Manager, Social Platforms, Website Analytics, Billing systems, etc.), validate reports, and publish through established visualizations
  • Develop reports and articulate insights to internal teams
  • Ensure that client-facing and internal reporting is maintained in an accurate fashion
  • Formulate reports from business intelligence platforms, and consumer insights and social listening tools
  • Work closely with team members to keep the agency on the cutting edge of data tools, process, and technology


  • Exposure to business analytics and/or media planning through internships or college studies
  • Hands-on experience with Python or R, and SQL
  • Familiarity with data visualization platforms (Tableau, Datorama, etc.)
  • Solid understanding of basic statistical and mathematical concepts (probability, hypothesis testing, correlation, regression, optimization etc.)
  • Resourceful and action-oriented, with strong organizational, interpersonal, and project management skills
  • Avid learner who is continually growing in their skillset and willing to seek new ways to improve processes
  • Client-facing experience and exposure to AWS are a plus


Apply for this position:

back to careers