Junior Data Engineer (FTC)

About WPP Media

WPP is the trusted growth partner for the worlds 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 WPPs 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 .

About WPP Media
WPP is the trusted growth partner for the worlds 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.



For more information visit.

Role Summary and Impact

As aSenior Associate Data Engineeryou will be joining the one of WPP Medias flagship client partnerships and this role sits at thecentreof 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 with03 years of experienceto build deep technicalexpertisein advertising data engineering within a fast-paced collaborative and high-impact team environment.

You will play a meaningful role in building andmaintainingthe data pipelines datasets and reporting workflows that underpin our data solutions forOpenDoor. Working end-to-end on anAWS-native technology stack includingAmazon Redshift Amazon S3 anddbt 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 consistentlyaccurate performant and aligned to the evolving needs of theOpenDooraccount.

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 andmaintaindata pipelines usingAdveritydbt and SQLwithin a fully AWS-native environment supporting the ingestion transformation and modelling ofOpenDoorsadvertising 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 onAmazon Redshift ensuring data outputs areaccurate well-structured and aligned to business and client requirements.

• Work within the AWS ecosystem includingAmazon 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 ofOpenDoorsend-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 theOpenDooraccount.

• Developexpertisein WPP Medias internal tooling and advertising data landscape building a strong working knowledge of digital marketing media campaign data and ad serving technologies as they relate toOpenDoorsbusiness.

• Activelyseekand apply feedback from senior team membersdemonstratinga 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 foundationalSQL skillsfor data manipulation transformation and analysis with a good understanding of best practices and a desire to developoptimisationcapabilities.

• Hands-on experience with data transformation tools such asdbt data ingestion tools such asAdverity or equivalent platforms.

• Working knowledge ofAWS cloud data services specificallyAmazon Redshift with exposure to related services such asAmazon S3.

• Understanding ofdata pipelines data modelling concepts and debugging techniques with the ability toidentifyand 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 queryoptimisationtechniques withinAmazon Redshiftto improve pipeline performance and efficiency.

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

• Basic awareness ofCI/CD practicesfor data pipelines within an AWS environment.

• Exposure toproject management tools such asJira or Confluence.

Life At WPP Media & Benefits

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 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 whenweretogether fostering creativity collaboration and connection in this open and supportive a hybrid approach with teams in the office around four days a week. If yourequireaccommodationsor 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 locationPleaseread our Privacy Notice ( 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 readourPrivacy Notice for more information on how we process the information you provide.

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