Insight Analyst - SQL& Python

Provide advanced analytics support for the AMESA 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 AMESA to drive deeper understanding of business performance drivers both at the National / Regional / State /City level.

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; 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 AMESA Categories, as a growth catalyst to prioritize and enable brand planning across portfolio

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

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

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

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

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 visualize data set and identify KPIs that will help decision making.

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