Job descriptionJob Summary:

We are looking for a skilled and detail-oriented MIS Executive (also referred to as a Data Management Executive) to manage, analyze, and maintain critical business data using Excel and other spreadsheet-based tools. The ideal candidate must be highly proficient in Microsoft Excel, with a strong understanding of formulas, functions, and data analysis techniques.

This role involves creating dashboards, generating reports, maintaining data accuracy, and supporting the management team with actionable insights for better decision-making.

Key Responsibilities:

• Collect, organize, and maintain business data from various departments and systems.
• Create and maintain Excel-based dashboards, MIS reports, and trackers.
• Use advanced Excel formulas (VLOOKUP, HLOOKUP, IF, SUMIF, COUNTIF, INDEX-MATCH, etc.) for data analysis.
• Develop and implement Pivot Tables for summarizing and visualizing large data sets.
• Automate repetitive reporting tasks using Macros and basic VBA (preferred).
• Clean and validate data to ensure accuracy, integrity, and completeness.
• Provide timely and accurate reports to management and stakeholders.
• Identify trends, discrepancies, and actionable insights from data.
• Collaborate with teams (such as sales, inventory, accounts) to understand data needs and improve reporting.
• Maintain documentation of processes, templates, and standard operating procedures related to MIS.

Skills and Qualifications:

• 3–5 years of proven work experience as an MIS Executive or Data Analyst.
• Proficient in Microsoft Excel – must know formulas, pivot tables, charts, and formatting.
• Working knowledge of Google Sheets and its collaboration tools is a plus.
• Familiarity with Macros/VBA scripting for automation (preferred).
• A basic understanding of databases or ERP systems is an added advantage.
• Educational background in Mathematics, Statistics, Commerce, or Computer Applications is preferred.
• Strong analytical and problem-solving skills.
• Attention to detail with the ability to spot errors and inconsistencies.
• Good communication skills – must be able to explain reports to non-technical users.

Preferred Candidate Attributes:

• Highly organized and disciplined with a focus on data accuracy.
• Able to handle confidential and sensitive data with integrity.
• Willing to learn and adapt to new tools and systems as required.
• Strong work ethic and ability to manage time effectively in a deadline-driven environment.

What We Offer:

• A structured and professional work environment.
• Exposure to data-driven decision-making at a business level.
• Opportunities for skill enhancement and training.
• Career growth based on performance and contribution.