Data Analyst

A&W Restaurants Indonesia; Daerah Khusus Ibukota Jakarta; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading QSR brand seeks a skilled Data Analyst to transform complex data into actionable business insights. You will analyze sales trends, monitor inventory, and optimize operations, contributing to decision-making for an efficient team environment. Ideal for analytical individuals passionate about the F&B industry.

Qualifications

• Bachelor’s degree in Mathematics, Statistics, or related field.
• At least 3 years of experience in the F&B industry.
• Advanced Excel skills required.

Responsibilities

• Analyze sales and revenue metrics to inform business decisions.
• Monitor food costs and supply chain performance.
• Identify customer behavior patterns for service improvements.

Skills

Communication

Problem-solving

Data analysis

Collaboration

Customer behavior analysis

Education

Bachelor’s degree (S1) in Mathematics, Statistics, or related field

Tools

Excel

Python

SQL

Job description

We’re looking for a skilled Data Analyst with a passion for numbers and a solid understanding of the Food & Beverage (F&B) industry. This role is ideal for someone who thrives on turning complex data into clear business insights and enjoys working cross-functionally with teams like operations, marketing, and finance.

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:

• Bachelor’s degree (S1) in Mathematics, Statistics, or a related quantitative field.
• At least 3 years of experience in the F&B industry or a relevant field.
• Advanced Excel skills, including formulas, pivot tables, dashboards, and charts.
• Experience working with relational databases (e.g., querying sales and inventory data).
• Basic programming knowledge for analysis using Python, SQL, or similar tools.
• Strong communication skills with the ability to explain technical findings to non-technical teams (managers, marketers).
• Problem-solving mindset with a keen eye for uncovering insights that drive business decisions.
• Collaborative attitude and experience working with cross-functional teams.

Note: Please include your expected monthly salary, your qualification type, notice period, and availability for outside hours when applying.

About A&W Restaurants Indonesia:

With over 200 stores and more than 5,000 employees, A&W Restaurants Indonesia is a leading player in the QSR food category. We foster a positive working environment and strive for excellence as a team.