Job Title: MIS Executive
Department: Administration / Operations / Management Information Systems (MIS)
Industry: HVAC (Heating, Ventilation & Air Conditioning)
Employment Type: Full-Time
Job Summary
The MIS Executive is responsible for managing, analyzing, and maintaining organizational data to support business operations and decision-making. The role involves preparing MIS reports, maintaining project and sales data, coordinating with multiple departments, ensuring data accuracy, and providing timely reports to management. The ideal candidate should possess excellent Excel skills, strong analytical abilities, and experience in data management within the HVAC, MEP, or construction industry.
Key Responsibilities
- Prepare daily, weekly, and monthly MIS reports for management.
- Maintain and update sales, project, procurement, service, and inventory databases.
- Generate dashboards and performance reports using Microsoft Excel.
- Analyze operational data and present meaningful insights to management.
- Coordinate with Sales, Projects, Service, Accounts, Purchase, and HR departments for data collection.
- Ensure accuracy, consistency, and confidentiality of organizational data.
- Track project progress, order status, material movement, and service reports.
- Prepare project-wise and customer-wise performance reports.
- Maintain employee attendance, productivity, and departmental reports as required.
- Prepare reports for management meetings and business reviews.
- Assist in documentation, record management, and filing of project-related documents.
- Identify data discrepancies and coordinate with concerned departments for corrections.
- Support automation of reports and improve reporting processes.
- Perform other MIS and administrative tasks assigned by management.
Required Skills
- Advanced knowledge of Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, IF, SUMIFS, Charts, Conditional Formatting, Data Validation).
- Strong analytical and problem-solving skills.
- Good knowledge of MS Office (Word, PowerPoint, Outlook).
- Ability to prepare professional reports and dashboards.
- Excellent numerical and documentation skills.
- Strong communication and coordination abilities.
- Good organizational and time management skills.
- Ability to work under deadlines with high accuracy.
Qualification
- Bachelor's Degree in Commerce, Business Administration, Computer Applications, Information Technology, or a related field.
- Certification in Advanced Excel or MIS will be an added advantage.
Experience
- Experience: 1–3 years
- Experience in the HVAC, MEP, Construction, Engineering, or Manufacturing industry is preferred.
Preferred Knowledge
- Sales MIS and CRM reporting
- Project tracking and documentation
- Inventory and procurement reporting
- ERP software (Tally, SAP, Oracle, or similar ERP systems)
- Basic understanding of HVAC project workflows
Key Competencies
- Attention to Detail
- Data Analysis
- Report Preparation
- Time Management
- Team Collaboration
- Problem Solving
- Confidentiality and Integrity
- Process Improvement
Working Conditions
- Work Location: Office-based
- Working Days: Monday to Saturday
- Working Hours: As per company policy
Pay: ₹12,000.00 - ₹15,000.00 per month
Benefits:
Work Location: In person
