Data Analyst – FMCG

Job Title: Data Analyst – FMCGDepartment: Business ExcellenceLocation: Khamis Mushait / Abha Head Office (On-site)⸻Job SummaryThe Data Analyst is responsible for extracting, analyzing, and visualizing data to support strategic decision-making across commercial, supply chain, and marketing functions. This role will play a key part in building dashboards, improving reporting processes, and unlocking insights that drive business performance. The analyst will work closely with cross-functional teams to automate reporting, enhance data accuracy, and provide actionable insights that improve business efficiency.⸻Key Responsibilities• Extract, clean, and manipulate large datasets using SQL to support recurring dashboards and ad hoc analysis.• Design, build, and maintain dynamic dashboards and visual reports using Power BI (mandatory), incorporating DAX and Power Query.• Automate daily, weekly, and monthly reports using Python and SQL, ensuring timely and accurate visibility of KPIs.• Develop and maintain dashboards for sales performance, target achievement, supply chain metrics, and growth tracking across multiple business dimensions.• Collaborate with cross-functional teams (Sales, Marketing, Supply Chain, Finance, and Production) to identify data needs and translate them into meaningful insights and reports.• Build analytical models for route optimization, production forecasting, and sales commission calculations, contributing to cost reduction and productivity improvement.• Monitor and report on key business metrics including sales performance, distribution, inventory turnover, and trade promotion ROI.• Conduct data validation, quality checks, and discrepancy resolution to ensure accuracy and consistency across systems.• Support business reviews, planning cycles, and commercial performance discussions with data-driven insights.• Collaborate with IT and database teams to enhance data availability, structure, and integrity.• Contribute to data pipeline automation and efficiency improvements for recurring reporting tasks.• Identify and analyse lost sales opportunities through data visualization to support commercial decision-making.⸻Required Skills & Tools• SQL (Intermediate to Advanced) – for querying, transforming, and optimizing data from large relational databases.• Power BI – expertise in DAX, Power Query, and dashboard publishing.• Python – for automation, forecasting, and data transformation.• Advanced Excel – for ad hoc reporting and analytical tasks.• Strong analytical thinking with attention to detail and data accuracy.• Excellent communication and storytelling skills – able to turn data into clear business insights.⸻Preferred Skills• Familiarity with QGIS or Geospatial Analysis.• Understanding of forecasting models and KPI automation.• Experience working with ERP and CRM systems (e.g., SalesBuzz).• Background in FMCG, Retail, Sales, or Field Operations analytics.• Arabic language skills (preferred but not mandatory).⸻Qualifications• Bachelor’s degree in Engineering, Statistics, Computer Science, Business Analytics, or a related field.• 4–6 years of experience in a data analyst or business analyst role, preferably in FMCG or Retail industries.⸻Reporting toBusiness Excellence Manager⸻Why Join UsYou’ll play a key role in shaping the company’s analytics ecosystem — from automating reporting pipelines to generating insights that drive commercial growth. This is an opportunity to make a measurable impact while working closely with leadership and cross-functional teams to enhance business performance.