Business Analyst - 12 Month FTC

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 our pioneering agentic 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.

Role Summary and Impact 

As a Senior Associate Data Engineer, you will be joining the dedicated OpenDoor team. OpenDoor is one of WPP Media's flagship client partnerships, and this role sits at the centre of delivering the data infrastructure that powers performance-driven advertising insights and analytics for this high-profile account. 

This role is an excellent opportunity for an early-career data professional with 0–3 years of experience to build deep technical expertise in advertising data engineering within a fast-paced, collaborative, and high-impact team environment. 

You will play a meaningful role in building and maintaining the data pipelines, datasets, and reporting workflows that underpin our data solutions for OpenDoor. Working end-to-end on an AWS-native technology stack – including Amazon Redshift, Amazon S3 and dbt – you will contribute to a robust, scalable data platform designed to aggregate diverse advertising data sources into a single, unified view. Working closely with senior engineers, BI, and Data Excellence teams, you will help ensure our data solutions are consistently accurate, performant, and aligned to the evolving needs of the OpenDoor account. 

No two days are the same. The problems are complex, the work matters, and the learning never stops. This is a role where you will be challenged, supported, and given the space to grow into a strong data engineering professional. 

Skills and Experience 

Key Responsibilities 

• Build and maintain data pipelines using Adverity, dbt, and SQL within a fully AWS-native environment, supporting the ingestion, transformation, and modelling of OpenDoor's advertising and media datasets into a unified, reliable view for reporting and analytics. 

• Support the development and maintenance of datasets, transformation logic, and reporting workflows built on Amazon Redshift, ensuring data outputs are accurate, well-structured, and aligned to business and client requirements. 

• Work within the AWS ecosystem – including Amazon S3 and Amazon Redshift – following established data architecture standards and engineering best practices to contribute to scalable, cloud-native data solutions. 

• Troubleshoot and resolve pipeline issues across the stack, contributing to the performance, stability, and data integrity of OpenDoor's end-to-end advertising data workflows. 

• Partner with internal teams – including the BI, Data Excellence, Activation, Client Service, Planning teams to understand reporting requirements and translate them into well-structured, maintainable data workflows that meet the strategic needs of the OpenDoor account. 

• Develop expertise in WPP Media's internal tooling and advertising data landscape, building a strong working knowledge of digital marketing, media campaign data, and ad serving technologies as they relate to OpenDoor's business. 

• Actively seek and apply feedback from senior team members, demonstrating a growth mindset and a genuine commitment to delivering high-quality, reliable data solutions. 
• Contribute to a high-performing and collaborative team culture, supporting the broader Data, Technology and Analytics team in upholding the highest standards of quality, accuracy, and client impact. 

Essential 

• Solid foundational SQL skills for data manipulation, transformation, and analysis, with a good understanding of best practices and a desire to develop optimisation capabilities. 

• Hands-on experience with data transformation tools such as dbt, data ingestion tools such as Adverity, or equivalent platforms. 

• Working knowledge of AWS cloud data services, specifically Amazon Redshift, with exposure to related services such as Amazon S3. 

• Understanding of data pipelines, data modelling concepts, and debugging techniques, with the ability to identify and resolve data quality issues effectively. 

• Clear and confident communicator, able to collaborate effectively with both technical and non-technical colleagues across a cross-functional account team. 
• Detail-oriented, reliable, and coachable – with the drive to deliver high-quality work and a genuine willingness to grow within a structured and supportive team environment. 

Desirable 

• Experience working with advertising, marketing, or media campaign data, including familiarity with digital ad serving technologies or web analytics platforms. 

• Basic understanding of query optimisation techniques within Amazon Redshift to improve pipeline performance and efficiency. 

• Exposure to code review processes and version control tools (e.g. Git). 

• Basic awareness of CI/CD practices for data pipelines within an AWS environment. 

• Exposure to project management tools such as Jira or Confluence. 

 
Life At WPP Media & Benefits Our passion for shaping the next era of media is powered by our commitment to Be Extraordinary, investing in our employees to inspire transformational creativity. We also Lead Optimistically, firmly believing in and Championing Growth and Development for every individual. This commitment allows WPP Media employees to leverage the extensive global WPP Media & WPP networks to pursue their passions, build vital professional connections, and learn at the cutting edge of marketing and advertising. 
 
We Create an Open environment built 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 events showcasing team 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 when we're together, 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 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. 
 
While we appreciate all applications received, only those candidates selected for an interview will be contacted. 
 
Please read our Privacy Notice for more information on how we process the information you provide.