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
Related jobs:
Event Staff & Vendor Casting for Music Festival
Job Description
Seeking event staff and vendor types for a major music festival. This is a great opportunity for individuals who enjoy working in a fast-paced, energetic environment.
Job Responsibilities
- Assist with event operations and logistics
- Work with vendors and festival teams to ensure smooth operations
- Provide excellent customer service to attendees
- Perform assigned tasks as directed by event managers
Requirements
- Ages 18-35
- Must be a fresh face (no prior participation in this event)
- All ethnicities and genders welcome
- Reliable and professional attitude
- Comfortable working in a high-energy festival environment
Compensation
- $150 for 12 hours
- Filming takes place in Fayetteville, GA
Casting Call for Court Reporter/Stenographer – Film Production Opportunity
Job Description
A film production is seeking a professional court reporter/stenographer for an upcoming project. This is a great opportunity for individuals with experience in legal transcription to be featured in a production setting. If you have the skills and professional equipment, this role offers competitive pay and industry exposure.
Job Responsibilities
- Portray a court reporter/stenographer in a film production
- Utilize professional stenography equipment to enhance authenticity
- Follow directions from the production team for scene accuracy
- Maintain a professional demeanor on set
Requirements
- Must have experience as a court reporter or stenographer
- Own professional stenography equipment
- Available for a full-day shoot
- Comfortable working in a film production environment
Compensation
- $350 for 12 hours
- Industry exposure and networking opportunities
Casting Call: Experienced Casting Assistant for 5-Week Gig
Job Description:
A leading casting company is seeking an experienced Casting Assistant to join the team for a five-week gig. This role requires a hardworking professional with strong organizational skills, attention to detail, and a great sense of humor. The ideal candidate must be proficient in breakdowns, Eco Cast, video editing, and scheduling.
Job Responsibilities:
- Manage breakdowns and submissions efficiently
- Use Eco Cast to upload, edit, and organize audition videos
- Create detailed schedules and manage casting logistics
- Draft deal memos and maintain casting records
- Collaborate with the casting team to ensure a smooth workflow
Requirements:
- Previous experience as a Casting Assistant
- Proficiency in Eco Cast, breakdowns, and video editing
- Strong organizational and time management skills
- Attention to detail and ability to multitask in a fast-paced environment
- Excellent communication skills and a team-oriented mindset
Compensation:
- $800 per week
- Opportunity to work with a reputable casting team and gain industry experience
Assistants and Experienced Managers Needed
Job Description:
A leading agency is seeking dynamic Assistants and seasoned Managers to join their professional team. This is a great opportunity to work in a fast-paced, creative environment with a reputable agency in the entertainment industry.
Job Responsibilities:
- Support day-to-day operations of the agency
- Manage schedules, appointments, and correspondence
- Coordinate with clients, talent, and other industry professionals
- Provide administrative support and oversee project management
Requirements:
- Strong organizational and communication skills
- Previous experience in management or administrative support preferred
- Ability to multitask and work under tight deadlines
- Passion for the entertainment and modeling industries
Compensation:
- Competitive salary based on experience (details provided upon selection)
Freelance Casting Assistant
Exciting opportunity for a Freelance Casting Assistant in Dallas, Texas! Seeking a detail-oriented and motivated individual to join a dynamic casting team ASAP.
Job Responsibilities
- Assist with organizing and coordinating casting calls
- Communicate with talent and industry professionals
- Maintain casting databases and documentation
- Support casting directors in administrative and creative tasks
Requirements
- Must be based in Dallas, TX
- Strong organizational and communication skills
- Ability to work efficiently in a fast-paced environment
- Prior experience in casting or production is a plus
Compensation
- Competitive freelance rate
- Flexible work schedule
Hiring: Casting Assistants, Bookers, and Interns – Remote & NY-Based Preferred
Seeking experienced bookers, part-time assistants, and interns to support casting direction and talent management. These positions offer an opportunity to work in a fast-paced, creative environment, helping with talent coordination, industry communication, and organizational tasks.
Job Responsibilities
- Assist in casting coordination and talent management
- Communicate effectively with clients and industry professionals
- Manage administrative tasks and scheduling
- Maintain organization within casting projects
- Support booking and talent submissions
Requirements
- Highly organized and detail-oriented
- Strong communication and people skills
- Passionate about the entertainment industry
- Ability to manage multiple tasks efficiently
- Prior experience required for non-intern roles
- New York-based preferred, but remote opportunities available
Compensation
- Competitive pay based on experience
- Flexible remote work options for select positions