Overview
To support the eCommerce agenda in the business unit. It is required in order to help operate with complex analysis, numbers and documents and lead eComm channel development projects. Serve as strategic advisors who translate complex data patterns into actionable business recommendations. Must understand the intricate relationships between manufacturer strategies, retailer objectives, and consumer behaviour patterns.
Responsibilities
- Be the pulse on eComm business performance & contribution - Leveraging internal & external eComm data, and work with BUs & finance teams to consolidate performance knowledge & learnings
- Support BU teams in preparing high quality materials, documents and analyses that will contribute to ongoing channel development projects
- Work with BU teams to set KPIs, establish data, build & distribute (on going) scorecards that drive the right action & have tangible impact on the business
- Develop or work with tech teams to develop customer specific performance reviews and scorecard tracking (MBR and QBR)
- Support BU teams with analysis and deep dives to enable customer conversations and support JBP efforts
- Issue specific ad hoc deep dives based on key business questions / opportunities / challenges
- Carry out ad hoc strategic analysis consolidating multiple data sources to provide strategic insight
- Work with DX & broader insights teams to carry out shopper behaviour & channel insights - building scorecards & integrating the right insight into strategic analysis
- Should collaborate with D&AI and Insights where applicable.
- Working in the international matrix is key, requiring strong communication and soft skills, capability to adjust communications to recipients & different cultures.
- Role requires high proficiency in Excel, Powerpoint and other Microsoft Office apps as well as analytical skills to make sense out of numbers and preparing high level conclusions / recommendations
- Leverage existing PepsiCo & eComm specific analytical tools to integrate data sets that analyse performance & drivers
- Key in the success is coping with uncertainty, ambiguity and fragmented set of data and capability to move things forward on limited inputs
- Setting the agenda for deployment of key Channel projects
- Partner with Bu Teams to define KPIs, data & tools needed to drive efficiency in the operation & generate more value from the breadth of data available in PepsiCo
Qualifications
5+ years experience in strategy / management consulting OR mutli-national organization working in a sales, commercial or transformation functionProficiency to use BI tools- Internal (e.g. Cockpit, eComm IQ), and external (e.Fundamentals, Similar Web, eConsultancy, Kantar, Nielsen etc.)Excellence in MS Office package, especially Excel & Power Point is essentialVery Good level of written & spoken EnglishStrong analytical skillsExperience of Power BI (or other BI tools), and / or data visualization experience a plusAbility to work with virtual teams across multiple geographies & timezonesProactive approach - drive online sales and customer engagement whilst taking others with youAbility to strategically frame opportunity, codify & share learnings across wide group of stakeholdersPrevious eComm experience preferredAbility to handle multiple work streams simultaneously and to tight deadlines in a fast-paced and dynamic environment.Good collaborator and influencer : Experience working with a breadth of stakeholders and peers - levels, functions and across countriesAbility to extract key messages from complex data and craft a clear narrative, presenting in person & virtuallyGood commercial and operational instinct to ensure recommendations are practical and executableWell organized, self-sufficient and proactive : Best-in-class time management skills, ability to multitask, set priorities and planCan-do, flexible attitude with resilience : Calmly able to respond to rapidly changing business prioritiesProven experience using PowerPoint and ability to producing visually compelling presentations (i.e. beyond just operating the software) that are impactful with a senior audienceDemonstrated proficiency in utilizing Power BI for data visualization and business intelligenceSkills Required
Excel, Power Bi, Powerpoint, Bi Tools, Analytical Skills, Data Visualization, Strategic Analysis