Gemba Concepts logo

MIS Analyst

Gemba Concepts

2 - 4 years

Hyderabad

Posted:4 hours ago

Job Description

Job Description: MIS Analyst Dadus Sweets & Snacks | Hyderabad | Full-time Own accurate, timely analysis and operational reporting for Dadus central kitchen and 9+ retail stores. Reconcile sales, indents, production, inventory, and dispatch data, then explain the variances and actions behind the numbers. Key responsibilities Reporting ownership. Own the daily and weekly reporting calendar for sales, indents, production, dispatch, stock, returns and wastage. Escalate missing inputs before publication. Data reconciliation. Reconcile ERP, POS and operating records using source totals. Investigate duplicate lines, unmatched transactions and differences in dates or units of measure. ¢ Master data controls. Maintain SKU, store, category and production-section mappings. Document approved changes and verify how they affect historical comparisons. ¢ KPI definitions and validation. Maintain calculation rules for quantity fill rate (QFR), stockouts, returns and wastage. Define how each measure treats missing indents and special orders. ¢ Dispatch performance analysis. Publish QFR by store, SKU and production section. Rank the largest contributors to shortfalls within comparable units. ¢ Retail and festival analysis. Compare sales, product mix and availability with prior periods and comparable festival days. Quantify the contribution of individual stores and SKUs to changes. ¢ Inventory and loss analysis. Track ageing stock, expiry exposure, returns and wastage by batch where data is available. Quantify losses by reason and flag recurring patterns. ¢ Variance investigation. Trace material variances to source records and confirm causes with operating teams. Record corrections and show the impact on published figures. ¢ Dashboard and reporting automation. Build drill-down dashboards and automate repeatable data checks using Excel or Power Query. Document refresh steps and retain versioned source files. ¢ Management reporting. Summarise material variances, likely causes and decisions needed for daily and weekly reviews. Track recurring issues and check whether corrective actions reduced them. Required qualifications and skills ¢ 24 years of hands-on MIS or data analysis in food, sweets, bakery, FMCG, retail or supply chain; evidence of analytical insight beyond routine report preparation. ¢ Advanced Excel: PivotTables, SUMIFS, lookups, conditional formatting, Power Query or equivalent data transformation, and robust dashboards. Able to audit formulas and reconcile large datasets. ¢ Experience joining multiple data sources, maintaining master data and defining metrics consistently; ability to perform trend, variance and root-cause analysis at SKU and store level. ¢ Strong accuracy and deadline ownership; able to trace a variance to source data and explain its operational impact. ¢ Clear written and spoken English and Hindi; able to explain data issues and findings to store, kitchen and management teams. Preferred ¢ Power BI, ERP and POS reporting; familiarity with perishable inventory, dispatch and QFR metrics.

Skills Required

MIS Analysis Analysis Excel Advanced Excel KPI KPI analysis Master data MIS

Learn the skills this job asks for

See your skill gap for Data Analyst →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Gemba Concepts logo
Gemba Concepts

RecommendedJobs for You

Gemba Concepts logo

MIS Analyst

Gemba Concepts

Hyderabad

E

MIS Analyst

Eclat Health Solutions

Hyderabad

I

MIS Analyst

Immunosciences

Delhi

TP logo

Noida

TP logo

Mohali

V

MIS Analyst

Vibgyor Innovations Pvt Ltd

Delhi

Gemba Concepts logo

MIS Analyst

Gemba Concepts

Hyderabad

E

MIS Analyst

Eclat Health Solutions

Hyderabad

I

MIS Analyst

Immunosciences

Delhi