Analytics Associate Director, GOC

WPP Media; Mexico; Hybrid; MXN 480,000 - 720,000; Full time

Benefits offered by this job

Medical insurance

Retirement plans

Vision & dental insurance

Paid time off

Job summary

WPP Media is seeking a Data Engineer to design and build cloud-based data solutions, collaborating with cross-functional teams to support media performance reporting. The role focuses on maintaining data quality, governance, and efficient data workflows across platforms.

The ideal candidate will work with internal data strategy and analytics teams, manage project plans, and ensure deadlines are met while leveraging tools like SQL, Python, and Databricks in a cloud environment.

Qualifications

• Bachelor's degree in a relevant field preferred.
• 4+ years to 5 years in data governance/ETL/BI environments preferred.
• Experience across multiple media channels and large datasets is desirable.
• Strong attention to detail and organizational skills.

Responsibilities

• Collaborate with data engineers, developers and UX designers to build data pipelines and reporting workflows.
• Assist with CI/CD pipelines with offshore teams.
• Capture data architecture requirements from stakeholders and document them.
• Migrate legacy data platforms to new data solutions while ensuring data quality.
• Deploy client onboarding to cloud data solutions and provide ongoing support.

Skills

SQL

MySQL

PostgreSQL

Redshift

Snowflake

Python

Education

Bachelor's degree in CS/Math/Statistics

Tools

Databricks

Jira

Confluence

Smartsheets

Azure DevOps/VSTS

Tableau

PowerBI

Job description

About WPP Media

About WPP MediaWPP 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 our pioneeringagentic 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. WPP is the creative transformation company. We use the power of creativity to build better futures for our people, planet, clients and communities. For more information, visit wpp.com. WPP Media is WPP’s global media collective. In a world where media is everywhere and in everything, we bring the best platform, people, and partners together to create limitless opportunities for growth. For more information, visit wppmedia.com At WPP Media, 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 & WPP Media’s Shared Core Values:

Summary

A minimum of four to five years’ experience preferred; the Data Engineer is responsible for the design and build of cloud-based data solutions, working with other team members to manage the development and maintenance of business intelligence and data quality compliance tools. This individual will also work closely with internal Data Strategy and Analytics, Investment and Planning teams, acting as the subject matter expert in the tools and processes they manage, along with being able to gather knowledge from other SMEs and requirements from key stakeholders. In their role, they will also manage the creation of project plans, prioritization of tasks, and hold all responsible parties to deadlines and deliverables. They will report to the Director and will provide overviews of project status, progression, and roadblocks. This role requires a strong familiarity with all available analytics and technology tools, both syndicated and proprietary.

Responsibilities

• Work closely with a team of data engineers, developers and UX designers to create our data pipeline and workflows to support our media performance reporting. Manage the design, build and maintenance phases of client reporting projects.
• Work with offshore team on CI/CD pipelines.
• Work with client stakeholders to define and document data architecture and reporting/visualization requirements.
• Migrate the internal teams from legacy data platforms to the new data platform, ensuring data quality and provide going support and maintenance.
• Deploy new client teams to the cloud data solutions, providing guidance and support throughout the onboarding process.
• Define QA guidelines and automate the current QA process.
• With support from the Director, develop tools, process, and best practices to achieve workflow efficiencies and drive value for client teams and clients.
• Act as the subject matter expert for questions/projects relating to data quality, BI tools, business rules; Ensure that best practices are being followed amongst all projects.
• Must familiarize themselves with the full campaign implementation workflow across all functional teams, including campaign set up, launch, testing, reporting and reconciliation.
• Stay up to date and informed on changes and evolution of industry topics; support POV development and provide thought leadership on data privacy laws, third-party measurement tools and space, consumer marketplace, vertical expertise etc.
• Facilitate communication and progression of tasks through regular status meetings and working sessions; proactively elevate and resolve project roadblocks and issues; keep track of and manage a high volume of tasks across multiple stakeholders and projects.
• Builds positive relationships with internal teams; effectively communicate roles, responsibilities, and expectations.

Systems & Tools

• Advanced knowledge of databases and data warehouses such as SQL, MySQL, PostgreSQL, Redshift, Snowflake, etc.
• Advanced knowledge of one or more programming languages: Python, etc.
• Knowledge of cloud platforms such as Microsoft Azure, GCP, AWS.
• Knowledge of data engineering platform such as Databricks.
• Familiarity with project/product management tools like Jira, Confluence, Smartsheets, Azure DevOps/VSTS
• Familiarity with business intelligence tools such as Tableau, PowerBI, etc.
• Experience with advertising campaign management/buying platforms such as Sizmek, GCM, Flashtalking, Moat, DV, IAS, Mediaocean, Media Tools, Nielsen, ComScore, Facebook, Twitter, Pinterest, Snapchat, 4C, Brand Networks, YouTube, Google Ads, Bing, Kenshoo, SA360, DV360, Google Analytics, Adobe Analytics

Qualifications

• Bachelors or advanced degree in Statistics, Economics, Business, Math, Computer Science, or Sciences is preferred
• Experience with the full development life cycle of an application or reporting solution - from design through test and deployment.
• Minimum 4-5 years’ experience in data governance processes in a data warehousing, ETL and business intelligence environment
• 3 years’ experience in media; digital Investment, analytics, or ad operations is preferred
• Experience and understanding of processes across multiple media channels (digital, search, social, offline, etc.); Experience in handling diverse datasets (paid media, owned, etc.)
• Demonstrates strong eye/attention to detail
• Excellent verbal and written skills
• Exceptional organizational skills, multi-tasking capabilities and detail oriented
• Ability to foster collaborative relationships with other cross-functional teams
• Ability to manage and prioritize competing projects and deliverables
• Comfortable working with budgets and numbers

Life At WPP Media & Benefits

Our passion for shaping the next era of media includes investing in our employees to help them do their best work, and we’re just as committed to employee growth as we are to responsible media investment. WPP Media employees can tap into the global WPP Media & WPP networks to pursue their passions, grow their networks, and learn at the cutting edge of marketing and advertising. We have a variety of employee resource groups and host frequent in-office events showcasing team wins, sharing thought leadership, and celebrating holidays and milestone events. Our benefits include 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 particular characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.

We believe the best work happens when we're together, fostering creativity, collaboration, and connection. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process.

For Mexico

This position is available in a Remote or Hybrid Work Modality. The candidate must perform their work from any location within Mexico. Only Mexican nationals residing in the country or foreign nationals with a valid work permit may apply. Remote work from abroad is not permitted under any circumstances.

For Colombia

This position is in a Remote or Hybrid Work Modality and must be performed within Colombian territory. Only candidates residing in Colombia with a valid work permit may apply. Remote work contracts do not allow employment or relocation abroad.

Please read our Privacy Notice (https://www.wppmedia.com/pages/privacy-policy) for more information on how we process the information you provide. While we appreciate all applications received, only those candidates selected for an interview will be contacted.