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. WPP Media is WPP’s global media collective. We bring the best platform, people, and partners together to create limitless opportunities for growth. In this role it is critical to embrace WPP & WPP Media’s shared core values.

About T&P, a leading WPP Media Brand. T&P is one of the world\'s leading full service creative and media agencies, formed by The& Partnership and mSix&Partners. It connects talent and tech to drive growth for brands, spanning four continents with 45 offices and over $1.2 billion in billings. T&P is focused on harnessing AI across outputs with its 1,900 people trained on WPP\'s proprietary AI platform Creative Studio.

Role Summary and Impact

The Data & Business Intelligence team builds and maintains the infrastructure needed for our agency and clients to answer questions with data. We deploy standardised and customised reporting solutions across the agency’s client bases, using best practices in data modelling, management and storage to automate the collection of data from client advertising campaigns in Google BigQuery. You will pull data from a wide variety of marketing platforms, transform, query and validate that data, and help build and optimise data pipelines in an agile team. You will collaborate with the campaign planning and activation teams across Paid Social, Paid Search and Programmatic display to develop data solutions for complex data use cases, such as data manipulation and forecasting. Our goal is to give clients and internal stakeholders a fresh, accurate and granular perspective on campaign performance and to lay the groundwork for AI-powered advancements.

Key Responsibilities

• Work within a team of BI Engineers to set up, maintain and document ETL processes to provide data pipelines and infrastructure for clients.
• Learn from and work with the incumbent BI Engineer and own the setup and running of data projects.
• Develop opinions on how best to utilise cloud computing technologies (e.g., Google Cloud Platform and BigQuery, Microsoft Azure, AWS) for data projects.
• Model data from raw extracts taken from marketing platforms into usable data sets for analysis and visualisation.
• Collaborate with a data visualisation specialist to define how data should be manipulated for client dashboards.
• Assist in developing case studies to highlight the work of the team.

Skills and Experience

• Experience in a reporting, business intelligence or data engineering role.
• Experience extracting data from digital marketing platforms including Google Analytics, Campaign Manager and Facebook Ads Manager.
• Hands-on experience with data engineering concepts such as data transformations, cleaning and structuring datasets, or creating data models to support analysis.
• Some experience using SQL, GoogleSQL or Python and a desire to improve skills.
• Interest in cloud computing technologies (Google Cloud Platform, BigQuery, Microsoft Azure, AWS Athena).
• Experience with data visualisation tools (Power BI, Tableau, Looker Studio) is welcome but not essential.
• Educational background is welcome; experience with data as part of studies is acceptable.
• Experience using technology to collect or transform data and the ability to discuss problems solved and challenges faced.
• Motivation to take on new challenges and learn new things, and an understanding of the digital advertising landscape.

Life at WPP Media & Benefits

We invest in our employees and support growth through the global WPP Media & WPP networks. Benefits include competitive medical, group retirement plans, vision, dental insurance, paid time off, partner discounts and mental health awareness days. We operate a hybrid model with office presence four days a week; discuss accommodations or flexibility with the hiring team during the interview process. Read our Privacy Notice for information on how we process personal data.

WPP Media is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We are committed to fostering a culture of respect where everyone belongs and has equal opportunities to progress in their careers.

While we appreciate all applications, only candidates selected for an interview will be contacted. This role is not open for relocation at this time.

Additional Information

Requisition ID: 21293

Seniorities, Employment Type, Job Function, and Industries

• Seniority level: Associate
• Employment type: Full-time
• Job function: Business Development and Sales
• Industries: Advertising Services, Marketing Services, and Technology, Information and Internet