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 Benefits
· 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 : 9274396214
Pay: ₹15,000.00 - ₹30,000.00 per month
Benefits:
Work Location: In person
