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

About Choreograph: A Leading WPP Media Brand

Choreograph is WPP’s global data products and technology company. We’re on a mission to transform marketing by building the fastest, most connected data platform that bridges marketing strategy to scaled activation.

We work with agencies and clients to transform the value of data by bringing together technology, data and analytics capabilities. We deliver this through the Open Media Studio, an AI-enabled media and data platform for the next era of advertising.

We’re endlessly curious. Our team of thinkers, builders, creators and problem solvers are over 1,000 strong, across 20 markets around the world.  

Role Summary and Impact

This role will form a major part of our BI and Management department. You will be responsible for expanding and optimising our data and data pipeline architecture for our Google Marketing Platform (GMP) data sets, ensuring that our Analytics team, Data Science team, and other internal teams have the clean, accurate, and accessible data required to drive our clients’ business forward.

Leveraging Google Cloud Platform (GCP), you will build robust databases, transforming and moulding data from a variety of sources, such as Google Analytics, Campaign Manager, Search Ads 360, and client data. This foundational data work will enable us to provide industry-leading solutions that transform our clients' marketing and media activity.

As a GCP Data Engineer, you will be responsible for architecting, transforming, and modernising data solutions on GCP, integrating native GCP services and 3rd party data technologies. A solid experience and understanding of considerations for large-scale architecture, solutioning, and operationalisation of data warehouses, data lakes, and analytics platforms on GCP is essential. We seek candidates with a broad set of technology skills across these areas who can design optimal solutions using an appropriate combination of GCP and 3rd party technologies for cloud deployment.

This is an exciting, data-driven role for someone passionate about solving complex problems with precision and a flair for the GCP stack. You will be instrumental in advancing our GMP offering, consistently pushing our business forward with innovative ideas and enhancing the value we provide to our clients.

Reporting to the Senior Data Engineer, you will act as a point of contact for multiple internal stakeholders and collaborate with other specialised teams to develop our approach and processes for key clients and internal projects.  

Skills and Experience

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.

Team Leadership & Development:

• Provide supportive line management to a Data Engineer, fostering a high-performing and collaborative environment.
• Run internal training sessions to help upskill junior members of the team, promoting continuous learning and best practices in data engineering.
• Foster a collaborative environment, promoting data engineering best practices across the wider data and tech teams and other relevant internal stakeholders.

Technical Oversight:

• Create and maintain robust ELT pipelines on GCP, ensuring data integrity, efficiency, and optimal performance for all data sets.
• Design and build production data pipelines from ingestion to activation, using Python. Ensure written code is scalable, tested, and documented.
• Manage and evolve the platform architecture, ensuring scalability, security, automation, and optimal performance of our data infrastructure on GCP.
• Architect, transform, and modernise data solutions on GCP, integrating native GCP services and 3rd party data technologies to meet evolving business needs.
• Create and maintain Dataform processes for the transformation layer of client ELT pipelines, with SQL.
• Create and maintain robust CI/CD pipelines for versioning and deployment of data applications.
• Ensure engineering best practices are applied to support Data Analytics/Science initiatives, enhancing the reliability and effectiveness of our analytical outputs.
• Produce written (and possibly video) documentation of all engineering processes to ensure smooth knowledge transfer between the engineering team.
• Perform code reviews for peers, and mentor junior engineers when needed.

Business & Operational Impact:

• Lead projects and manage team workload, ensuring timely and effective delivery of data solutions for key clients and internal initiatives.
• Help develop the next generation of data products and services, contributing to the strategic growth and innovation of our offerings.
• Drive the advancement of our Google Cloud Platform (GCP) offering, identifying opportunities for innovation and enhanced client value.
• Act as a key point of contact for multiple internal stakeholders, collaborating closely with the wider data and tech teams and other teams to ensure data availability, quality, and accessibility for all client solutions and reporting.
• Ensure the security, robustness, and future-proofing of all data pipelines and solutions, supporting the delivery of integrated, efficient, and AI-driven data solutions that enhance client insights, drive measurable outcomes, and foster client growth.

Skills and experience required

Technical Expertise & Data Engineering Acumen:

• Python programming. Libraries including pandas, numpy, unittest.
• Cloud technology, preferably GCP.
• Containerisation with Docker.
• CI/CD with GitHub Actions or similar.
• Orchestration with Apache Airflow.
• Agile working

Advantageous

• ETL tools such as Adverity.
• Cloud resource deployment with Terraform.
• Generative AI such as GitHub Copilot.
• Front end programming experience [JavaScript, HTML, Python-Flask].
• Reporting tools such as Looker and Tableau.

Domain Knowledge & Business Acumen:

• A good understanding of business performance metrics and their application in data solutions.
• Understanding of the media landscape and advertising ecosystems, particularly related to Google Marketing Platform products.
• Knowledge of web analytics platforms such as Google Analytics and Google Marketing Platform products would be beneficial.
• Ability to translate complex data requirements into actionable solutions that drive client business forward.
• Personal Attributes:
• Curiosity & Innovation: A highly curious and innovative mindset, constantly seeking out new technologies and methodologies to solve complex problems.
• Problem-Solving: Exceptional analytical and problem-solving skills, with a methodical approach to tackling challenges.
• Communication: Excellent verbal and written communication skills, with the ability to present findings clearly and persuasively.
• Collaboration: Strong collaborative spirit, capable of working effectively with wider data and tech teams and across the wider organisation.
• Excellent attention to detail and a commitment to data integrity.
• An understanding of Agile methodology would be beneficial.

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. 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 this is a UK based role and requires individuals to have the right to work in this location

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

#LI-Promoted

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