MIS Executive – Retail/Store Operations

Daily & Periodic Reporting Prepare and circulate the daily sales flash report (storewise sales, LFL growth, footfall/invoices, basket value) to Store Operations and Commercial leadership within the agreed daily cut-off. Compile the weekly and monthly Storewise Summary (A3 pack) covering Sales, LFL/NLFL performance, SP%, Promo%, HD% and growth vs target across all regions and stores. Own the month-end MIS pack, consolidating sales, KPI and scorecard data for review with Regional and Head Office leadership. Home Delivery & Area Manager Scorecard Build and maintain the weekly Area Manager scorecard for home delivery, covering AOV, ASP, UPT, Cancellation %, Out-of-Stock % and Processing TAT (Min), with a weighted Final Score against the regional target. Validate scorecard inputs against source systems (POS, OMS/delivery app, WMS) before publishing; investigate and resolve data discrepancies. Flag Area Managers and stores falling below target, and work with Store Operations to translate scorecard gaps into SMART action plans, tracking status and % completion weekly until KPIs recover. Maintain the RAG (Red/Amber/Green) status of each store/region against target and escalate persistent under-performance. Dashboards, Analysis & Automation Design and maintain Excel/Power BI dashboards for sales, KPI and home delivery performance, ensuring they update reliably and are easy for non-technical users to read. Conduct variance, trend and root-cause analysis on underperforming KPIs (e.g. rising cancellations, out-of-stock spikes, slipping processing TAT) and present findings with recommended actions. Automate recurring reports and templates to reduce manual effort and turnaround time, and maintain a single source of truth for KPI definitions and calculation logic. Support ad hoc data requests and deep-dive analysis from Commercial, Category and Regional teams. Governance & Stakeholder Coordination Coordinate with Store Operations, Category/Commercial, Supply Chain and IT to ensure clean, complete and timely data feeds into all reports. Maintain version-controlled documentation of report logic, scorecard weightings and KPI targets, and communicate any methodology changes clearly to stakeholders. Present weekly/monthly performance summaries in review meetings with Regional Managers and Area Managers.

Desired Candidate Profile

Advanced Excel (formulas, pivot tables, Power Query, dashboard building) — essential. Working knowledge of Power BI, SQL or similar BI/reporting tools — preferred. Strong analytical mindset with high attention to detail and data accuracy. Ability to translate numbers into clear, actionable insight for non-technical stakeholders. Well organised and comfortable working to daily/weekly reporting deadlines under time pressure. Clear written and verbal communication skills; confident presenting performance data to store and regional leadership. Retail/home-delivery KPI literacy — understands what drives AOV, ASP, UPT, cancellations, stock availability and delivery TAT. Employment Type Full-time

Keywords