Job Description – MIS Executive

Position: MIS Executive
Location: Vadodara
Experience: 2–5 Years
Qualification: Graduate with advanced Excel knowledge

· Bachelor’s Degree (B.Com, BBA, BCA, B.Sc., or equivalent)

· Advanced knowledge of Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Power Query, Dashboards)

· Knowledge of Google Sheets and ERP/CRM software is preferred.

Job Location

Vadodara, Gujarat

Job Summary

The MIS Executive is responsible for preparing, maintaining, and analyzing business reports to support management decision-making. The role involves handling sales, collections, inventory, customer, and operational data, ensuring data accuracy, generating daily/weekly/monthly MIS reports, and coordinating with different departments.

Key ResponsibilitiesMIS & Reporting

· Prepare Daily, Weekly, and Monthly MIS reports.

· Generate reports related to sales, bookings, collections, cancellations, and pending payments.

· Create management dashboards using Excel and Google Sheets.

· Maintain accurate records and ensure data consistency.

Data Management

· Update customer, project, inventory, and sales databases.

· Verify and clean data received from various departments.

· Ensure timely and error-free data entry.

· Maintain master data in ERP/CRM systems.

Sales & Collection MIS

· Prepare daily sales reports.

· Generate collection and outstanding payment reports.

· Track booking status, agreement status, and registration status.

· Monitor sales performance against targets.

Inventory & Project MIS

· Maintain project-wise inventory availability reports.

· Track sold, blocked, reserved, and available units.





· Prepare project progress reports as required by management.

Coordination

· Coordinate with Sales, Accounts, CRM, Legal, and Project teams for data collection.

· Follow up with departments for pending information.

· Support management with ad-hoc reports and business analysis.

Documentation

· Maintain digital records of reports and business documents.

· Ensure confidentiality of company data.

· Archive historical MIS reports for future reference.

Required Skills

· Advanced Microsoft Excel

· Google Sheets

· Data Analysis & Reporting

· Dashboard Preparation

· ERP/CRM Software

· Strong Analytical Skills

· Excellent Attention to Detail

· Good Communication Skills

· Time Management

· Problem-Solving Ability

Key Performance Indicators (KPIs)

· Accuracy of MIS reports

· Timely submission of reports

· Data accuracy and consistency

· Dashboard update frequency

· Report turnaround time

· Support provided to management and departments

· Reduction in reporting errors

Preferred Knowledge

· Real estate sales process

· Booking and inventory management

· CRM and ERP software

· Basic accounting concepts

· Data visualization and automation tools (Power BI preferred)

Working Conditions

· Office-based role

· Six-day working week (as per company policy)

· Reporting to the Operations Head / Management

Company Advantages

· Competitive Salary

· Performance-Based Incentives (if applicable)

· Paid Leave as per Company Policy

· Career Growth Opportunities

· Professional Development and Training

Salary

As per company standards and candidate experience.

Contact No : +91-XXXXXXXXXX

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

Benefits:

- Provident Fund

Work Location: In person

📌 MIS Executive (India)
🏢 SPARK INFRAMARK PRIVATE
📍 India