Job Role

- MIS Analyst

- Prepare and maintain daily, weekly, and monthly MIS reports.
- Collect, consolidate, validate, and analyze data from different departments.
- Maintain accurate databases and Excel records.
- Prepare management reports covering sales, productivity, performance, achievement, and variance.
- Create Excel dashboards, Pivot Tables, charts, and performance trackers.
- Monitor KPIs and provide meaningful performance summaries to management.
- Identify data discrepancies, errors, and missing information and coordinate with relevant teams for corrections.
- Ensure timely data collection and reporting from internal departments.
- Maintain confidentiality and accuracy of business information.
- Support management with data analysis and reporting for effective decision-making.

Key Responsibilities MIS Reporting:

- Prepare daily, weekly, and monthly MIS reports.
- Prepare Achievement, Performance, Sales, Productivity, and Variance reports.
- Maintain proper reporting formats and documentation.
- Provide reports and data to management whenever required.

Data Management

- Collect and consolidate data from various departments.
- Validate data for accuracy and completeness.
- Maintain updated databases and Excel records.
- Handle large volumes of business data efficiently.




- Identify missing or incorrect information and coordinate for corrections.

Excel & Dashboard Management

- Create and maintain Excel dashboards.
- Develop Pivot Tables, charts, trackers, and data visualizations.
- Use advanced Excel functions for data analysis and reporting.

KPI & Performance Analysis

- Monitor key performance indicators (KPIs).
- Analyze sales, productivity, achievement, and performance data.
- Prepare performance summaries for management.
- Highlight important trends, discrepancies, and areas requiring attention.

Coordination

- Coordinate with internal departments for timely data collection.
- Follow up for pending or missing information.
- Ensure reports are prepared and submitted within deadlines.

Required Skills

- Strong knowledge of MS Excel.

- Proficiency in

- VLOOKUP

- COUNTIFS

- Pivot Tables

- Charts

- Conditional Formatting
- Knowledge of Excel Dashboards and Data Visualization.
- Strong analytical and numerical skills.
- Excellent attention to detail.
- Valuable communication and coordination skills.
- Ability to handle large volumes of data.
- Strong time-management and organizational skills.

📌 MIS Executive, Andheri East (Mumbai)
🏢 JobTrade
📍 Mumbai