09 Aug
|
ZEQON LUXURY IN LAND
|
Mumbai
09 Aug
ZEQON LUXURY IN LAND
Mumbai
MIS Executive – Job Title: MIS Executive
Department: MIS / Business Operations
Location: Mumbai
Experience: 2–5 Years
Employment Type: Full-Time
Reporting To: Management
Job Summary We are looking for a strong and detail-oriented MIS Executive who can independently manage business data, prepare daily/weekly/monthly MIS reports, develop dashboards, analyze performance trends, and provide accurate insights to management for decision-making.
The ideal candidate should have excellent Excel skills, robust analytical ability, attention to detail, and hands-on experience in sales/operations MIS .
Key Responsibilities
- Prepare Daily, Weekly & Monthly MIS reports for management.
- Maintain and consolidate data from multiple departments including Sales, Marketing, Operations, HR, Warehouse and Finance.
- Prepare sales performance reports, target vs. achievement, productivity, lead conversion and pipeline reports.
- Develop and maintain Excel dashboards and management dashboards.
- Track sales targets, revenue, collections, leads, enquiries and conversions.
- Prepare region-wise, salesperson-wise, product-wise and store-wise performance reports.
- Ensure daily data is collected from respective teams and updated accurately.
- Monitor data discrepancies and coordinate with concerned teams for corrections.
- Prepare management presentations and business review reports.
- Automate repetitive MIS activities wherever possible using advanced Excel functions.
- Maintain proper databases and ensure data integrity and confidentiality.
- Analyse trends and highlight gaps, exceptions and key business insights to management.
- Support management with ad-hoc reports and data analysis whenever required.
- Maintain proper documentation and version control of MIS files.
- Coordinate with CRM users and ensure CRM data accuracy and timely updates.
- Create reports for monthly review meetings, performance reviews and business planning.
Must-Have Required Technical Skills
- Advanced MS Excel
- Pivot Tables & Pivot Charts
- XLOOKUP / VLOOKUP / INDEX-MATCH
- SUMIFS / COUNTIFS / IF / IFERROR
- Conditional Formatting
- Data Validation
- Advanced Excel formulas
- Data Cleaning & Consolidation
- Dashboard Preparation
- MIS Reporting
- PowerPoint
Preferred
- Power BI
- Power Query
- CRM reporting
- Google Sheets
- Basic SQL knowledge
Candidate Profile
- 2–5 years of relevant MIS / Business Analyst / Sales MIS experience
- Strong numerical and analytical skills.
- Excellent attention to detail and data accuracy.
- Ability to work with large volumes of data.
- Strong follow-up and coordination skills.
- Ability to work independently with minimum supervision.
- Good communication and presentation skills.
- Should be comfortable working under tight deadlines.
- Should have a problem-solving and ownership-oriented approach.
- Strong Excel knowledge is mandatory.
Key Performance Indicators (KPIs)
- 100% accuracy in MIS reports
- Timely submission of Daily/Weekly/Monthly reports
- Dashboard and report automation
- Data reconciliation and error reduction
- Timely identification of business gaps
- CRM/data update accuracy
- Management report turnaround time
- Quality and usefulness of business insights
Preferred Candidate We are specifically looking for someone who is not merely a data-entry MIS Executive, but a strong MIS professional who can understand business data, analyse it, create dashboards and independently present meaningful insights to management. Skills: skills,management,data,crm,sales,operations,excel,dashboards
📌 MIS Executive (Mumbai)
🏢 ZEQON LUXURY IN LAND
📍 Mumbai