Mis Executive

DMart; Bhopal, Raipur; On-site; INR 600,000 - 900,000; Full time

Job summary

DMart in India seeks an MIS/Reports Analyst to prepare daily, weekly, and monthly sales performance reports using advanced Excel skills—including pivot tables, VLOOKUP/HLOOKUP, and MIS data. The role involves developing MIS reports for sales, inventory, and customer insights, analyzing data to support business decisions, and collaborating across teams to ensure timely, high-quality outputs.

The ideal candidate has 3–8 years of experience in MIS operations with strong Excel/reporting abilities

Qualifications

• 3–8 years of experience in a similar role with proficiency in MIS operations and advanced Excel skills.
• Strong understanding of MS Office applications particularly Excel Report Preparation.

Responsibilities

• Prepare daily, weekly, and monthly reports on sales performance using advanced Excel skills such as pivot tables, HLOOKUP, VLOOKUP, conditional formatting, and MIS.
• Develop expertise in preparing various MIS reports including sales, inventory, and customer reports.
• Utilize Excel functions to analyze data and create insightful reports that drive business decisions.
• Collaborate with cross-functional teams to gather requirements for report preparation and ensure timely delivery of outputs.
• Troubleshoot issues related to report generation and provide solutions to resolve them efficiently.

Skills

Advanced Excel

Pivot tables

VLOOKUP

HLOOKUP

Conditional formatting

MIS reporting

Data analysis

Tools

MS Excel

Job description

Roles and Responsibilities

• Prepare daily, weekly, and monthly reports on sales performance using advanced Excel skills such as pivot tables, HLOOKUP, VLOOKUP, conditional formatting, and management information systems (MIS).


• Develop expertise in preparing various types of MIS reports including sales reports, inventory reports, customer reports, etc.


• Utilize Excel's built-in functions to analyze data and create insightful reports that drive business decisions.


• Collaborate with cross-functional teams to gather requirements for report preparation and ensure timely delivery of high-quality outputs.


• Troubleshoot issues related to report generation and provide solutions to resolve them efficiently.

Desired Candidate Profile

• 3-8 years of experience in a similar role with proficiency in MIS operations and advanced Excel skills.


• Strong understanding of MS Office applications particularly Excel Report Preparation.


• Ability to work independently with minimal supervision while maintaining attention to detail and meeting deadlines.