Senior Analyst
Client Solutions, Analytics
Posted on 9/8/2023
Mediabrands

10,001+ employees

Advertising Services
Company Overview
PG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). IPG Mediabrands manages over $47 billion in marketing investment globally on behalf of its clients across its full-service agency networks UM, Initiative and Mediahub and through its award-winning specialty business units Healix, Kinesso, MAGNA, Matterkind, Mediabrands Content Studio, Orion Holdings, Rapport, Reprise, and the IPG Media Lab. IPG Mediabrands clients include many of the world’s most recognizable and iconic brands from a broad portfolio of industry sectors including automotive, personal finance, consumer product goods (CPG), pharma, health and wellness, entertainment, financial services, energy, toys and gaming, direct to consumer and e-commerce, retail, hospitality, food and beverage, fashion and beauty. The company employs more than 18,000 diverse marketing communication professionals in more than 130 countries.
Locations
United States
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
Data Analysis
SQL
Tableau
PowerPoint/Keynote/Slides
Communications
CategoriesNew
Product
Requirements
  • Strong proficiency across the following platforms: Excel, PowerPoint, SQL, Tableau and VBA
  • Experienced in effective dashboard designing with a focus on customizing to client needs
  • Initiative does not require candidates to have a college degree
Responsibilities
  • Provide meaningful insight for internal stakeholders as well as clients regarding areas such as brand health, cross-channel synergy, paid/owned/earned media, and consumer behavior
  • Manipulation and analysis of large datasets from multiple sources, including proprietary agency analytics platform
  • Summarizing advertising measurements such as reach and frequency, engagement rate, viewability, and fraud
  • Accurately evaluate the effectiveness and performance of paid campaign advertising
  • Develop and maintain dashboards, including the creation of charts or other visualizations through Tableau or other Business Intelligence platform to illustrate campaign performance
  • Contribute to monthly and quarterly client reports by analyzing data and providing data visualizations and insights and key takeaways that illustrate campaign performance in a compelling, clear and concise way
  • Manage ad hoc data requests, both internal and external
  • Coordinate Advertising Operations, Digital Partnerships, and Paid Search for campaign trafficking and quality assurance
Desired Qualifications
  • 0-1+ years of experience, media/advertising industry a
  • Experience with digital media measurement and reporting platforms preferred as well as programming languages
  • Proficient in Microsoft suite of products particularly PowerPoint and Excel, including advanced knowledge of PivotTables and complex formulas
  • Ability to digest and explain complex ideas to a diverse group of stakeholders
  • Ability to collaborate across teams to produce strong insights to advance reporting and client deliveries
  • Ability to work under pressure and manage multiple priorities
  • Strong communication and presentation skills equally capable of interacting with peers and senior management
  • Must be a team player
  • Have an innate curiosity for processes improvements