Business Performance Analyst

Mohammed Abdallah Sharbatly CO.LTD; Jeddah; On-site; SAR 40,000 - 80,000; Full time

Job summary

An established industry player is seeking a Sales & Inventory Analyst to enhance their operations. In this pivotal role, you will analyze sales performance and manage inventory to ensure alignment with projections. Your insights will drive decision-making and improve stock management, preventing overstock and shortages. Collaborating with various departments, you will prepare detailed reports and forecasts, using advanced tools like SAP ERP and Excel. This is a fantastic opportunity to contribute to a dynamic team and make a significant impact on the company's success.

Qualifications

• 5+ years of experience in an analytical role, preferably in retail or wholesale.
• Proven experience with inventory management and stock control.

Responsibilities

• Analyze sales performance and inventory levels to align with projections.
• Prepare weekly reports highlighting key measures and trends.

Skills

Analytical Skills

Attention to Detail

Problem-Solving

Communication

Education

Bachelor's degree in Business

Advanced certification in data analytics

Tools

SAP ERP

Excel

Power BI

Tableau

Job description

Job Overview:

The Sales & Inventory Analyst will be responsible for analyzing sales performance, inventory levels, and stock trends for over all our products. This role will focus on ensuring that present or periodical sales performances align with projections, managing inventory effectively to prevent overstock or shortages, and monitoring product conditions, goods destruction or auctioning. The analyst will provide detailed weekly reports (or whenever required) to Directors, highlighting performance, stock position, and any critical issues that need immediate attention.

Key Responsibilities:

Sales Performance Analysis:

1. Daily Sales Monitoring: Track and compare daily sales data against projections and historical performance. Identify deviations and analyze the causes.
2. Product-Level Performance Analysis: Evaluate the performance of individual products.
3. Sales Trend Analysis: Analyze sales data over time (weekly, monthly, quarterly) and identify trends to help forecast future sales.
4. Period Comparison: Compare current sales performance with past periods (same period last year, same month last year) and identify growth or decline situations.
5. Link Sales to Budget: Continuously monitor how actual sales compare with budgeted sales per product and per month, etc.

Inventory & Stock Management:

1. Stock Levels andInventory Position: Monitor and analyze stock on hand at any given time.
2. Stock Projections: Forecast future stock requirements based on sales projections, ensuring that the company avoids shortages or excessive overstock.
3. Inventory Turnover: Analyze the amount of inventory turnover per product and make recommendations for improvement.
4. Overstock and Stock Alerts: Set up alarms for potential overstock situations and monitor slow-moving products to minimize waste or discounting pressures.
5. Product Condition Monitoring: Track product conditions that could lead to spoilage, returns, or destruction due to quality issues.
6. Stock Aging Analysis: Track the age of inventory and inform the management.
7. Monitor Destruction of Goods: Track the volume and reasons for products being destroyed due to condition problems.
8. Reporting on Waste: Quantify and report the amount of goods destroyed, including any associated costs.

Reporting & Presentation:

1. Weekly Reports to the Management: Prepare and deliver a weekly sales and inventory performance report to the management, highlighting key measures, trends, and issues. Be ready to present and explain the findings positions.
2. Reporting: Produce reports and analysis on demand basis for any urgent or specific inquiries, such as addressing critical stock or sales issues.

Forecasting & Budget Alignment:

1. Sales Projections and Budget Review: Continuously compare actual sales against projected sales and budgets, making recommendations for adjustments where necessary.
2. Periodical Forecasting Updates: Update the sales and inventory forecast based on performance, market changes, and product movements.
3. Collaboration with Sales, Marketing, Procurement and Finance: Work closely with these departments to ensure alignment between sales projections, marketing campaigns, and inventory levels.

System & Process Improvements:

1. SAP ERP System Utilization: Use SAP Cube to extract and analyze data related to sales, stock levels, and product performance. Ensure that the ERP system is used efficiently for tracking, reporting, and forecasting.
2. Continuous Improvement: Proactively identify opportunities to improve processes, systems, and reporting, to increase efficiency in tracking and decision-making.

Skills

Education:

1. Bachelor's degree in Business, Finance, Economics, Supply Chain Management, or a related field.
2. Advanced certification in data analytics or supply chain management is a plus (e.g., Six Sigma, SAP certifications).

Experience:

1. Minimum of 5 years of experience in a similar analytical role, preferably in the agriculture, retail, or wholesale environment.
2. Proven experience with inventory management and stock control, including handling perishables or goods with short shelf lives.
3. Strong understanding of SAP ERP, or similar enterprise resource planning systems.
4. Experience in creating sales forecasts, budgets, and performance reports, with the ability to identify trends and opportunities.
5. Strong background in data analysis and reporting using Excel, Power BI, Tableau or other tools.

Skills & Competencies:

1. Analytical Skills: Ability to analyze large sets of data, identify trends.
2. Attention to Details: High level of accuracy and attention to details when monitoring stock levels and analyzing sales data.
3. Problem-Solving: Ability to identify issues (e.g., stock discrepancies, low-performing products) and suggest actions/solutions
4. Communication: Strong written and verbal communication skills, with the ability to prepare clear, concise reports for the management.