Job Description
Full details about the role and requirements
Yukerja Summary
The Data Analyst role at A&W Restaurants Indonesia is curated from Glints (category Marketing & Penjualan). Note the work location (Penjaringan) before applying. Yukerja.com is not the employer — applications are handled on the official source site.
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.