Commercial Analyst
Saudia Dairy & Foodstuff Company (SADAFCO)
Purpose of the job
The Commercial Intelligence Analyst supports the monitoring, analysis, and reporting of SADAFCO’s sales performance, SKU availability, ROC, CO, VSO, and van loading metrics across assigned depots, routes, and channels. The role prepares accurate and timely reports, identifies performance gaps and exceptions, and supports the target, forecast, and commission processes to enable informed commercial decision-making.
Key Accountabilities
- 1. Monitor· Track Recommended Order (RO) and Carry Over for assigned depots and retail routes.
- Monitor salesmen’s stock taking at barcode/SKU level and flag discrepancies.
- Track Recommended Order Compliance (ROC) by depot, route, and channel.
- Compare outlet stock levels against sales performance and highlight exceptions.
- Monitor van loading outputs against agreed parameters and report deviations to the Manager.
- Carry out daily checks on van route adherence and escalate non-compliance.
- Monitor SKU distribution, availability, and Van Stock Outs (VSO).
- 2. Analysis· Analyze historical sales trends to identify drivers of carry over and performance gaps.
- Extract, clean, and analyze large datasets to identify patterns, root causes, and exceptions.
- Compare carry over against van loading picking list recommendations and share findings.
- Identify seasonal and event-driven sales patterns (e.g., Ramadan, Eid, Hajj, Back-to-School, salary cycles).
- Validate system-generated reports for accuracy before circulation.
- Provide data analysis to support journey planning, outlet visit frequency, and route optimization.
3. Reporting• Prepare and maintain commercial performance reports and dashboards on Intranet, Power BI, and mSFA.
- • Produce daily, weekly, and monthly performance updates for assigned routes and channels.
- Prepare exception-based and deep-dive reports as directed by the Manager.
- Respond to ad-hoc data and reporting requests from Business Managers and commercial stakeholders.
- Suggest improvements to existing reports to increase accuracy, efficiency, and usability.
- 4. Target & Forecast Support· Prepare target and forecast splits at customer and SKU levels based on historical sales and approved forecasts.
- Upload and publish targets and forecasts on the Target Portal at the start of each month.
- Support Sales Director, Regional Managers, and Business Managers with Target Portal access and queries.
- Maintain accurate records of target and forecast data for performance tracking.
- 5. Commission & Incentive Support· Collect and prepare system inputs for commission calculations in line with approved policies and KPIs.
- Run initial accuracy checks on commission outputs and report issues to the Manager.
- Support Business Managers on the Adjustment Portal and compile supporting documentation.
- Consolidate adjustment requests for review and approval.
- Prepare final commission data for upload into EMS.
- 6. Data Quality & Process· Ensure data accuracy, consistency, and completeness across reports and systems.
- Document report logic, data sources, and processes.
- Coordinate with IT and system owners to resolve data and system issues.
Skills
Job Requirements
Bachelor’s Degree in Statistics, Data Science, Business Analytics, Information Management, IT, Econometrics, or a related field.
- Minimum 3 years of experience in data analysis, BI, MIS, or commercial/sales reporting, preferably in FMCG or Retail.
- Hands-on experience with reporting and data visualization tools (QlikView, Power BI, mSFA, or similar).
- Working knowledge of SQL and database querying; exposure to ERP platforms (e.g., EMS) is a plus.
- Advanced MS Excel skills (pivot tables, lookups, data modeling) and good Microsoft Office skills.
Exposure to targets, forecasts, or commission calculations is a plus.
- Good verbal and written communication skills; fluent in English, proficient in Arabic.
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Mechanical Engineer - Confidential (Western Region)
Sales Specialist
Business Integration Manager - Water