Senior Analyst, Data Management & Visualization

Business Overview

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.

Position Overview

The Senior Analyst, Data Management position works within the Data Management team and manages the media performance data setup, maintenance and troubleshooting across a set of Mediahub clients. This role will be providing analytic direction to support clients and help guide more junior analysts to improve our clients' marketing programs as well as leading project/analysts. They will support all aspects of data processing for subsequent analysis and performance reporting. The Sr. Analyst, Data management collaborates with clients and internal teams to manage data logistics - including data specifications, structures, rules and transfers from numerous media channels and partners providing valuable insights to the Mediabrands team.

Responsibilities

• Understand our clients' digital and non-digital media ecosystems including challenges of data tracking with cookies/SDK's, website tagging options, impact of walled gardens, and basic TV and OOH measurement and attribution options available.
• Collaborate with internal/external stakeholders to manage data logistics - including data specifications, structures, rules and transfers from numerous media channels and partners. Proactively identify and communicate barriers to complete work requirements.
• Assist in the development of SQL stored procedures, views, functions, performance tables, and well-tuned queries. Analyze and profile data contained in relational databases using both SQL query language and DBMS business tools.
• Collaborate in the development of dynamic reports that enable end users to define numerous parameters that allow users to filter and aggregate data as required. Create custom reports that allow end users to drill down on dimensions for more detail.
• Monitor and manage data quality processes and data integrations. Perform corrective and evolutive maintenance of all the data exchange and data solution processes. Make sure the data platforms and processes are running well, both in data collection, integration and processing.
• Collaborate with internal/external stakeholders to manage data logistics - including data specifications, structures, rules and transfers from numerous media channels and partners. Proactively identify and communicate barriers to complete work requirements.
• Coach, guide and support analysts of data management and insights analysts. Make sure that knowledge transfer flows in both directions, establish the protocols to guarantee knowledge transfer.

Qualification - Required Skills

• Higher level of proficiency with the following tools - SQL, Excel, Adverity, Domo, Talend.
• Demonstrate a good level of proficiency with SQL as evidenced by the ability to:
  
  
  
  • Execute advanced SQL queries and Stored Procedures to process and automate data.
  • Optimize query performance, improve processes, diagnosis problems.
  • Implement best-practices on database schemas and ETL processes using Talend ETL suite.
  
  
  
  
• Experience with ad-serving platforms such as Google Campaign Manager; web analytics tools such as Google Analytics and Adobe Analytics, and tag management tools such as DTM/Launch, GTM and Tealium.
• Excellent verbal and written communication skills.
• Familiarity with various online and offline media channels.
• Prior media analytics experience/knowledge.
• Greater ability to program in Python and Java.
• Mediabrands does not require candidates to have a college degree

Qualifications - Desired Skills

• Bachelor's Degree in Statistics, Economics or related quantitative field; advanced degree in a quantitative discipline preferred.
• 1+ years of experience in a professional services or corporate environment, preferably an agency.
• Familiarity with media mix modeling and other forms of regression-based ROI; A/B and multivariate test design.

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.

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.

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.