Associate Manager- BI Reporting

Overview

This role will help to enable accelerated growth for PepsiCo by building pipelines, aligning data, building Visualization, and performing predictive and prescriptive analytics approaches for PepsiCo to drive actionable insights for the North American market.

Key responsibilities will be to build and manage data to be used for analytics, report creation, data Visualization projects, and for designing automation processes

Responsibilities

Ownership of ongoing maintenance and creation of new dashboards

• Rigourous Excel experience , Multiple Data Systems - For Analytics like Bobj,RSI,Retail Link etc. Good with Data Analytics & Analysis , CPG /Retail Experience must, Experience with Visualisation/Dashboard build like PBI,Tableau etc, Worked with Senior Leaders in the Org , Good handle on KPI/Metrics reporting,
• Good to have Knowledge on Predictive Analytics , Analytical Tools - R/Python/SQL.
• Work across multiple functions to aid in collecting insights for action-oriented cause of change analysis
• Build analysis in Excel, PBI, and Python with accompanying documentation
• Ensure delivery of accurate and timely data in accordance with the agreed service level agreement
• Focus on speed of execution and quality of service delivery rather than the achievement of SLAs
• Recognize opportunities and take action to improve the delivery of work
• Implement continued improvements and simplifications of processes, standardization of reporting and optimal use of technology
• Create an inclusive and collaborative environment
  
  

Qualifications

• 5+ years of experience in Sales Reporting & Analytics , Minimum 2 years in Data Analytics, preferably CPG Analytics.
• Preferred experience from strong top-tier consulting or Prior Fast Moving Consumer Goods (FMCG) company
• Good analytical skills - excellent competency in MS Excel is a must, as is experience of managing complex, incomplete & inconsistent datasets and defining strategic analytics (market sizing/growth forecasts etc). e.g -Tools like Knime,Python,R
• Deep grounding in analytical logic and ability to translate complex data into powerful insight
• Strong experience in data transformation, data visualization, exploratory analysis
• Strong Change Management Skills: Follow Up, Follow Through, Accountability, Sense of Urgency and superior stakeholder management
• Ability to provide new ways of approaching situations and developing new efficient solutions
• Independent & motivated individual; ability to receive direction and convert into an action plan with coaching and feedback
• Best-in-class time management skills, ability to multitask, set priorities and plan