Overview- 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
- 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
Responsibilities- Work with wider teams to develop eComm Channel intelligence, identifying & understanding channel trends, competition monitoring & opportunity identification (big bets)
- Source & curate external insights & reports, helping to share & build interlligence across the eComm community
- Create in depth eComm analysis on performance & opportunity - work with GCC, Sector & BU teams
- Review eComm channel & key customers priorities, roles & strategies based on 1YR market outlook refresh
- Support BU/Sector teams with analysis and deep dives to enable customer conversations and support JBP efforts
- Prepare eComm channel specific analyses, charts, sets of data and presentations that provide clear & actionable insight
- Connect with BU, sector, finance & GCC counterparts to source information needed, often consolidating multiple data sets
- Actively work with DX & Insights teams to generate & consolidate eComm market intelligence (e.g. Kantar) and shopper / channel insights
- Develop overall and customer specific performance reviews (MBR and QBR)
- Build Performance Review Shareouts, KPI dashboards & agree tracker milestones
- Carry out ad hoc strategic analysis consolidating multiple data sources to provide strategic insight
- Make sense out of numbers and given information to prepare overarching story and conclusions/recommendations
- Prepare compelling presentations - tell stories from macro to micro points of action
- Choose and influence stakeholders to get specific information and point of view
- Based on high-level goals, create actionable steps and define proper resources and milestones to achieve the result
Qualifications- 5+ years experience in strategy/management consulting OR mutli-national organization working in a sales, commercial or transformation function
- Proficiency 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 essential
- Very Good level of written & spoken English
- Strong analytical skills
- Experience of Power BI (or other BI tools), and/or data visualization experience a plus
- Ability to work with virtual teams across multiple geographies & timezones
- Proactive approach - drive online sales and customer engagement whilst taking others with you
- Ability to strategically frame opportunity, codify & share learnings across wide group of stakeholders
- Previous eComm experience preferred
- Ability 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 countries
- Ability to extract key messages from complex data and craft a clear narrative, presenting in person & virtually
- Good commercial and operational instinct to ensure recommendations are practical and executable
- Well organized, self-sufficient and proactive: Best-in-class time management skills, ability to multitask, set priorities and plan
- Can-do, flexible attitude with resilience: Calmly able to respond to rapidly changing business priorities
- Proven experience using PowerPoint and ability to producing visually compelling presentations (i.e. beyond just operating the software) that are impactful with a senior audience
- Demonstrated proficiency in utilizing Power BI for data visualization and business intelligence
