Associate Director, Data & Tech, Quality Control

Business Overview

We are IPG Mediabrands, a client-first, consulting-led, community-driven group of media and marketing specialists around the world on a mission to ensure our clients win in the marketplace. Through our portfolio of brands, and culture of collaboration, we offer the media and marketing capabilities it takes to invest smarter and grow our client’s businesses now and in the future. Through our diverse community of people and leaders, we offer teams of experts who thrive in a culture of excellence and equity. Through our commitment to brand values and media responsibility, we offer leadership to help our clients always act in the best interests of the communities they serve.

Position Summary

The Associate Director of Quality Control for ETL Pipelines will lead the implementation and control of data quality and operations management, to onboard a new cloud-based data storage and visualization tool. This role will assure data is fit for consumption and meets the needs of our data consumers for analytics and media buying.

The successful candidate will manage the complete Extract, Transform and Load process to stand up a DOMO system implementation to support analytics and reporting. This includes developing a governed approach to ensure data from media platforms is fit for purpose based on client requirements, implementing processes to measure, monitor, and report on data quality levels. The candidate will also identify and advocate for opportunities to improve the quality of data through process and system improvements.

Responsibilities

• Troubleshoot and solve complex technical problems related to data integration, data quality and data performance for advertising and media data for Life Science clients.
• Create, maintain and optimize data pipelines, including ETL processes for media data specific to pharmaceutical clients.
• Act as primary liaison with a Life Science client to manage quality control for a cloud-based storage and data analysis platform.
• Work closely with different teams such as client advice, IT, media planning and buying.

Required Skills & Experience

• Mastery of ETL processes, specifically extracting media data from various sources (transforming it to fit analytics and operational needs and loading it into various systems and completion of at least 2 ETL projects using cloud based storage and data analysis platforms like Snowflake or DOMO.
• Strong understanding of database structures, theories, principles, and practices.
• Experience with at least one of the following cloud computing platforms: Amazon Web Services (AWS), Google Cloud Platform (GCP), or Microsoft Azure.
• Strong knowledge of digital data types (1st , 2nd , 3rd party data), and marketing and advertising technologies/partners
• Intermediate to Expert level experience in SQL.
• Strong understanding of data modeling and architecture design including data schemas, and defining how data will be stored, consumed and managed by IT systems.
• Proficiency with Python
• Experience with activation and insights Platforms including: Meta, Demand Side Platforms (DSPs), Google Marketing Platform, etc.

Desired Skills & Experience

• Exposure to data visualization tools such as Tableau, Power BI
• Experience in Life Sciences

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 [email protected].

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.

Salary Range

$115,000 – $135,000 USD

Initiative