Business Intelligence jobs in United Kingdom

OpenDoor I Business Intelligence Executive – Job Description

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

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. 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 Amazon, every project opens a door to new possibilities. Anything and everything can be an opportunity for our people to drive impact—to innovate, learn, thrive, and occasionally fail too.

The OpenDoor partnership model is built to deliver next-level productivity, fueled by our industry-leading approach to People, Platforms, and Process. It 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. When WPP’s Creative Transformation meets Amazon’s customer centricity, our people come together to challenge and impact what’s done today and build a better future.

By joining OpenDoor, you’re not only joining a cross-functional team partnering with one of WPP’s top five global clients, but also taking a step to challenge yourself and the world around you daily, working in innovative ways on some of the world’s most ambitious opportunities in marketing, tech, media, business, and creativity.

We are seeking a talented and enthusiastic individual to join our OpenDoor team as a Business Intelligence Executive. This is a full-time position based in London. The role is crucial in supporting WPP's mission to deliver consistency, excellence, and top-tier service for Amazon across its diverse businesses, including XCM, Prime Video, and RMI.

This position is part of a globally-distributed business intelligence team, responsible for ensuring that our key global account has access to accurate data and insights to inform marketing decisions.

The team’s primary responsibility is to maintain a global AWS-based reporting solution, automating the collection and transformation of marketing data into a single source of truth for both the agency and the brand. Responsibilities include running and maintaining existing solutions, improving them by incorporating new features from the Choreograph Measure platform, adding data sources, and deriving new insights to meet evolving business needs.

Your main responsibilities will include ensuring data completeness, correct operation of data collection and models, logging and resolving new requests and issues, and supporting users across 29 markets by understanding their needs and assisting with the reporting tools.

The data processes you will manage support global ROI models, reports, dashboards, and operational tools for agency stakeholders.

• Engage with media stakeholders to ensure data completeness, achievable requirements, and timely delivery.
• Document user requirements and support their incorporation into a development backlog.
• Plan and develop solutions within sprints to improve visualization layers in Amazon QuickSight.
• Coordinate with account leadership to understand reporting needs for campaigns and marketing programs.
• Create and refresh campaign-specific reports, coordinating tasks across disciplines and geographies.
• Support data infrastructure maintenance by troubleshooting issues and running scheduled tasks.
• Help users develop skills and maintain training materials and knowledge bases.
• Provide first-line support for user queries, triaging and connecting them with experts as needed.
• Identify and implement opportunities to improve cross-discipline processes.

• Familiarity with advertising performance data and measurement, with entry-level or internship experience preferred.
• Understanding of media performance measurement and visualization techniques.
• Experience with dashboards, reports, and data visualization tools.
• Analytical mindset to overcome technical and procedural challenges.
• Strong organizational skills and attention to detail.
• Excellent communication skills for diverse, global audiences.
• Positive attitude, ability to multitask, and work under pressure.
• Collaborative team player.

• Experience managing technical solutions and familiarity with agile methodologies.
• Experience building data pipelines and ETL processes, especially with AWS, Adverity, DBT.
• Knowledge of programming or statistical languages like Python or R.

• Access to innovative and influential global company experience.
• Mentorship and training from professionals at WPP and Amazon.
• Use of industry-leading tools and platforms.
• Opportunity to develop analytical skills and contribute to data-driven decisions.
• Impact on global marketing strategies.

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

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

Amazon x WPP Confidential

 #LI-Promoted