Sales Admin & Ops Asst Analyst

PepsiCo; Hyderabad; On-site; INR 600,000 - 1,000,000; Full time

Job summary

PepsiCo Inc. in Hyderabad seeks a skilled Deduction Analyst to support the North America Beverage organization’s sales customer team by managing settlements for Trade Promotions.

You will analyze, calculate and validate payments and deductions, work with the Market team to review invoices, and ensure accurate processing of deductions and payments on TPM. The role requires strong data analysis, excellent Excel skills and effective communication with sales, finance and control teams.

Qualifications

• 5-6 years of experience in Finance/Sales (for L05).
• Bachelor’s in commerce/business/marketing or Finance; Master’s degree is a plus.
• Prior FMCG company experience preferred.
• Analytical skills: good data skills and ability to work through large data sets.
• Strong written and verbal communication skills.
• Excellent organization and prioritization skills.
• Proactive, responsive and results driven.
• Highly proficient in Microsoft Office especially Excel and PowerPoint.

Responsibilities

• Processing and reconciling Payments/Deduction invoices and monitoring approvals from Stakeholders.
• Invoice analysis and breakdown by segmentation; ensure timely closure of tactics post payments and manage trade spend.
• Communicate risks and opportunities to Sales team, Control, Finance.
• Validate tactic pricing with Pricing Grids for any discrepancy in accruals and invoices.
• Payments and funding tracking for vendors.
• Manage expectations through verbal and written interactions with internal teams (sales, Finance, Control).
• Ensure delivery of accurate and timely payment data per SLA.
• Implement improvements and simplifications of processes and standardization of reporting.

Skills

Data analysis

Communication

Organization

Proactive mindset

MS Excel

PowerPoint

Education

Bachelor’s degree

Master’s degree a plus

Tools

MS Excel

PowerPoint

Job description

Overview

This position will be part of the North America Beverage organization. This position contributes to the success of the Pepsi Beverages Company by supporting the sales customer team. The Deduction Analyst will manage the settlements for Trade Promotions. The role will work on analysing, calculating and validating the payments and deductions. Deduction analyst will work with dedicated Market team to review the payment invoices and processing deduction and payments on TPM. The role will be responsible for accurate calculation on payments due, identifying and raising any variances.

Responsibilities

Functional Responsibilities

• Processing and reconciliations of Payments/Deduction invoices and monitor approvals from Stakeholders and its timeliness
• Invoice analysis, breakdown by segmentation and ensure timely closure of tactics post payments and manage trade Spend in respective accounts.
• Communicate Risks and Opportunities to Sales team /Control/Finance.
• Validate Tactic pricing with Pricing Grids for any discrepancy in accruals and invoice
• Payments and funding tracking for vendors
• Manage expectations through verbal and written interactions with internal teams that includes sales, Finance and Control
• Ensure delivery of accurate and timely payment data in accordance with agreed service level agreements (SLA)
• Implement continued improvements and simplifications of processes, standardization of reporting and optimal use of technology (Automation)

Qualifications

• 5-6 years of experience in Finance/Sales (for L05)
• Bachelor’s in commerce/business administration/marketing or Finance, Master’s degree is a plus
• Prior Fast Moving Consumer Goods (FMCG) company experience preferred
• Analytical Skills: Good data skills and ability work through large data sets
• Communication: Strong communication skills and collaboration skills
• Strong written and verbal communication skills
• Excellent organisation and prioritisation skills
• Proactive, responsive and results driven
• Highly proficient in Microsoft Office especially Excel and PowerPoint