Job Description – MIS Executive
Position: MIS Executive
Industry: Real Estate
Experience: 2–3 Years
Salary: ₹30,000 – ₹35,000 per month
Location: Hyderabad
Job Summary
We are looking for a detail-oriented and analytical MIS Executive with 2–3 years of relevant experience, preferably in the Real Estate industry. The candidate should have strong expertise in MS Excel and Advanced Excel, along with hands-on experience working with CRM and ERP systems.
The role will be responsible for preparing and maintaining MIS reports, analyzing business data, tracking sales and operational performance, and providing accurate and timely reports to management for effective decision-making.
Key Responsibilities
- Prepare and maintain daily, weekly, and monthly MIS reports and dashboards.
- Collect, consolidate, validate, and analyze data from various departments and business systems.
- Generate reports related to sales, leads, site visits, bookings, collections, inventory, revenue, and project performance.
- Maintain and analyze data from CRM and ERP systems.
- Monitor lead funnel and sales pipeline data and provide regular performance reports.
- Track lead generation, lead conversion, follow-ups, site visits, bookings, and cancellations.
- Prepare sales team performance reports and identify gaps or trends.
- Ensure data accuracy, consistency, and timely updating of MIS databases.
- Create automated and dynamic reports using Advanced Excel.
- Develop dashboards using Pivot Tables, Pivot Charts, VLOOKUP/XLOOKUP, INDEX-MATCH, IF functions, SUMIFS/COUNTIFS, and other advanced Excel features.
- Coordinate with Sales, CRM, Finance, and Operations teams for data collection and reconciliation.
- Provide actionable insights and data analysis to management.
- Maintain proper documentation and reporting formats.
- Identify discrepancies in data and coordinate with relevant teams for correction.
- Support management with ad-hoc reports and business analysis as required.
Required Skills
- Strong knowledge of MS Excel and Advanced Excel.
- Hands-on experience with Pivot Tables, Pivot Charts, VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF functions, data validation, and Excel dashboards.
- Experience working with CRM software and understanding of lead and sales management processes.
- Experience working with ERP systems and extracting or consolidating business data.
- Good understanding of MIS reporting and data analysis.
- Strong analytical and problem-solving skills.
- Excellent attention to detail and accuracy.
- Good communication and coordination skills.
- Ability to manage large volumes of data and meet reporting deadlines.
Preferred Experience
- 2–3 years of experience in MIS, reporting, data analysis, or business operations.
- Candidates with experience in the Real Estate industry will be preferred.
- Experience with Real Estate CRM/ERP systems and sales reporting will be an added advantage.
- Knowledge of Power BI will be an advantage but is not mandatory.
Education
- Bachelor's degree in Commerce, Business Administration, Computer Applications, Statistics, or a related field.
- Relevant certification in Advanced Excel, MIS, or Data Analytics will be an advantage.
Key Competencies
- Data Accuracy & Attention to Detail
- Analytical Thinking
- Advanced Excel Skills
- MIS & Dashboard Reporting
- CRM/ERP Data Management
- Business Reporting
- Problem Solving
- Time Management
- Cross-functional Coordination
Wednesday 1:00 PM Call ended 8m 11s
Pay: ₹30,000.00 - ₹35,000.00 per month
Work Location: In person
