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)
Key Skills/Experience Required
Identify any differentiating expertise required for success in the role.
Experience of 0-2 years (for L3), 2-5 years of experience in Finance/Sales (for L4), 4-7 years of experience in Finance/Sales (for L5)
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
Qualifications Highly organized and responsive, with ability to work to SLAs and tight deadlines
Numerate thinker, good at data analysis with strong attention to detail
Language skills - English fluent
Excellent written and oral communication skills; proactively communicates using appropriate methods for situation and audience in clear, concise and professional manner
Ability to work collaboratively and proactively with multi-functional teams
Be flexible, organized and able to handle competing priorities
Good to Have Working knowledge of advanced MS excel and VBA