MIS Executive

Role Overview :-

We are looking for an MIS Executive who can turn raw business data into clear reports, dashboards and presentations that leaders can act on. The ideal candidate is strong in Excel, comfortable building crisp PowerPoint decks, and curious about using AI tools to automate reporting and speed up analysis.

KEY RESPONSIBILITIES

- Prepare and circulate daily, weekly and monthly MIS reports covering sales, inventory, retail/store performance, marketing, logistics and finance.
- Build and maintain Excel dashboards, trackers and models using advanced formulas, Pivot Tables and charts.
- Collect, clean, consolidate and validate data from multiple sources (ERP, CRM, e-commerce platforms, store reports, Google Sheets).
- Create clear, visually polished PowerPoint presentations for management reviews, business reviews and leadership updates.
- Automate repetitive reporting using Excel features (Power Query, macros) and AI tools to save time and reduce manual errors.
- Use AI tools (e.g., ChatGPT, Claude, Copilot, Gemini) for data analysis, summarization, formula generation, report drafting and insight generation.
- Analyze trends, variances and anomalies, and highlight key insights and recommended actions to stakeholders.
- Ensure data accuracy, consistency and integrity across all reports; maintain documentation of report logic and processes.
- Coordinate with Sales, Supply Chain, Marketing, Finance and Retail teams to gather inputs and meet reporting deadlines.
- Handle ad-hoc data requests and support leadership with quick turnaround analysis.





REQUIRED SKILLS

Excel (Must Have)

- Advanced formulas: VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, nested logic, text and date functions
- Pivot Tables, Pivot Charts, slicers and conditional formatting
- Data cleaning, validation and dashboard creation
- Working knowledge of Power Query; Macros/VBA is a plus

PowerPoint (Must Have)

- Ability to build structured, professional decks with charts, tables and clean layouts
- Storytelling with data: turning numbers into clear, concise insights
- Strong attention to formatting and brand consistency

AI Tools (Must Have)

- Hands-on experience with AI tools for analysis, reporting, content drafting and automation
- Good prompting skills to get accurate, usable outputs
- Ability to verify AI outputs and use them responsibly with business data

Good to Have

- Power BI, Tableau or Looker Studio
- Basic SQL
- Google Sheets / Apps Script
- Exposure to retail, D2C or e-commerce reporting

QUALIFICATIONS

- Bachelors degree in Commerce, Statistics, Business Administration, Engineering or a related field (MBA/PGDM is a plus).
- 13 years of experience in MIS, reporting or data analysis (strong freshers with proven Excel and AI skills may also be considered).

KEY COMPETENCIES

- Strong analytical and problem-solving ability
- High attention to detail and commitment to accuracy
- Clear written and verbal communication
- Ownership, reliability and ability to meet deadlines
- Adaptability and eagerness to learn current tools
- Good cross-functional collaboration

📌 Mis Executive (Mumbai)
🏢 The Sleep
📍 Mumbai