Analyst, Campaign Insights

Business Overview

Mediahub is one of the three major global media agencies within IPG Mediabrands with over 1000+ employees worldwide. We are an award-winning agency built for brands who are challenging and disrupting the status quo. Our organization is focused on challenging all facets of media in an environment of rapid change in order to maximize our clients’ investments. We are challenging key fundamentals in the areas of audience creation, purpose, creativity and digital platforms.

Named Media Agency of the Year by Adweek, Ad Age, and Campaign, Mediahub is powered by the buying and intelligence power of Magna Global and the data backbone of Acxiom.

Position Overview

The Campaign Insights team partners with both internal and external stakeholders and data providers, leveraging analytics and measurement to enable optimization of media spending. The Analyst is responsible for gathering and preparing data and conducting analyses using various tools in support of the delivery of analytic solutions. 

The Analyst will have a basic understanding of the digital and media ecosystems including primary channels, digital tracking and large media platforms, and privacy requirements in media tracking.  The position will develop a basic understanding of a client’s industry, business objectives and strategy, media plans, and consumer journey to provide context for analysis and reporting needs.

Responsibilities

• Collaborate with internal/external stakeholders on data logistics – including data specifications, structures, rules, and transfers from numerous media channels and partners.
• Access collected data and thoroughly QC and prepare the data to conduct various analysis and reporting leveraging SQL, Excel, or Tableau
• Exhibit an ability to interpret/synthesize analysis findings and draw insights pertinent to the client’s business.
• Prepare basic report content (Word, Excel, PowerPoint) in support of deliverables.
• Answer questions about data sets and analyses and maintain project documentation.
• Document and articulate steps taken in an analysis to project managers.
• In addition to the execution of projects, begin to participate in project design and planning.

Qualification - Required Skills

• Demonstrated base level of proficiency with at least two of the following tools - SQL, Excel, Tableau
  • SQL - De-duplicate data in database tables using queries, leverage database functions to calculate metrics, and join tables
  • Excel - Use functions such as VLOOKUP, XLOOKUP to correct data, use SUMIFS, SUMPRODUCT, etc. to create reports, and create pivot tables to summarize data.
  • Tableau - Create basic calculated fields and basic visualizations such as tables and bar charts and create dashboards that convey basic information and publish to a Tableau Server
• Working knowledge of MS Office; including PowerPoint, Word and Excel
• Acute attention to detail (QA/QC)
• Strong analytic thought process
• Good verbal and written communication skills
• Motivated and collaborative team player with strong interpersonal skills
• Familiarity with various online and offline media channels
• Mediahub does not require candidates to have a college degree.

Qualifications - Desired Skills

• Up to 2 years of experience (including internships) in a professional services or corporate environment; prior media analytics experience/knowledge desired.
• Advanced degree typically in a quantitative discipline desired.
• Ability to program in other languages such as SAS, SPSS, R and/or Python desired.

We See You  

At IPG Mediabrands, we are unified behind a commitment to fostering a culture of inclusion and belonging. Together, we shine through a set of shared values and behaviors. We take pride in our responsibility to our clients, communities, and to each other. We embrace differences and recognize the unique value that each of us brings to our community.  

We encourage you to apply, as unique backgrounds, perspectives, and lived experiences are welcomed.   

We See You at IPG Mediabrands. 

Wage and Benefits

We offer a Total Rewards package that includes medical and dental coverage, 401(k) plans, flex spending, life insurance, disability, employee discount program, employee stock purchase program and paid family benefits to support you and your family. To give you the ability to better meet your personal needs, and in support of your physical and emotional well-being, you will receive discretionary time off days and company-wide Appreciation Weeks and Wellness Days. 

We also offer a competitive Total Compensation package, including a competitive salary and eligibility for an annual discretionary incentive award or a relevant incentive award. 

The salary range for this position is posted below.  Where an employee or prospective employee is paid within this range will depend on, among other factors, actual ranges for current/former employees in the subject position, market considerations, budgetary considerations, tenure and standing with the Company (applicable to current employees), as well as the employee’s/applicant’s skill set, level of experience, and qualifications.   

Employment Transparency

It is the policy of Mediabrands, division of the Interpublic group, to provide equal employment opportunities to all employees and applicants for employment without regard to race, color, ethnicity, gender, age, religion, creed, national origin, sexual orientation, gender identity, marital status, citizenship, genetic information, veteran status, disability, or any other basis prohibited by applicable federal, state, or local law. 

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. 

The employer will make reasonable accommodations in compliance with the American with Disabilities Act of 1990. The job description will be reviewed periodically as duties and responsibilities change with business necessity. Essential and other job functions are subject to modification. Reasonable accommodations may be provided to enable individuals with disabilities to perform the essential functions.  

For applicants to jobs in the United States: In compliance with the current Americans with Disabilities Act and state and local laws, if you have a disability and would like to request an accommodation to apply for a position with Mediabrands, please email accommodation@mbww.com.

About IPG Mediabrands 

IPG 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, Mediabrands Content Studio, Orion Holdings, Rapport, 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. Learn more at www.ipgmediabrands.com.  

 

•

Last updated on Aug 23, 2024