Data Analyst

JAPFA FOOD INDONESIA; Jakarta Barat; On-site; IDR 180,000,000 - 260,000,000; Full time

Job summary

JAPFA FOOD INDONESIA is seeking a data analytics professional to collect, consolidate, and analyze sales and promotion data. You will monitor promotion performance, analyze trends, and prepare dashboards to provide actionable insights for sales and marketing teams.

The role emphasizes translating complex data into clear business recommendations, with a focus on ROI assessment and cross-department collaboration in a fast-paced FMCG environment.

Qualifications

• Bachelor’s degree in Statistics, Mathematics, Data Science, IT, or related field.
• Experience in data analysis, preferably in Sales, Trade Marketing, or FMCG industries.
• Strong analytical and problem-solving skills.
• Proficient in Excel (Pivot Tables, VLOOKUP/XLOOKUP) and data visualization tools like Power BI or Tableau.
• Familiarity with SQL and database management is a plus.
• Able to translate data into clear business insights and work with large datasets.

Responsibilities

• Collect, consolidate, and analyze sales and promotion data to support decisions.
• Monitor and evaluate promotion performance, including spend and campaign effects.
• Analyze trends in sales and customer behavior to find opportunities.
• Prepare regular sales performance reports and dashboards with actionable insights.
• Evaluate ROI of sales promotion activities and identify improvement areas.
• Collaborate with Sales, Marketing, and other departments on data-driven initiatives.

Skills

Data analysis

Sales analytics

SQL

Excel

Power BI

Tableau

Education

Bachelor's degree in Statistics/Mathematics/Data Science/IT

Tools

Power BI

Tableau

Job description

Key Responsibilities

• Collect, consolidate, and analyze sales and sales promotion data to support business decision‑making.
• Monitor and evaluate sales promotion performance, including promotional spending, sales uplift, and campaign effectiveness.
• Analyze sales trends, customer purchasing behavior, and promotional results to identify business opportunities.
• Prepare regular sales performance reports and dashboards to provide actionable insights.
• Evaluate the effectiveness and ROI of sales promotion activities.
• Identify gaps, trends, and improvement opportunities in promotional strategies.
• Collaborate with Sales, Marketing, and other related departments to support data‑driven business initiatives.

Requirements

• Bachelor's degree in Statistics, Mathematics, Data Science, Information Technology, or a related field.
• Experience in data analysis, preferably in Sales, Trade Marketing, or FMCG industries.
• Strong analytical and problem‑solving skills.
• Proficient in Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP) and data visualization tools such as Power BI or Tableau.
• Familiarity with SQL and database management is an advantage.
• Able to translate complex data into clear and actionable business insights.
• Detail‑oriented, proactive, and comfortable working with large datasets.