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.