Job description for Data Analyst at A&W Restaurants Indonesia
Responsibilities:
1. Sales & Revenue Analysis: Track and interpret key metrics such as average order value, sales per item, and revenue trends.
2. Inventory & Supply Chain Analysis: Monitor food costs, wastage, and inventory turnover to optimize supply chain performance.
3. Customer Behavior Analysis: Identify patterns in customer preferences, peak hours, and feedback for improved service and retention.
4. Operational Efficiency: Analyse data on staffing, kitchen output, and delivery times to improve day-to-day operations.
5. Menu Engineering: Evaluate item profitability and popularity to support strategic menu decisions.
6. Cost of Goods Sold (COGS): Assess how raw material costs influence profit margins.
7. Seasonality & Promotions: Analyse the impact of holidays, seasons, and marketing campaigns on sales performance.
8. POS Systems: Work with data from systems to derive actionable insights.
9. Fixed Asset Records: Verify and manage records of fixed assets at various restaurant locations.
Requirements:
1. Bachelor’s degree (S1) in Mathematics, Statistics, or a related quantitative field.
2. At least 3 years of experience in the F&B or relevant industry.
3. Advanced Excel skills, including formulas, pivot tables, dashboards, and charts.
4. Experience working with relational databases (e.g., querying sales and inventory data).
5. Basic programming knowledge for analysis using Python, SQL, or similar tools.
6. Strong communication skills with the ability to explain technical findings to non-technical teams (managers, marketers).
7. Problem-solving mindset with a keen eye for uncovering insights that drive business decisions.
8. Collaborative attitude and experience working with cross-functional teams.
