Data Analyst

A&W Restaurants Indonesia; Jakarta Utara; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading restaurant company in Indonesia is seeking a skilled Data Analyst to analyze sales, inventory, and customer behavior to drive business decisions. The ideal candidate will hold a relevant bachelor's degree and have over 3 years of experience in the F&B industry, with advanced Excel skills and understanding of relational databases. A collaborative attitude is essential in this dynamic environment.

Qualifications

• At least 3 years of experience in F&B or relevant industry.
• Experience with relational databases for sales and inventory data.
• Collaborative attitude and experience with cross-functional teams.

Responsibilities

• Track and interpret key metrics for sales and revenue analysis.
• Monitor food costs and inventory turnover.
• Analyze customer behavior and operational efficiency.

Skills

Advanced Excel skills

Data analysis

Strong communication

Problem-solving mindset

Education

Bachelor’s degree in Mathematics, Statistics, or related field

Tools

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). 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:

Sales & Revenue Analysis: Track and interpret key metrics such as average order value, sales per item, and revenue trends.

Inventory & Supply Chain Analysis: Monitor food costs, wastage, and inventory turnover to optimize supply chain performance.

Customer Behavior Analysis: Identify patterns in customer preferences, peak hours, and feedback for improved service and retention.

Operational Efficiency: Analyse data on staffing, kitchen output, and delivery times to improve day-to-day operations.

Menu Engineering: Evaluate item profitability and popularity to support strategic menu decisions.

Cost of Goods Sold (COGS): Assess how raw material costs influence profit margins.

Seasonality & Promotions: Analyse the impact of holidays, seasons, and marketing campaigns on sales performance.

POS Systems: Work with data from systems to derive actionable insights.

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 or relevant industry.

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.

How many years' experience do you have as a data analyst?

What's your expected monthly basic salary?

Which of the following types of qualifications do you have?

How much notice are you required to give your current employer?

Are you available to work outside your usual hours when required? (e.g. weekends, evenings, public holidays)

Hospitality & Tourism More than 10,000 employees

A&W Restaurants Indonesia is Indonesia’s leading Restaurant Company with over 200 stores, and still growing. Over 5000 employees help ensure our Restaurants operate effectively so our customers get the service and products they deserve. Our restaurant brand – A&W Restaurants – is one of the global leaders of QSR food category.

With positive working environment, we strive together as a team to achieve best results.

A&W Restaurants Indonesia is Indonesia’s leading Restaurant Company with over 200 stores, and still growing. Over 5000 employees help ensure our Restaurants operate effectively so our customers get the service and products they deserve. Our restaurant brand – A&W Restaurants – is one of the global leaders of QSR food category.

With positive working environment, we strive together as a team to achieve best results.