Trade Spend Analyst II (CPG/Grocery)

The Trade Spend Analyst will coordinate and communicate with the sales team to ensure all promotional activities, forecast and planograms for the period are captured, built, and accounted for in the TPM system and/or the financial statements. The Trade Spend Analyst will work with the claims/Deduction team to ensure deductions are properly applied to promotion accruals. Manage promotional maintenance within the system and maintain the Net Funding Position. Provide ongoing maintenance of our Trade Tool while driving efficiencies. Manage customer service interface regarding pricing and deduction clarification.

RESPONSIBILITIES

Trade Spend Management

• Track pricing execution in market to ensure strategy compliance
• Maintain pricing guidelines for regular and promotion pricing and frequency
• Responsible for working with the Trade Promotion Coordinator and/or CM to Plan, forecast and scrub promotions
• Detailed analysis of promo and tactic list to ensure the information in the system is accurate and audit compliant. Prepare reports and highlight key insights to management on monthly basis on quality of pricing strategy execution and performance
• Work closely with the Customer Team Leads and Business Managers to manage the Net Funding position (NFP), ensure accuracy and up to date information within the system
• Provide relevant analytics reporting information to the team to help monitor the volume, NFP and other key metrics associated with delivering the plan
• Proactiveness through troubleshooting and addressing issues – big swings in NFP, provide monthly reports as well as assisting KAM’s determining reasons for under accrual or over accrual vs. budget
• Help to maximize the trade spending effectiveness and efficiencies by observing lift factors, spending trends, return on investments; create appropriate reporting and analysis to understand impact of changes on the market as well as returns vs business case/assumptions
• Close monitoring of prior year accruals carried over into the current year to ensure timely settlement
• New Product Listing maintenance
• Interface with Customer Service and Trade Deduction Coordinator (TDC) where required to aid deduction clearing, pricing compliance, price increases, etc..
• Assist TDC in validation for Audit claims or support to collect invalid amounts
• Work closely with Trade Finance to ensure audit requirements are adhered to
• Work with IS to apply best practices in SAP, assisting Sales team with system related question

Process Improvement

• Learning and Identifying process improvements to create efficiencies in setting up promotions in Trade Tool
• Work with customer team to ensure that strategies/SOPs are adhered to, and best practices are applied
• Proactively initiates, leads, and participates in all stages of continuous improvement initiatives as well as new business requirements/projects
• Insightful business analysis to make better business decisions: customer ASK negotiations, extra investments to drive increased volume

Other:

• Period close support as required – month end and year end reporting
• Be customer/Client focused while assisting in the plans to meet corporate and account objectives
• Other duties and responsibilities as assigned

QUALIFICATIONS

• University/College degree in Business, preferably with Finance
• 2-5 years of Analyst experience
• 1 to 3 years of full-time work experience in a tier 1 CPG company, Broker, preferably in the food industry
• Strong knowledge of Trade Management systems (SAP, Exceedra, Blacksmith,etc)
• Strong business acumen and judgement
• Strong analytical and Excel skills
• Sound presentation and communication skills are required in cross-functional & team oriented-environment
• Must be a self-starter
• Must be a strong team player and build relationships across the organization
• Strong analytical skills and the ability to translate financial language effectively to all levels within the organization
• Should be adaptable, flexible, and agile to an ever-changing work environment
• Able to work independently with minimal direction, but also be able to ask for direction when needed
• Knowledge of current computer technologies (MS Office, Excel, Power Point, Power BI, Teams)