Senior Analyst-Data Engineer

About WPP Media 

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: 

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

This role will serve as core member of a data engineering team assigned to one of WPP’s major global clients, who will be maintaining and expanding upon a global data warehouse, automated reports, and data provisioning applications to ensure that media and marketing stakeholders the world will have access to the right data and insights to inform their marketing decisions.  

WPP has developed the Measure platform, a stack of standardized technologies (Adverity for collection, DBT for modelling, Google Cloud Platform for orchestration, computing, and storage, and Microsoft PowerBI for visualization) and templates to speed the deployment and simplify support for automated reporting and analytics tools.

The team’s primary responsibility is to build and maintain a global Measure-based reporting solution, leveraging existing templates where applicable and building custom collectors, data models, cloud architectures, and/or visualizations when required. The team will automate the collection and transformation of disparate marketing data into a single source of truth, continually improving it to incorporate new data sources, and to derive new insights, to support ever-evolving business demands.

As an Senior Data Engineer, your primary responsibilities will include deploying and troubleshooting standardized Adverity data collection templates,  QAing landed versus source data using self-developed scripts and manual processes, gathering platform and ad account parameters from upstream stakeholders, working within and contributing to the team building the data warehousing solution,  adhering to technical standards and best practices, and contributing to the documentation of custom work.

In doing so you will exhibit a foundational understanding of cloud technology and key data engineering skills and knowledge to help your team in this fast-evolving and in-demand industry.

Some of the things we’d like you to do:

• Deploy data collectors in Adverity to gather data from media, agency system, and other sources

• Development and maintain data quality checks and procedures, helping stakeholders overcome data issues before they impact the quality of the reporting solution

• Support the translation of user requirements and business needs into technical specifications
• Be a proficient user of Google Cloud Platform and associated technologies, ensuring your work incorporates industry best practice
• Monitor aut