Sales Coordinator

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)

• Experience of 2-4 years (for L03), 3-5 years of experience in Finance/Sales (for L04), 4-7 years of experience in Finance/Sales (for L05)
• Bachelors in commerce/business administration/marketing or Finance, Masters 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