Data Analyst

Position Summary

Key Responsibilities

1. Collect, analyse and maintain daily production data across different central kitchen production units.
2. Prepare daily, weekly and monthly MIS reports, dashboards and performance summaries.
3. Monitor production planning versus actual output and identify production variances.
4. Analyse raw material consumption, yield, wastage and production costs.
5. Track inventory movement, stock levels, material usage and procurement requirements.
6. Monitor product-wise production efficiency, batch quantities and rejection rates.
7. Analyse food cost, recipe costing and material consumption trends.
8. Identify operational inefficiencies, data discrepancies and areas for cost optimisation.
9. Coordinate with production, procurement, inventory and quality teams to ensure accurate data collection.
10. Present meaningful insights and reports to management to support business decisions.

Required Skills & Competencies

• Strong proficiency in MS Excel, including Pivot Tables, VLOOKUP, XLOOKUP, SUMIFS and advanced formulas.
• Hands-on experience in MIS reporting and dashboard preparation.
• Knowledge of Power BI or other data visualisation tools.
• Strong understanding of production planning, inventory management and raw material consumption.
• Ability to analyse production yield, wastage, food costs and operational performance.
• Good analytical, numerical and problem-solving skills.
• Strong attention to detail and data accuracy.
• Ability to work with cross-functional teams.

Qualifications & Experience

• Bachelor's degree in Commerce, Business Administration, Statistics, Mathematics, Data Analytics or a related field.
• 3–4 years of relevant experience in Data Analysis or MIS Reporting.
• Prior experience in the food industry is mandatory.
• Experience in central kitchen operations, food production, food manufacturing or FMCG will be highly preferred.
• Practical understanding of production processes, inventory control and food costing.

Key Performance Indicators (KPIs)

• Accuracy and timely submission of production MIS reports.
• Monitoring and reduction of raw material wastage.
• Production yield and consumption variance analysis.
• Inventory and stock reconciliation accuracy.
• Identification of cost-saving opportunities.
• Improvement in production reporting and operational efficiency.