Data Analyst

BRIK OVEN PRIVATE LIMITED; Doddaballapura; On-site; INR 600,000 - 900,000; Full time

Job summary

Brik Oven Private Limited is seeking an experienced Data Analyst to analyse production data, monitor raw material consumption, track inventory and wastage, and prepare MIS reports to improve efficiency and cost control across central kitchen operations.

You will work with cross-functional teams, design dashboards in Power BI, and leverage advanced Excel techniques to deliver timely insights to management.

Qualifications

• 3-4 years of 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 preferred.

Responsibilities

• Collect, analyse and maintain daily production data across central kitchen units.
• Prepare daily, weekly and monthly MIS reports, dashboards and summaries.
• Monitor production planning versus actual output and identify variances.
• Analyse raw material consumption, yield, wastage and production costs.
• Track inventory movement, stock levels and procurement needs.
• Monitor product-wise production efficiency, batch quantities and rejection rates.
• Analyse food cost, recipe costing and material consumption trends.
• Identify data discrepancies and opportunities for cost optimisation.
• Coordinate with production, procurement, inventory and quality teams to ensure accurate data collection.
• Present insights and reports to management to support decisions.

Skills

MS Excel

Pivot Tables

VLOOKUP

XLOOKUP

SUMIFS

Advanced formulas

Cross-functional collaboration

Education

Bachelor's degree in Commerce, Business Admin, Statistics, Mathematics, Data Analytics or related field

Tools

Power BI

Job description

Experience: 3-4 Years

Employment Type: Full-time

Position Summary

Brik Oven Private Limited is looking for an experienced and analytical Data Analyst with 3-4 years of experience in the food industry, preferably in food manufacturing, central kitchen operations or FMCG.

The candidate will be responsible for analysing production data, monitoring raw material consumption, tracking inventory and wastage, and preparing reports to improve operational efficiency, productivity and cost control across central kitchen operations.

Key Responsibilities

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