Sales Planning Coordinator

About the role

Holland Dairy, one of Ethiopia's leading dairy processors, is looking for a Sales Planning Coordinator in Addis Ababa. The role prepares sales forecasts and allocations, reviews sales and distributor performance and assesses commercial activities, helping the Trade Manager decide where action is needed.

Key responsibilities

• Prepare KPI scorecards and daily SENRI scoreboards for the Trade Manager, track daily sales by route and channel and give improvement insights.
• Check each distributor's forecast, targets, coverage, compliance and KPIs, recommend actions and coordinate payment accuracy with finance.
• Prepare forecasts from sales history, trends and field demand, attend daily S&OP meetings, and prepare daily allocations based on past sales, stock and priorities.
• Track activated outlets and territory coverage, compare territory sales with plans, and maintain customer master data for direct and indirect channels.
• Compare sell-in to distributors with sell-out to retailers, match periods, products and customer IDs, and follow up missing reports.
• Create route visit plans, check Power BI and Business Central figures with the Data officer, run weekly distributor reconciliations and follow up data errors with IT.
• Keep a project tracker and compare actual versus expected results for pilots, sampling, fridges and outlet materials.

Required profile

• Degree in Business Administration, Marketing, Economics, Statistics or a related field.
• 3 years of experience in sales planning, commercial performance, trade marketing, route-to-market or sales operations.
• Strong numerical skills, careful checking and the ability to explain figures and recommend action.

Required skills

• Strong Microsoft skills: Excel formulas, PivotTables and forecasts.
• Ability to use and interpret Power BI or similar reports.