In short
Data Analyst at JAPFA Food (on-site, West Jakarta) who collects and analyzes sales and sales-promotion data, evaluates campaign effectiveness and ROI, and builds performance reports and dashboards. Core tooling is Excel plus Power BI/Tableau, with SQL as an advantage.
About the role
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.
Requirements
- Bachelor's degree in Statistics, Mathematics, Data Science, Information Technology, or 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)
- Proficient in data visualization tools such as Power BI or Tableau