Senior Associate, Data Operations

Wavemaker; Los Angeles (CA); Hybrid; USD 54,000 - 90,000; Full time

Benefits offered by this job

Hybrid work model

Competitive benefits package

Paid time off

Job summary

Wavemaker is seeking a Business Intelligence and Data Visualization Senior Associate to build, maintain, and enhance reporting and BI infrastructure. You will collect requirements, manage ETL, and develop dashboards to deliver campaign insights and competitive intelligence.

You’ll work with Tableau and Power BI, and contribute to data strategy and QA. Ideal candidates have 1–3 years in data analytics for marketing/media, strong SQL/Python skills, and experience with digital ad data and analytics

Qualifications

• Bachelor's degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field OR equivalent professional work experience.
• 1-3 years of work experience in data management, data visualization and data analytics in marketing/media agency.
• Experience building dashboards with Tableau and/or Power BI, Google Data Studio, Datorama, Domo is required; strong visualisation knowledge.
• Experience with Alteryx for business logic design and cloud environment (Azure, GCP, AWS, IBM data cloud pack).
• Experience with SQL or Python.
• Experience with digital data from ad serving platforms (Campaign Manager, adservers), planning tools (Prisma, Lumina, MediaOcean), analytics tools (Adobe Analytics, Google Analytics).
• Strong speaking and written professional communication skills.
• Strong analytical, critical thinking, and problem-solving skills.
• Ability to thrive in a fast-paced environment.
• Strategic thinker and doer; curious and eager to learn; high accountability; collaborative mindset.

Responsibilities

• Collect data requirements from client teams to define measurement framework and metrics for data stitching.
• Manage monthly data provisioning and taxonomy definition for activation teams.
• Handle ETL processes: retrieving, compiling, formatting large data volumes and data cleaning.
• Assist in setting up clients' cloud environment and develop custom databases for reporting platforms.
• Contribute to the development of the data visualization layer (Tableau) for insights and campaign optimization.
• Support automated QA processes to ensure data accuracy and timeliness.
• Communicate technical concepts clearly to non-technical stakeholders.

Skills

Communication

Analytical thinking

Problem solving

Team collaboration

Adaptability

Ownership

Strategic thinking

Education

Bachelor's degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field

Tools

Tableau

Power BI

Google Data Studio

Datorama

Domo

Alteryx

Azure

GCP

AWS

IBM data cloud pack

SQL

Python

Google Analytics

Adobe Analytics

Campaign Manager

Prisma

MediaOcean

Job description

About WPP Media

WPP is the trusted growth partner for the world's leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships - all united by ourpioneeringagentic marketing platform, WPP Open - we help clients navigate change, capture opportunity, and deliver transformational growth.

WPP Media is WPP's AI-driven media operating unit, bringing together media, data, and partnerships to deliver creative personalisation at scale. Connected through WPP Open and powered by Open Intelligence, clients see exactly where, how, and why their media investment is working.

For more information, visit wppmedia.com.

At WPP, we believe in the power of our culture and our people. It's what elevates us to deliver exceptional experiences for both our clients and each other. In this role it will be critical to embrace WPP's shared core values:

• Be Extraordinary by Leading Collectively to InspireTransformationalCreativity.
• Create an Open Environment by Balancing People and Client Experiences by Cultivating Trust.
• Lead Optimistically by Championing Growth and Development to Mobilize the Enterprise.

About Wavemaker: A Leading WPP Media Brand

Wavemaker, part of WPP, positively provokes growth for clients by reshaping consumer decision-making and experiences through media, content, and technology. Our name is both our mission and our method. We do our best work for brave brands and people who relish being challenged to go further and faster, together.

Role Summary & Impact

We are looking for a Business Intelligence and Data Visualization Senior Associate who will build develop and maintain the reporting infrastructure, the business intelligence, and the data visualization to deliver campaign reporting insights as well as competitive insights. In this role, he/she will be responsible to retrieve, compile, cleanse and transform data to create the intelligence layer leading to analysis and optimize media investments.

• Collect data requirements from client teams to understand the measurement framework, the most critical metrics to implement for database build and business logic for data stitching.
• Manage monthly data provisioning.
• Define the taxonomy for the activation team to implement to ease data retrieval.
• Manage the retrieving, compiling, and formatting of large volumes of data (ETL).
• Manage data cleaning.
• Assist in the set-up of the clients' environment (Cloud infrastructure and data lakes ...).
• Assist in the build and development of custom databases on the reporting platform.
• Assist in the strategy and development of the data visualization layer of the business intelligence platforms (Tableau) for insight generation for use in campaign monitoring and optimization.
• Help the development of automated QA processes to ensure data accuracy and timeliness.
• Communicate technical terms to non-technical people and help them understand why change might be required to achieve a specific goal or to complete a project.

Skills and Experience

• Bachelor's degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field. OR equivalent professional work experience.
• 1 - 3 years of work experience in data management, data visualization and data analytics preferably in a marketing and/or media agency.
• Experience in database structure work and in building dashboards with Tableau and/or Power BI, Google Data Studio, Datorama, Domo is required; knowledge of visual techniques for data analysis and presentation is a plus.
• Experience with Alteryx for business logic design required as well as ability to operate in Cloud environment (Azure. GCP, AWS, IBM data cloud pack).
• Experience working with SQL or Python.
• Experience with digital data from ad serving platforms (e.g. Google Campaign Manager, Other adservers), campaign planning tools (e.g. Prisma, Lumina, MediaOcean), website analytics software (e.g. Adobe Analytics, Google Analytics), paid search engine marketing data sources (e.g. Adwords, Marin, ...) and others is strongly preferred.
• Strong speaking and written professional communication skills.
• Strong analytical, critical thinking, and problem-solving skills.
• The ability to thrive in a fast-paced and deadline-driven environment.
• Strategic Thinker & Doer.
• Curious and excited to learn.
• High sense of accountability and ownership.
• Collaborative with a partnership mindset.

Life at WPP Media & Benefits

Our passion for shaping the next era of media is powered by our commitment toBe Extraordinary, investing in our employees to inspire transformational creativity. We alsoLead Optimistically,firmly believingin andChampioning Growth and Developmentfor every individual. This commitment allows WPP Media employees toleveragethe extensive global WPP Media & WPP networks to pursue their passions, build vital professional connections, and learn at thecutting edgeof marketing and advertising. WeCreate an Open environmentbuilt on trust and respect, where everyone feels they belong and has opportunities to progress. This inclusive culture is fostered through a variety of employee resource groups and frequent in-office eventsshowcasingteam wins, sharing thought leadership, and celebrating holidays and milestone events. Our comprehensive benefits package reflects this commitment, including competitive medical, group retirement plans, vision, and dental insurance, significant paid time off, preferential partner discounts, and employee mental health awareness days.

WPP Media is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We believe the best work happens whenwe'retogether, fostering creativity, collaboration, and connection in this open and supportive environment. That's why we've adopted a hybrid approach, with teams in the office around four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process. Please note that while our philosophy is the same across WPP, benefits may vary by office/country.

Please read our Privacy Notice (https://www.wppmedia.com/pages/privacy-policy) for more information on how we process the information you provide.

The base salary range for this position at the time of this posting is indicated below. Individual compensation varies based on job-related factors, including location, business needs, level of responsibility, experience, and qualifications. We offer a competitive benefits package, go to https://mybenefits.wpp.com/public/welcome for more details.

US Pay Range

$45,000 — $90,000 USD

Please read our Privacy Notice for more information on how we process the information you provide.