Job Summary

The MIS Executive is responsible for collecting, analyzing, maintaining, and presenting business data to support management in decision-making. The role involves preparing daily, weekly, and monthly reports, maintaining databases, ensuring data accuracy, and coordinating with different departments for timely reporting.

Key Responsibilities (KRAs)1. Data Management

- Collect and compile data from various departments.
- Maintain accurate and updated databases.
- Ensure data integrity and confidentiality.
- Verify data accuracy before generating reports.

2. MIS Reporting

- Prepare Daily, Weekly, Monthly, and Annual MIS reports.
- Generate department-wise performance reports.
- Create management dashboards and presentations.
- Submit reports within defined timelines.

3. Excel & Data Analysis

- Prepare reports using advanced Microsoft Excel functions.
- Analyze business data to identify trends and performance indicators.
- Develop Pivot Tables, Charts, Dashboards, and MIS formats.
- Automate repetitive reporting wherever possible.

4. ERP/System Management

- Extract reports from ERP software.
- Update and maintain ERP records.
- Coordinate with departments for accurate ERP entries.
- Monitor data consistency between ERP and manual records.

5. Documentation & Record Keeping

- Maintain soft and hard copies of MIS reports.
- Archive historical data for future reference.
- Organize files and maintain proper documentation.

6. Coordination

- Coordinate with HR, Production, Purchase, Sales, Accounts, Stores,



and Quality departments for data collection.
- Follow up with departments for pending reports.
- Support management with ad-hoc reports and analysis.

7. Process Improvement

- Suggest improvements in reporting systems.
- Develop recent report formats based on management requirements.
- Assist in digitization and automation of reporting processes.

Required Qualifications

- Bachelor's Degree in Commerce, Business Administration, Computer Applications, Mathematics, Statistics, or a related field.
- Certification in Advanced Excel or Data Analytics is preferred.

Experience

- 2–4 years of experience in MIS reporting, data analysis, or ERP operations.
- Experience in a manufacturing industry is preferred.

Technical Skills

- Advanced Microsoft Excel (VLOOKUP/XLOOKUP, INDEX-MATCH, Pivot Tables, Pivot Charts, Conditional Formatting, IF Functions, Data Validation, Power Query).
- Microsoft Word.
- Microsoft PowerPoint.
- ERP Software.
- Basic SQL knowledge (preferred).
- Power BI or Tableau (preferred).

Key Competencies

- Strong analytical and problem-solving skills.
- Excellent numerical aptitude.
- High attention to detail and accuracy.
- Good communication and coordination skills.
- Time management and ability to meet deadlines.
- Strong organizational skills.
- Ability to handle confidential information.
- Quick learner with a proactive attitude.

PREFERENCE: MALE/FEMALE
CONTACT : 941770625 (HR) (WHATSAPP)

Pay: ₹25,000.00 - ₹30,000.00 per month

Work Location: In person

📌 MIS Executive (India)
🏢 FINE SWITCHGEARS
📍 India