About this role
The UK Shopper Insights role plays a critical role in BU commercial execution. This role owns all UK-specific Channel Passport reporting — including channel YoY value trends, penetration / frequency / basket decomposition, shopper switching flows, and mission-based read-outs — produced for commercial leadership every month.
Responsibilities
- Support the UK team in generating insights from current and historical trends.
- Extract sales, shelf prices and other relevant data from third-party sources, such as Kantar, Nielsen, GlobalData.
- Cleanse and transform data via PowerPoint, Excel or Power BI, ensuring accuracy and consistency through mapping SKUs, correcting erroneous entries, and standardizing formats.
- Provide expert guidance and support to bring in automation and innovation to current reporting processes.
- Collaborate with local market teams to ensure data accuracy and alignment with business needs.
- Monitor data integrity and implement quality control checks throughout the data handling process.
- Troubleshoot and resolve any discrepancies or issues that arise during data extraction, transformation or upload stages.
- Develop and maintain comprehensive documentation of processes, transformations, and mappings.
Qualifications
- Strong proficiency in PowerPoint, Excel, including advanced formulas, pivot tables and data manipulation.
- Strong knowledge of generating business insights by reading trends in data to uncover patterns and build a story.
- Experience with Power BI or Power Query for data manipulation and analysis is preferred.
- Strong analytical and problem-solving skills with attention to detail.
- Ability to work independently and manage multiple tasks in a fast-paced environment.
- Bias for action and ability to influence change without authority will be critical enablers of success in this role.
Other facts
About PepsiCo
PepsiCo is a playground for curious people. We invite thinkers, doers, and changemakers to champion innovation, take calculated risks, and challenge the status quo. From executives to team members on the front lines, we’re excited about the future. We take chances. Together, we dare to make the world a better place.
Our associates are the magic ingredient. Each of them plays an integral role in helping create deep connections between people and our products. Think about your last group celebration: Chances are, one of our iconic brands was by your side. At PepsiCo, you’re invited to be a part of a global team of innovators who make, move, and sell these products—which are enjoyed by more than 1 billion people a day.
A career at PepsiCo means working in a culture where everyone’s welcome. Here, you can dare to be yourself. No matter who you are or where you’re from, you can influence the people around you and the world at large. By showing up, you’ll have the opportunity to learn, develop and grow your skills for the future. Our supportive teams can fuel your professional goals to make a global impact on people and the planet.
Join us. Dare for Better.
What you'll do
- The Shopper Insights Manager will support the UK team in generating insights from sales trends and will own UK-specific Channel Passport reporting. Responsibilities include data extraction, cleansing, and transformation, as well as ensuring data accuracy and implementing quality control checks.
Ready to join PepsiCo?
Take the next step in your career journey