Executive, Global BI Services Hybrid Remote , London, England

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

OpenDoor :

PURPOSE

The purpose of this document is to help prospective team members better understand the role and responsibilities with the position of Executive BI Global Services at OpenDoor , WPP \’ s bespoke global operating model for Amazon.

ABOUT WPP & OPENDOOR

At WPP, we\’re constantly reinventing the future of creativity on an ever-broader canvas, bringing together unrivalled talent, resources and skills to provide an integrated offer of communications, experience, commerce and technology.

Over the last decade, we have developed a dedicated global client practice with the mission of accelerating WPP\’s impact for our largest clients by bringing them the best of WPP. Each team is custom-built around a client\’s specific needs and challenges, providing easy access to the right capabilities. And that\’s why we\’ve built OpenDoor for Amazon .

OpenDoor is a unique integration of the best of WPP and Amazon – building on their respective strengths and visions. Whether at WPP or at Amazon, every project is an OpenDoor on new possibilities. Anything and everything can be an opportunity for our people to drive impact – for them to innovate, learn, thrive, and occasionally fail too.

The unique OpenDoor partnership model is built to deliver next level Productivity, fueled by our industry-leading approach to People, Platforms, and Process. OpenDoor spans across all WPP agencies and disciplines such as media, business consultancy, communications and brand strategy, tech and commerce, public relations, and production.

OpenDoor\’s values are built from Amazon\’s own 16 Leadership Principles , and WPP \’ s core values of Open, Optimistic and Extraordinary. Together, when WPP \’ s Creative Transformation meets Amazon \’ s next-level customer centricity, our people come together to challenge and impact what \’ s done today and build a better future.

By joining OpenDoor , not only are you joining a cross-function team partnering with one of WPP \’ s top five global clients, but you are also taking a step to challenge yourself and the world around you every day, working in the most unusual way on some of Earth \’ s most ambitious opportunities in marketing, tech, media, business, and creativity.

Who We Are Looking For

We are searching for a talented and enthusiastic individual to join our OpenDoor team as a Business Intelligence Executive. This is a Full-time position based in London. This role plays a crucial part in supporting WPP\’s mission to deliver consistency, delivery excellence and best in class service for Amazon in every country across its diverse businesses, including XCM, Prime Video, and RMI.

This role forms part of a globally-distributed business intelligence team, whose objective is to ensure that one of our most important global accounts have access to the right data and insights to inform their marketing decisions.

The team\’s primary responsibility is to maintain a global Amazon Web Services (AWS)- based reporting solution, which automates the collection and transformation of disparate marketing data into a single source of truth for use by both the agency and the brand. Not only does that mean running and maintaining the solution that already exists, but also continually improving it to incorporate new features from the Choreograph Measure platform, add new data sources, and to aid in deriving new insights in support of ever-evolving business demands.

As a BI Executive your primary responsibility will be ensuring that reporting data is complete, that collection and data models run correctly, that new requests and issues are logged and handled by the team\’s engineers.

You will also act as the primary point of contact for a subset of users across 29 markets, gathering their evolving needs and supporting them in the use of the reporting solution. The data processes you will manage will support 3 global client-side ROI models, 2 global client-side reports, and a suite of media and operational dashboards and reports in support of agency stakeholders.

The related data processes will support 3 global client-side ROI models, 2 global client-side reports, and a suite of media and operational dashboards and reports in support of agency stakeholders.

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 .
• Engage with media stakeholders to ensure that data is complete, that requirements are achievable, and that delivery deadlines are met.
• Help document user requirements, and support their incorporation into a central
• development backlog for prioritization
• Within development sprints, be responsible for planning and developing solutions for prioritized requirements to deliver ongoing improvements within the visualization layer in Amazon QuickSight
• Work with account leadership to understand and track the reporting needs for upcoming campaigns and marketing programs
• Lead the creation and weekly refresh of campaign-specific instances within the reporting solution, often requiring coordination of dependent tasks across disciplines and/or geographies
• Support members of the team tasked with maintaining the underlying data infrastructure by troubleshooting data issues and running scheduled tasks
• Ensure users have the necessary skills & knowledge to use the reporting solution, including helping maintain training materials and knowledge base
• Be the first-line of support for users, triaging queries as they come in, providing them with hands-on support where possible, and connecting them with other disciplines and experts when necessary
• Identify opportunities to improve supporting cross-discipline processes, and work with others to make them a reality.
• Familiarity with advertising performance (e.g. role of ad servers and other third-party tech vendors) data and measurement, preferably with experience at an entry-level or intern-level position
• An understanding of how media performance should be measured, and experience
• using different methods to visualize performance and to tell stories with data
• Sharable dashboards, reports, repositories, or other demonstration in your data organization and visualization tools
• Analytically minded, enabling you to understand and overcome technical and procedural challenges
• Strong organizational skills and attention to detail, allowing you to bring structure to an otherwise unstructured situation
• Strong spoken and written communication skills, ensuring your thoughts and needs are heard and understood by a diverse, global audience
• Can-do attitude, with an ability to multi-task and remain calm and composed under pressure
• Exude positivity and energy, and you can thrive in a fast-paced and dynamic working environment
• Work best in team environments, and you are a beacon of collaboration

BONUS POINTS

• Experience project managing the delivery of technical solutions, including exposure to agile product development methodologies
• Experience building underlying data pipelines and ETL, particularly useful if done using Amazon Web Services, Adverity , DBT etc.
• Knowledge and experience using other programming and/or statistical languages (e.g. Python, R, etc.)

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 click apply for full job details