Job Description

:
Overview
Provide advanced analytics support for the APAC Sector in the Insights Services Center; a part of the broader Global Capability Center function in Hyderabad, India.
This role will help to enable accelerated growth for PepsiCo by developing custom descriptive analytics approaches for APAC to drive deeper understanding of business performance drivers both at the National / Regional / Zonal or Channel level.
Primary responsibilities include developing/enhancing statistical models to address key business questions associated with Growth Driver Modeling, Pricing, Assortment, Market Structure, Innovation Forecasting, and Category Growth Forecasts, Portfolio growth model, Ambition related assignments for the key markets of APAC. Additionally, this role will also support the consumer insight team by collating learnings from a variety of sources, to help inform the development of future insights strategies for various brands with in Beverages / Snacks .
The role will have short-term responsibilities for knowledge transfer from the Vendors and effectively establishing business process and communication methods with teams they support; both are crucial requirements to enabling the organization to deliver answers to on-going business questions
Responsibilities
Functional Responsibilities:
Support delivery of descriptive and predictive analytics as defined by the SLA (Service Level Agreement) within the APAC Business Service Service Center

• Execute deep descriptive analytics of business performance and drivers to supplement standard reporting and inform data-driven decisions
• Identify, assess, and visualize key market share drivers for APAC Categories, as a growth catalyst to prioritize and enable brand planning across portfolio
• Support APAC region's annual SKU optimization process for the portfolio; analyzing impact by channel, customers and region as needed based on HQ delivered recommendations & targets
• Advise and share Advanced Analytics models and best practices with Regional Category Managers to leverage and build Advanced Analytics capability.
• Develop, maintain, and apply statistical models to business questions - including forecasting, price sensitivities/corridors, drivers analysis, market structure, etc.
• Forecast market growth leveraging (PGM - an internal tool) on an annual basis to inform PEP's long-term expectations for growth
• Collate and format consumer learnings from custom insight outputs, sales performace reporting, industry periodicals, and social listening resources, etc to help inform and develop future consumer insights strategies
• Provide responses to ad-hoc follow-ups when double-click (additional questions) required with tables/charts for relevant data

Support relationships with the key end-user stakeholders in APAC and region offices

• Own flawless execution of analytics exercises
• Responsible for managing multiple priorities; being able to manage deadlines and deliverables
• Lead communication with Business Partners and potentially end-users on matters such as available capacity, changes of scope of existing projects and planning of future projects
• Deliver outputs in line with the agreed timelines and formats
• Flag and monitor any business risks related to delivering the requested outputs
• Partner with stakeholders and service center leadership to develop and finetune internal COE processes (work-flow mapping, pain-points and bottlenecks management) both related to service delivery and internal center operations
• Improve existing processes based on frequent Business Partner & end-user feedback loop

People and Project Management Responsibilities

• Promotes cross functional seamless communication, sharing know how and creating same quality of experience across sector markets

Qualifications

• 4 to 7 years of experience in the field of analytics
• Ability to convert insights into story that answers critical business questions.
• Hands on in coding in tools like R and Python ( both or at least one )
• Hands on in MS excel(advanced) and SQL
• Understanding of data structures, adept in data cleaning, structure, and aggregation as per need
• End-to-end project management.
• Expert of statistical techniques like regression, forecasting, decision trees and modelling process- concept and coding.
• Ability to design model architecture and translate business problem into analytical problem
• Ability to visualize data set and identify KPIs that will help decision making.
• Expert on "Point of Sale" (Nielsen, IRI, SPINs, One Click Retail etc.) databases/metrics a must & good understanding of FMCG market structures, knowledge of media.
• Good PowerPoint skills.
• Experience in ML techniques, cloud compatible tech stacks, understanding of data pipeline creation preferable