F&B Data Analyst: Insights, Ops & Growth

A&W Restaurants Indonesia; Jakarta Utara; On-site; IDR 120,000,000 - 180,000,000; Full time

Job summary

A&W Restaurants Indonesia is seeking a Data Analyst who loves numbers and can turn data into actionable business insights. This role partners with operations, marketing and finance to support decision making.

Focus areas include sales analysis, inventory control, customer behavior, and menu profitability with strong Excel, SQL and Python skills for relational data handling. We value a collaborative mindset, clear communication of findings, and a proactive approach to improving efficiency in a

Qualifications

• Bachelor’s degree 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 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.

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.
• 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.

Skills

Advanced Excel

SQL

Python

Data analysis

Communication

Problem solving

Cross-functional collaboration

Education

Bachelor's degree in Mathematics

Bachelor's degree in Statistics

Related quantitative field

Tools

Pivot Tables

Dashboards

Relational databases

Job description

A&W Restaurants Indonesia is seeking a Data Analyst who loves numbers and can turn data into actionable business insights. This role partners with operations, marketing and finance to support decision making.

Focus areas include sales analysis, inventory control, customer behavior, and menu profitability with strong Excel, SQL and Python skills for relational data handling. We value a collaborative mindset, clear communication of findings, and a proactive approach to improving efficiency in a