10 Aug
|
ZEQON LUXURY IN LAND
|
Mumbai
10 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