Assistant Manager - Deduction Analyst TPM

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

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

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