Mis Executive

MIS Resource Smart Team

The ideal candidate will be responsible for creating and maintaining data formats, generating daily and weekly MIS reports, and supporting business decision-making through insightful analysis. The role requires a strong command over Excel and other data analysis tools.

---

Key Responsibilities:

• Develop, maintain, and improve daily, weekly, and monthly MIS reports for sales, inventory, and operations.
• Collate and analyse data from various sources – retail channels and Ecommerce, and ERP tools that will include reports on sales, inventory and pricing
• Create Excel dashboards and templates for tracking KPIs such as sell-through rate, stock availability, channel-wise performance, variant lists, pricing changes, etc.
• Work closely with Sales, Marketing, Inventory, and Product and Channel MIS teams to understand data, trends and reporting needs and develop customized solutions.
• Analyze historical and real-time data to identify trends, gaps, and opportunities.
• Provide actionable insights to management to support data-based strategic and operational decisions.
• Ensure data accuracy, consistency, and integrity across all reports.
• Automate repetitive reporting tasks wherever possible using Excel formulas, VBA/macros, or Power Query.
• Support ad-hoc reporting and analysis requests as required by the Smart team.

---

Key Requirements:

• Bachelor’s degree in Commerce, Business, Statistics, or related field.
• 2–4 years of relevant experience in MIS / Data Analysis, preferably in retail or e-commerce industry.
• Strong proficiency in Microsoft Excel is a must (formulas, pivot tables, charts, dashboards, data validation, Power Query, and macros/VBA).
• Working knowledge of:
• Google Sheets
• Power BI or Tableau (preferred but not mandatory)
• SQL (basic knowledge is a plus)
• Understanding of data from e-commerce platforms, Retail POS, and ERP systems.
• Strong analytical and problem-solving skills.
• Attention to detail and high level of data accuracy.
• Good communication skills for cross-functional collaboration.

---

Preferred Tools:

• Microsoft Excel (Advanced)
• Google Sheets
• Power BI / Tableau
• Microsoft Power Query
• SQL (basic)
• Desirable
• Retail POS / ERP Systems (SAP)
• E-commerce dashboards (Amazon Seller Central, Flipkart panels, etc.)