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:
Studio Assistant for Creative Projects
Looking for a detail-oriented and organized Studio Assistant to support a dynamic creative team. This is an excellent opportunity to be part of exciting, high-profile projects and gain valuable industry experience.
Responsibilities
- Assist in day-to-day studio operations, including scheduling and organization.
- Maintain studio equipment and ensure all tools are ready for use.
- Support team members during creative sessions and project execution.
- Handle administrative tasks such as coordinating meetings and maintaining files.
- Foster a positive and efficient work environment.
Requirements
- Strong organizational skills and attention to detail.
- Ability to multitask and prioritize in a fast-paced environment.
- Excellent communication and interpersonal skills.
- Familiarity with creative processes and studio operations is a plus.
Compensation
- Competitive pay and potential growth opportunities within the team.
- Chance to work closely with industry professionals on innovative projects.
Designers for Creative Projects
Seeking innovative and skilled Designers to join a dynamic team working on cutting-edge creative projects. This is your chance to bring bold ideas to life and shape unique visual narratives in a collaborative environment.
Responsibilities
- Develop creative concepts and designs for a variety of high-profile projects.
- Collaborate with architects, engineers, and project leads to execute cohesive visions.
- Produce sketches, layouts, and final designs that align with project goals.
- Stay up-to-date on industry trends and integrate fresh ideas into projects.
Requirements
- Proven experience in design with a strong, diverse portfolio.
- Expertise in design software such as Adobe Creative Suite or equivalent tools.
- Ability to think creatively and deliver visually stunning results.
- Strong attention to detail and excellent communication skills.
Compensation
- Competitive pay based on skills and project contributions.
- Opportunity to work on influential, creative projects with a collaborative team.
Architects for Innovative Design Team
Seeking talented and visionary Architects to join a groundbreaking team working on high-profile creative projects. This is an opportunity to bring bold ideas to life in a collaborative and forward-thinking environment.
Responsibilities
- Design and develop architectural concepts for innovative projects.
- Collaborate with designers and project leads to execute creative visions.
- Prepare detailed drawings, plans, and models using industry-standard tools.
- Ensure designs align with project requirements, timelines, and regulations.
Requirements
- Proven experience in architecture with a strong portfolio of creative work.
- Proficiency in CAD software and architectural design tools.
- Strong understanding of design principles and construction processes.
- Ability to think critically and bring unique solutions to complex challenges.
Compensation
- Competitive pay based on experience and project contributions.
- Opportunity to work on impactful, innovative projects.
AI Engineers Wanted for Innovative Creative Projects
Join an elite creative team as an AI Engineer, contributing to cutting-edge projects across art, technology, and design. This role is perfect for AI specialists passionate about merging innovation with creativity.
Job Responsibilities
- Design and implement AI-driven solutions for creative and technical challenges.
- Collaborate with a multidisciplinary team, including designers, architects, and editors.
- Optimize algorithms for efficiency and scalability across various platforms.
- Stay updated on AI trends to implement innovative technologies into projects.
Requirements
- Strong background in AI development, machine learning, and programming.
- Experience in developing AI systems for creative applications is a plus.
- Excellent problem-solving and teamwork skills.
- Must provide a portfolio and CV showcasing past projects and achievements.
Compensation
- Competitive salary and opportunities to work on groundbreaking projects.
- Collaborate with industry leaders in an inspiring environment.
- Potential for long-term career growth in an innovative team.
Assistant Needed for Event in Miami
An exciting opportunity is available for a reliable assistant to support an event in Miami, FL. This is a one-day role, offering a chance to gain hands-on experience in a professional environment.
Job Responsibilities:
- Provide general assistance during the event.
- Support event coordinators and ensure smooth operations.
- Perform assigned tasks efficiently and professionally.
Requirements:
- Dependable and organized individual.
- Comfortable working in a fast-paced event setting.
- Ability to follow instructions and adapt to on-the-spot changes.
Compensation:
- $18/hour for the event.
- Gain valuable experience in event support.
- Work with a professional team in a dynamic environment.
Lower & Mid Hudson Valley Film Crew Jobs
We’re seeking skilled, passionate local talent for a heartfelt short film production. This SAG project tells a touching story of female friendship, loss, and the power of a home-cooked meal. It’s a 3-day shoot requiring dedicated professionals ready to contribute their expertise.
Job Responsibilities:
- Collaborate effectively to bring a compelling story to life.
- Deliver high-quality work within your specialized role.
- Maintain professionalism and adaptability on set.
Requirements:
- Experience in your field with a strong work ethic.
- Availability for the entire 3-day shoot.
- Based in or willing to work in the Lower & Mid Hudson Valley region.
Compensation:
- Competitive pay based on role.
- Opportunity to work on an SAG production.
- Gain valuable experience and expand your network in the film industry.
Social Media Internship Opportunity
We are seeking a passionate and creative individual to join our team as a social media intern. This is a fantastic opportunity to gain hands-on experience in social and digital content creation while working with an innovative brand.
Job Responsibilities:
- Assist in managing and creating content for various social media platforms.
- Collaborate with the team to develop engaging social media campaigns.
- Monitor analytics to measure engagement and provide insights for optimization.
- Stay updated on current social media trends to ensure relevance and innovation.
Requirements:
- Strong interest in social media and digital marketing.
- Creativity and an eye for detail.
- Excellent written and verbal communication skills.
- Ability to work independently and collaboratively in a fast-paced environment.
Compensation:
- Gain valuable industry experience in a professional setting.
- Opportunity to build your portfolio and develop your skills.
Studio Head – Rushing Tap Studios
Job Description:
Rushing Tap Studios is seeking a Studio Head to lead all operations within the studio facility. This leadership role requires a dynamic individual with strong facility management and project management skills. The Studio Head will oversee multiple projects, allocate resources effectively, and manage external vendors and personnel for various productions. This is an exciting opportunity to play a key role in a fast-paced, creative environment while driving new business and ensuring the facility operates at peak performance.
Job Responsibilities:
- Lead the studio’s operations and team.
- Oversee day-to-day management of the studio facility and ongoing projects.
- Ensure the studios and related spaces are maintained in excellent condition for rental purposes.
- Manage bookings of studio spaces and equipment using studio software.
- Prepare quotations, timelines, and budgets for both studio-based and field projects.
- Promote the studio facility to attract new customers.
- Provide regular reports on studio activities.
- Build and retain client relationships, ensuring the studio grows its customer base.
Job Requirements:
- Proficient in computer usage and relevant software.
- Minimum of a few years of experience in facility management or a similar role.
- Strong organizational and time-management skills.
- A creative thinker with innovative problem-solving abilities.
- Exceptional interpersonal and communication skills.
Casting Call: Gaffer and Editor Needed for Major MLS Event in Miami
Job Description:
A major MLS event is seeking experienced crew members, specifically a gaffer and editor, for two days of work in Miami, FL. This exciting project requires professionals with reliable transportation.
Job Responsibilities:
- Gaffer: Handle lighting setups and ensure optimal visual quality during the shoot.
- Editor: Edit footage to produce high-quality final deliverables.
- Collaborate with the production team to maintain a smooth workflow.
Requirements:
- Proven experience as a gaffer or editor in professional productions.
- Reliable transportation to the Miami location.
- Submit full name, phone number, email, location, portfolio or website, and desired rate.
Compensation:
- Competitive pay based on experience and position.