**About WPP Media**

WPP stands at the forefront of creative transformation, harnessing the power of creativity to sculpt promising futures for our people, the planet, our clients, and communities. For more intriguing details, visit our website.

WPP Media serves as WPP’s global media collective. In today’s world, where media penetrates every aspect of life, we unite the finest platforms, talent, and partnerships to unlock boundless growth opportunities. For more insights, explore further.

**OpenDoor**

**PURPOSE**

This document aims to provide potential team members with a clear understanding of the Executive BI Global Services role at OpenDoor, WPP’s tailored global operating model for Amazon.

**ABOUT WPP & OPEN DOOR**

At WPP, we are in a constant state of reimagining creativity, bringing together exceptional talent, resources, and expertise to deliver a seamless suite of communications, experience, commerce, and technology solutions.

Over the past decade, we have cultivated a dedicated global client practice aimed at amplifying WPP’s influence for our largest clients, delivering customized teams to address unique challenges and needs. This vision culminated in the establishment of OpenDoor for Amazon.

OpenDoor embodies a remarkable synergy between WPP and Amazon, leveraging the strengths of both to forge new pathways. At both organizations, each project opens doors to novel possibilities, encouraging our team to innovate, learn, grow, and occasionally learn through failure.

The innovative OpenDoor partnership framework is dedicated to achieving unprecedented productivity, driven by our superior approach to People, Platforms, and Processes. OpenDoor encompasses all WPP agencies and disciplines, including media, business consultancy, communications and brand strategy, technology and commerce, public relations, and production.

Our values are inspired by Amazon’s 16 Leadership Principles and WPP’s core values: Open, Optimistic, and Extraordinary. Together, as WPP’s Creative Transformation converges with Amazon’s customer-centric vision, our teams unite to challenge the status quo and shape a brighter tomorrow.

By joining OpenDoor, you will engage with a cross-functional team that collaborates with one of WPP’s top five global clients, embracing the opportunity to push boundaries and influence the landscape of marketing, technology, media, business, and creativity every day.

**Who We Are Looking For**

We are in search of an enthusiastic and skilled individual to join our OpenDoor team as a Business Intelligence Executive. This full-time position is based in London and plays a pivotal role in advancing WPP’s mission by ensuring exceptional service and delivery consistency for Amazon across its varied businesses, including XCM, Prime Video, and RMI.

As part of a globally distributed business intelligence team, your objective will be to provide vital data and insights that empower marketing decisions for one of our most significant global accounts.

Your primary responsibilities will include maintaining a global reporting solution based on Amazon Web Services (AWS) that automates the collection and transformation of diverse marketing data into a singular source of truth for agency and brand usage. Your role will involve not only running and optimizing the existing solution but also enhancing it to incorporate new capabilities from the Choreograph Measure platform, integrating new data sources, and deriving actionable insights to meet evolving business demands.

As a Business Intelligence Executive, you will ensure the completeness of reporting data, oversee the execution of data collection models, and manage new requests and issues in collaboration with the engineering team. You will be the main point of contact for a group of users across 29 markets, addressing their needs and assisting them in leveraging the reporting tool. The processes you oversee will underpin three global client-side ROI models, two comprehensive client-side reports, and a suite of dashboards and operational reports for agency stakeholders.

**Skills and Experience**

At WPP Media, our culture and our people define who we are, enabling us to deliver remarkable experiences for both clients and each other. In this role, it is essential to embody WPP and WPP Media’s shared core values:

• **Exemplify Extraordinary Leadership**: Inspire transformational creativity through collaborative efforts.

• **Cultivate Openness**: Build trust by balancing the needs of people and clients.

• **Embrace Optimism**: Champion growth and development to drive the enterprise forward.

– Collaborate with media stakeholders to guarantee data completeness, assess the feasibility of requirements, and ensure timely deliveries.
– Document user requirements, and assist in prioritizing them within a centralized development backlog.
– During agile development sprints, strategize and implement solutions for prioritized requirements, enhancing the visualization layer in Amazon QuickSight.
– Work closely with account leadership to comprehend and track reporting demands for forthcoming campaigns and marketing strategies.
– Spearhead the creation and weekly updates of campaign-specific instances within the reporting framework, often necessitating collaboration across various tasks and geographies.
– Provide support to team members handling data infrastructure, troubleshooting issues, and running scheduled tasks.
– Equip users with the necessary skills to effectively utilize the reporting solution, including maintaining training materials and knowledge bases.
– Serve as the initial point of contact for users, managing incoming queries, providing hands-on support, and connecting them with relevant experts when necessary.
– Identify and pursue opportunities to refine cross-disciplinary processes, collaborating with others to bring improvements to life.
– Possess familiarity with advertising performance metrics (understanding ad servers and third-party tech vendors), ideally through entry-level or internship experience.
– Understand how to measure media performance, and possess experience in visualizing data and telling compelling stories with it.
– Showcase sharable dashboards, reports, and repositories demonstrating your skills in data organization and visualization tools.
– Have an analytical mindset to navigate technical and procedural challenges.
– Demonstrate strong organizational capabilities and attention to detail, bringing clarity to complex situations.
– Exhibit excellent spoken and written communication skills, ensuring effective engagement with a diverse, global audience.
– Maintain a positive, can-do attitude, managing multiple tasks calmly under pressure and thriving in dynamic environments.
– Proven ability to collaborate effectively in team settings, fostering a spirit of cooperation.

**BONUS POINTS**

• Experience in project management for technical solution delivery, especially with knowledge of agile methodologies.
• Exposure to building data pipelines and ETL processes, preferably using tools like AWS, Adverity, DBT, etc.
• Skills in programming and/or statistical languages such as Python, R, etc.

**Life at WPP Media & Benefits**

We are passionate about shaping the future of media through the empowerment of our employees, nurturing their growth just as diligently as we pursue responsible media investments. Employees at WPP Media benefit from our expansive network, presenting opportunities for personal and professional growth while staying at the forefront of marketing and advertising. We also offer various employee resource groups and regularly host in-office events to celebrate achievements, share knowledge, and recognize important milestones.

Our competitive benefits package includes comprehensive medical, dental, and vision coverage, generous paid time off, preferential partner discounts, and dedicated mental health awareness days.

WPP Media champions equal opportunities, considering all applicants for positions without discrimination based on personal characteristics. We foster a culture of respect and inclusivity, ensuring everyone feels valued and has equal avenues for career advancement.

We believe that the finest work emerges from collaboration, creativity, and connection. This is why we maintain a hybrid working model, with teams present in the office about four days a week. If you require specific accommodations or flexibility, please discuss this with our hiring team during the interview process. Click apply for full job details.