MIS Executive

JOB DESCRIPTION – MIS EXECUTIVE (MIS)

• *Job Title:** MIS Executive
• *Department:** Operations / MIS
• *Job Location:** Mumbai, Maharashtra
• *Employment Type:** Full\-Time
• *Experience:** 1–3 Years (Preferred)
• *Salary:** As per experience and industry standards

Job Summary

We are looking for a detail\-oriented and analytical MIS Executive responsible for preparing daily, weekly, and monthly reports, maintaining databases, tracking operational performance, and ensuring the accuracy of business data. The candidate should have strong MS Excel skills, good analytical abilities, and the capability to handle large volumes of data within deadlines.

Key Responsibilities1\. MIS Reporting \& Data Management

• Prepare and maintain daily, weekly, and monthly MIS reports.
• Generate operational, productivity, attendance, performance, and management reports.
• Collect, consolidate, verify, and analyse data from multiple sources.
• Maintain accurate records, databases, and reporting trackers.
• Ensure data accuracy, consistency, and timely submission of reports.
• Identify discrepancies, missing information, and data errors and resolve them promptly.
• Maintain proper documentation and historical records for future reference.

2\. Advanced MS Excel \& Reporting Tools

• Work extensively with MS Excel to manage and analyse large datasets.
• Use formulas such as VLOOKUP, XLOOKUP, INDEX\-MATCH, IF, SUMIF, SUMIFS, COUNTIF, and COUNTIFS.
• Create Pivot Tables, Pivot Charts, dashboards, and graphical reports.
• Apply conditional formatting, data validation, sorting, filtering, and data cleaning techniques.
• Automate repetitive reporting tasks wherever possible.
• Use Excel templates to streamline reporting and improve efficiency.
• Knowledge of Power Query, Power BI, Google Sheets, and basic VBA/macros will be an added advantage.

3\. Operational \& Performance Tracking

• Monitor daily productivity, targets, achievements, and pending activities.
• Maintain trackers for employee attendance, performance, task completion, and operational progress.
• Prepare reports highlighting achievements, shortfalls, and performance trends.
• Follow up with relevant departments to collect pending data and correct discrepancies.
• Track key performance indicators (KPIs) and prepare reports for management review.
• Support management in identifying operational gaps through data analysis.

4\. Data Analysis \& Management Support

• Analyse data to identify trends, patterns, errors, and areas for improvement.
• Prepare summaries and presentations for management meetings.
• Provide accurate data and insights to support business decisions.
• Develop and maintain dashboards for tracking important business metrics.
• Handle urgent reporting requirements and ad hoc data requests from management.
• Recommend improvements in reporting formats, processes, and data management practices.

5\. Coordination \& Documentation

• Coordinate with HR, Operations, Accounts, and other departments to obtain required information.
• Maintain proper records of reports, trackers, and supporting documents.
• Ensure reports are shared with the concerned stakeholders within stipulated timelines.
• Maintain confidentiality of company data and sensitive business information.
• Follow standard operating procedures (SOPs) for data handling and reporting.

Required Skills \& Competencies

• Strong knowledge of MS Excel, including advanced formulas and Pivot Tables.
• Good analytical, numerical, and problem\-solving skills.
• Excellent attention to detail and accuracy.
• Ability to manage multiple reports and meet strict deadlines.
• Good organisational and time\-management skills.
• Ability to work independently and coordinate with different departments.
• Good written and verbal communication skills.
• Strong understanding of data management and reporting processes.
• Ability to handle large datasets efficiently.

Educational Qualifications

• Graduate in any discipline.
• B.Com, BBA, BMS, B.Sc., or equivalent qualifications preferred.
• Candidates with relevant MIS, reporting, or data management certifications will have an added advantage.

Experience Requirements

• 1–3 years of experience in MIS reporting, data management, operations reporting, or a similar role preferred.
• Freshers with excellent MS Excel skills and strong analytical abilities may also apply.
• Experience in preparing daily productivity reports, dashboards, and operational trackers will be an advantage.

Preferred Technical Knowledge

• MS Excel – Advanced
• MS Word – Basic to Intermediate
• MS PowerPoint – Basic to Intermediate
• Google Sheets – Intermediate
• Power BI – Preferred
• Power Query and VBA/macros – Advantageous

Key Performance Indicators (KPIs)

The candidate's performance will be evaluated based on

• Accuracy and reliability of MIS reports.
• Timeliness of daily, weekly, and monthly reporting.
• Efficiency in data consolidation and analysis.
• Reduction in reporting errors and manual work.
• Quality of dashboards and management reports.
• Compliance with reporting deadlines.
• Effective coordination with internal departments.

Ideal Candidate Profile

The ideal candidate should be detail\-oriented, proficient in MS Excel, comfortable working with numbers, and capable of converting raw data into meaningful reports. The candidate must be proactive, organised, reliable, and committed to maintaining data accuracy and confidentiality.

• *Interested candidates can share their updated resumes along with their current salary, expected salary, notice period, and relevant MS Excel experience.**

Pay: ₹25,000\.00 \- ₹35,000\.00 per month

Work Location: In person