Provide advanced analytics support for the LATAM Sector in the Insights Services Center; a part of the broader Global Business Services function in Hyderabad, India.

This role will help to enable accelerated growth for PepsiCo by developing custom descriptive analytics approaches for LATAM to drive deeper understanding of business performance drivers both at the National / Regional / State /City 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 LATAM. 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 Bevareages / 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

Functional Responsibilities:

Support delivery of descriptive and predictive analytics as defined by the SLA (Service Level Agreement) within the LATAM 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 LATAM Categories, as a growth catalyst to prioritize and enable brand planning across portfolio

Support LATAM 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 LATAM 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

Develop new skillsets among team members related to advanced analytics by conducting training and period review

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

• 6+ 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  

• 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.  

• Good PowerPoint skills. 

• Experience in ML techniques, cloud compatible tech stacks, understanding of data pipeline creation preferable