Sales Assistant Analyst

PepsiCo Inc.; Hyderabad; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

PepsiCo Inc. is seeking a BI reporting analyst in Hyderabad to support the IND Commercial team with KPI reporting and analytics across channels, customers and sales areas.

The role leverages SAP BI, DMS Distributor and Nielsen data to provide actionable insights to THF Sales Leadership and drive growth opportunities. You will develop on-demand reports, collate large data sets, analyze promotions and NPD activity, and present monthly insights with clear recommendations to improve ROI and

Qualifications

• Degree in Business or Commerce.
• Minimum 6 years of experience in BI reporting and analytics.
• Strong written and verbal communication, and stakeholder management.
• Power BI analytics experience and proficiency with SAP BI and DMS NewsPage.
• Excel skills and data visualization abilities.

Responsibilities

• Provide reporting against KPIs and ad-hoc requests using shipment/POS data.
• Develop on-demand reports with improved visualization and accessibility.
• Collate large datasets across channels, customers and sales areas; distil insights.
• Analyze promotion and NPD activity to monitor ROI and opportunities.
• Present insights to THF Sales Leadership monthly.
• Support customer reviews and JBPs with cross-functional data.
• Ensure data integrity and back-end management of Field Sales tool (NewsPage).

Skills

Power BI

Excel

Stakeholder management

Analytical skills

Written and verbal communication

Organization & prioritization

Proactive & results-driven

Education

Degree in Business / Commerce

Tools

SAP BI

DMS Distributor (NewsPage)

Nielsen data systems

Microsoft Excel

Job description

Overview

This role is responsible for supporting the IND Commercial team with key reporting and analysis of performance by Channel, Customer and Sales Area against key deliverables. Adding value to the reporting suite, this role also provides meaningful insights and recommendations to the THF Sales Leadership team, highlighting all opportunities for growth and productivity.

Responsibilities

Functional Responsibilities

• Support IND Commercial function with performance reporting against established KPIs, including ad-hoc reporting requests using shipment / POS data and leveraging SAP BI, DMS Distributor and Nielson systems. This support should be extended for TT, MT and Sales Capability as against the initial arrangement of being dedicated to a certain channels.
• Develop on-demand reports delivering improved agility through ease of access and enhanced visualization
• Collate and format large and complex sets of data across multiple channels, customers and sales areas. Analyze data to distil meaningful insights on performance trends and opportunities
• Analyze promotion and NPD activity effectiveness to monitor return on investment and identify opportunities for improvement and customization by Channel, Customer and/or Sales Territory
• Assist with field sales execution and compliance reporting as well as survey initiatives (i.e. price checks in market)
• Present insights and recommendations to THF Sales Leadership team on a monthly basis and in a clear, concise and professional manner
• Support preparation of customer business reviews and JBPs, working cross-functionally with THF stakeholders to collate information on performance trends and opportunities by channel, customer, sales territory or distributor
• Contribute to the development of internal business reviews, providing information to support key planning processes and events. Eg: AOP and Mid-Year / Annual Sales conferences
• Assist with back-end management of Field Sales tool (NewsPage), ensuring data completion and accuracy
• Sustain all digital products developed for Sales capability
• Be the single point of contact for any queries on data integrity and data sanctity

People Responsibilities

• Develop winning relationships with IND Sales Leadership team and other key stake holders in the IND business, ensuring highest levels of agility and support are provided within established SLAs
• Partner with IND Commercial team to revise and refine reporting requirements, ensuring outputs remain relevant, meaningful and user-friendly to best support decision-making
• Work closely with wider GBS team members to deliver full loop data support to IND business
• Support business development and continuous improvement initiatives to drive growth and efficiency both within IND and GBS Hub

Qualifications

• Degree qualified in Business / Commerce
• Minimum experience 6 years
• Builds robust and successful working relationships
• Strong written and verbal communication skills
• Excellent organisation and prioritisation skills
• Proactive, responsive and results driven
• Strong Analytical skill with Power BI and Sales Commercial domain experience.
• Highly proficient in Microsoft Office, esp. Excel.
• Strong Stakeholder Management skills.

Essential

• Fluent English with excellent interpersonal skills
• Exceptional written and oral communication, adapting approach by situation and audience
• High attention to details
• Collaboratively and proactively works with multi-functional teams
• Dynamic, organized and able to handle competing priorities

Good to have :

Working knowledge of SAP BI, and DMS (Newspage) Distributor system