Business Intelligence Executive

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. 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. 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.

About T&P: T&P is one of the world's leading full service creative and media agencies, connecting talent and tech to drive growth for brands. Formed by the integration of The&Partnership and mSix&Partners, it brings together content and distribution into a single, holistic end to end marketing solution. Backed by WPP and WPP Media and combined with the agility of an entrepreneurial Partner-led mindset, the multi-discipline agency spans four continents with 45 offices and over $1.2 billion in billings globally. As an early adopter with the first ever AI-generated TV ad for Lexus in 2018, T&P is focused on harnessing AI across all its outputs with its 1,900 people already trained on WPP's proprietary AI platform Creative Studio, to deliver enhanced outcomes for clients.

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 work across the entire agency’s client bases to deploy standardised and customised reporting solutions. We serve our clients by using best practices in data modelling, management and storage to automate the collection of data from our client’s advertising campaigns in Google BigQuery. Working across our tech stack, you will work to pull data from a wide variety of marketing platforms, and then work to transform, query and validate that data. Working as part of a small and agile team you will help to build and optimise data pipelines and troubleshoot when there are problems. You’ll work collaboratively 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 engineers to set up, maintain and document ETL processes designed to provide a data pipeline and infrastructure for our clients.
• Learning from and working with the incumbent BI Engineer and own the set up and running of data projects.
• Building on an interest in cloud computing technology, such as Google Cloud Platform and BigQuery, Microsoft Azure or AWS Athena, you will develop an opinion on how best to utilise and deploy cloud computing technologies for our data projects.
• Modelling data from the raw extracts taken from marketing platforms into usable data sets for analysis and visualisation.
• Work alongside a data visualisation specialist to define how data should be manipulated to make it work for a client dashboard use case.
• Assist in the development of case studies to highlight and celebrate the work that you do as part of the team.

Skills and Experience:

• Experience in a reporting, business intelligence or data engineering role.
• Experience of extracting data from digital marketing platforms including Google Analytics, Google Campaign Manager and Facebook Ads Manager.
• Hands on experience on data engineering concepts, such as performing data transformations, cleaning and structuring datasets, or creating data models to support analysis.
• Some experience of using SQL, GoogleSQL or Python and interested in improving your skills.
• You have an interest in cloud computing technology, such as Google Cloud Platform and BigQuery, Microsoft Azure or AWS Athena.
• Although it’s not essential for this role, you may have some experience of building data visualisation in Power BI, Tableau, Looker Studio.
• You may have worked with data as part of your degree or education, but any educational background is welcome.
• You have experience of using technology to collect or transform data and can talk about the problems they solved, and any challenges experienced.
• You are motivated by taking on new challenges and learning new things.
• You can demonstrate an understanding of the digital advertising landscape.

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.

Equal Opportunity: 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 in which everyone feels they belong and has the same opportunities to progress in their careers.

Hiring and Privacy: Please read our Privacy Notice 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.