Business Intelligence Executive

OpenDoor I Business Intelligence Executive – Job Description

The purpose of this document is to help prospective team members better understand the role and responsibilities with the position of Business Intelligence Executive 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.

ABOUT THE ROLE

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.

RESPONSIBILITIES

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

QUALIFICATIONS

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

BENEFITS OF OPENDOOR

• Unparalleled Access: Gain direct experience working with one of the world's most innovative and influential companies.
• Mentorship & Training: Receive guidance from experienced professionals at both WPP and Amazon.
• Cutting-Edge Technology: Utilize industry-leading tools and platforms, including WPP Open.
• Data-Driven Environment: Develop your analytical skills and contribute to data-driven decision making.
• Global Impact: Be part of a team that is shaping the future of marketing on a global scale.

HOW TO APPLY

Interested candidates are encouraged to submit their resume and cover letter to [email protected] by [application deadline].

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.