Mis Executive

sasteghar.com; Mohali; On-site; INR 600,000 - 1,000,000; Full time

Job summary

sasteghar.com is seeking a detail-oriented MIS Executive to manage business data, prepare reports, maintain dashboards, and support management in tracking performance. Strong Excel skills and data accuracy are essential for coordinating with multiple departments to ensure timely reporting.

The role involves on-site work at Sector 68, Mohali, with standard full-time working days. Candidates should be adept at creating dashboards and delivering reliable data insights to drive business decisions.

Qualifications

• Graduate in Commerce, Business Administration, Statistics, Mathematics, IT or related field.
• 14 years of MIS reporting and data management experience preferred.
• Strong knowledge of Advanced Excel and Google Sheets.
• Excellent analytical and numerical problem-solving skills.
• Good attention to detail and data accuracy.
• Strong coordination, communication, and time-management skills.
• Knowledge of Power BI and dashboard automation will be an added advantage.
• Experience in real estate, sales, or service-based organizations will be preferred.

Responsibilities

• Prepare daily, weekly, and monthly MIS reports.
• Collect, compile, verify, and maintain data from different departments.
• Maintain accurate records of business activities, targets, and achievements.
• Ensure data accuracy, consistency, and timely submission of reports.
• Identify discrepancies and resolve data-related issues.
• Create and maintain Excel sheets, dashboards, trackers, and performance reports.
• Use advanced Excel functions such as Pivot Tables, VLOOKUP/XLOOKUP, IF, SUMIFS, and COUNTIFS.
• Develop automated reports to reduce manual work and improve efficiency.
• Maintain Google Sheets and other reporting tools as required.
• Present complex data in a clear and easy-to-understand format.
• Monitor sales team performance, targets, achievements, and productivity.
• Track leads, follow-ups, conversions, and sales progress.
• Prepare target-versus-achievement reports for management review.
• Maintain department-wise performance trackers and business data.
• Highlight performance gaps and provide relevant data insights to management.
• Coordinate with Sales, HR, Operations, Accounts, and other departments for data collection.
• Follow up with department heads and team members for pending reports and updates.
• Ensure all departments submit accurate information within defined timelines.
• Communicate reporting requirements and maintain standardized reporting formats.
• Support management in monitoring departmental activities and performance.
• Prepare management reports, summaries, and presentations.
• Maintain proper documentation of reports, trackers, and historical data.
• Analyze business trends and identify discrepancies or areas for improvement.
• Ensure data confidentiality and controlled access to business information.
• Support management in decision-making through accurate reports and data analysis.

Skills

Advanced Excel

Google Sheets

Data Analysis

Dashboarding

Reporting

Coordination

Time management

Power BI

Education

Bachelors in Commerce

Bachelors in Business Administration

Bachelors in Statistics

Bachelors in Mathematics

Tools

Power BI

Job description

Department: Executive Office / Administration*

Designation: MIS Executive

Industry: Real Estate Advisory

Job Location: Sector 68, Mohali, Punjab

Working Days: Wednesday to Monday

Weekly Off: Tuesday

Work Mode: Full-Time, On-Site

Job Summary

We are looking for a detail-oriented, analytical, and responsible MIS Executive to manage business data, prepare reports, maintain dashboards, and support management in tracking business performance. The ideal candidate should have strong Excel skills, excellent data management abilities, and the capability to coordinate with multiple departments to ensure accurate and timely reporting.

Key Responsibilities

1. MIS Reporting & Data Management

• Prepare daily, weekly, and monthly MIS reports.
• Collect, compile, verify, and maintain data from different departments.
• Maintain accurate records of business activities, targets, and achievements.
• Ensure data accuracy, consistency, and timely submission of reports.
• Identify discrepancies and resolve data-related issues.

2. Excel & Dashboard Management

• Create and maintain Excel sheets, dashboards, trackers, and performance reports.
• Use advanced Excel functions such as Pivot Tables, VLOOKUP/XLOOKUP, IF, SUMIFS, and COUNTIFS.
• Develop automated reports to reduce manual work and improve efficiency.
• Maintain Google Sheets and other reporting tools as required.
• Present complex data in a clear and easy-to-understand format.

3. Sales Performance & Business Tracking

• Monitor sales team performance, targets, achievements, and productivity.
• Track leads, follow-ups, conversions, and sales progress.
• Prepare target-versus-achievement reports for management review.
• Maintain department-wise performance trackers and business data.
• Highlight performance gaps and provide relevant data insights to management.

4. Departmental Coordination

• Coordinate with Sales, HR, Operations, Accounts, and other departments for data collection.
• Follow up with department heads and team members for pending reports and updates.
• Ensure all departments submit accurate information within defined timelines.
• Communicate reporting requirements and maintain standardized reporting formats.
• Support management in monitoring departmental activities and performance.

5. Reporting, Analysis & Documentation

• Prepare management reports, summaries, and presentations.
• Maintain proper documentation of reports, trackers, and historical data.
• Analyze business trends and identify discrepancies or areas for improvement.
• Ensure data confidentiality and controlled access to business information.
• Support management in decision-making through accurate reports and data analysis.

Required Skills & Qualifications

• Graduate in Commerce, Business Administration, Statistics, Mathematics, IT, or a related field.
• 14 years of relevant experience in MIS reporting, data management, or reporting analysis preferred.
• Strong knowledge of Advanced Microsoft Excel and Google Sheets.
• Excellent analytical, numerical, and problem-solving skills.
• Good attention to detail and data accuracy.
• Strong coordination, communication, and time-management skills.
• Knowledge of Power BI and dashboard automation will be an added advantage.
• Experience in real estate, sales, or service-based organizations will be preferred.