Data Analyst- MIS

This role requires an experienced professional with 4-7 years of experience in data analysis and reporting, particularly within consumer-facing environments. The ideal candidate will use Advanced Excel and data visualization tools to generate meaningful dashboards, track KPIs, and provide business insights that enhance operational efficiency and customer experience.

Key Responsibilities:

• Design, maintain, and automate MIS reports and dashboards for daily, weekly, and monthly performance tracking across F&B outlets and retail stores.
• Analyze sales, footfall, inventory, pricing, and product performance data to identify trends and actionable insights.
• Collaborate with park-level and corporate teams to standardize data reporting and improve visibility across outlets.
• Track inventory movements, wastage, stock variances, and provide insights for better stock control and procurement planning.
• Support menu engineering, product mix analysis, pricing strategy, and promotional effectiveness using data models.
• Monitor key operational KPIs like Average Transaction Value, Per Capita Spend, Outlet Efficiency, Conversion Rates, etc.
• Ensure data accuracy and develop automated templates and dashboards using Advanced Excel and/or Power BI.
• Assist in forecasting and budgeting support for F&B and Retail functions through historical data analysis and trend modelling.
• Drive insights for new product launches, outlet performance comparisons, and customer consumption patterns.

Requirements:

• Graduate/Postgraduate in Commerce, Business, Statistics, or related field.
• 4-5 years of relevant experience in MIS/Data Analysis, preferably in retail, hospitality, or QSR environments.
• Proficiency in Advanced Excel (Power Query, Pivot Tables, Macros, Lookups, Dashboards, etc.) is mandatory.
• Strong analytical and storytelling skills with the ability to interpret operational data into business insights.