Back Office MIS Executive

We are seeking a detail-oriented and analytical MIS Executive to manage data reporting, business analysis, dashboard creation, and operational reporting. The ideal candidate should have strong expertise in Microsoft Excel, data management, report automation, and coordination with cross-functional teams to support business decision-making.

Key Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports.

• Analyze sales, inventory, employee, and operational data to identify trends and provide actionable insights.

• Design and maintain dashboards using advanced Excel.

• Generate management reports, KPI reports, and performance trackers.

• Ensure data accuracy, integrity, and timely submission of reports.

• Coordinate with Sales, Accounts, HR, Operations, and Management for data collection and validation.

• Automate recurring reports using Excel functions, Pivot Tables, Power Query, and Macros (preferred).

• Monitor business performance and highlight deviations to management.

• Maintain master databases and ensure proper documentation.

• Support management with ad-hoc reports and business analysis.

• Identify process improvement opportunities through data analysis.

Required Skills

• Advanced Microsoft Excel (Mandatory)

  • Pivot Tables

  • VLOOKUP/XLOOKUP

  • INDEX-MATCH

  • IF, SUMIFS, COUNTIFS

  • Conditional Formatting

  • Data Validation

  • Charts & Dashboards

  • Power Query (Preferred)

  • Macros/VBA (Preferred)

• Strong analytical and problem-solving skills.

• Excellent attention to detail and accuracy.

• Good communication and coordination skills.

• Ability to work under deadlines and handle multiple reports.

Qualification

• Bachelor's degree in Commerce, Business Administration, Computer Applications, Mathematics, Statistics, or a related field.

• Certification in Advanced Excel, Power BI, or Data Analytics will be an added advantage.

Experience

• 2–5 years of experience as an MIS Executive, MIS Analyst, or Data Analyst.

• Experience in FMCG, Distribution, Retail, E-commerce, or Manufacturing industries will be preferred.

Preferred Technical Skills

• Microsoft Excel (Advanced)

• Power BI

• Google Sheets

• SQL (Basic knowledge preferred)

• ERP Systems (SAP, Oracle, Busy, Tally, or similar)

• Microsoft PowerPoint

Key Competencies

• Analytical Thinking

• Data Interpretation

• Reporting & Documentation

• Time Management

• Problem Solving

• Team Collaboration

• Business Acumen

Salary

₹20,000 – ₹25,000 per month (Depending on experience and skills)

Preferred Candidate Profile

• Strong reporting and analytical background.

• Experience in handling large datasets.

• Ability to automate reporting processes.

• Excellent organizational and multitasking abilities.

• Immediate joiners will be preferred.

• It is a Full Time Back Office / Data Entry job for candidates with 6 months - 1 years of experience.