Job Title: MIS Executive / MIS Analyst – Sales & Marketing
Department: Marketing
Industry: Real Estate
Experience: 2–5 Years
Location: Bandra, Mumbai
Reporting To: Head – Sales & Marketing / Management
Role Purpose
We are looking for an MIS professional who can manage, analyze, and interpret sales and marketing data to provide management with clear insights into Lead Cost, Walk-in Cost, Booking Cost, Conversion Ratios, and overall marketing ROI.
Key Responsibilities
- Collect and consolidate data from various lead-generation sources such as Digital Marketing, Google, Meta, Property Portals, Channel Partners, Events, References, etc.
- Prepare daily, weekly, and monthly MIS reports for management.
- Calculate and track:
- Cost Per Lead (CPL)
- Cost Per Walk-in (CPW)
- Cost Per Booking (CPB)
- Lead-to-Walk-in Conversion %
- Walk-in-to-Booking Conversion %
- Lead-to-Booking Conversion %
- Marketing Spend vs. Revenue/Booking
- Source-wise and campaign-wise ROI
- Track the complete Lead → Calling → Site Visit/Walk-in → Follow-up → Booking funnel.
- Analyze performance by campaign, source, project, location, salesperson, and time period.
- Identify which marketing channels are generating quality leads and actual bookings, not just lead volumes.
- Prepare source-wise cost and conversion reports to support marketing budget decisions.
- Monitor lead data and identify duplicate, invalid, or poor-quality leads.
- Coordinate with the Marketing, Sales, CRM, and Finance teams to ensure accuracy of data.
- Reconcile marketing expenditure with invoices/bills and campaign data.
- Create management dashboards with key KPIs and trends.
- Highlight variances, problem areas, and opportunities to management.
- Automate recurring reports wherever possible using Excel / Power BI / Google Sheets.
Required Skills
- Advanced MS Excel – Pivot Tables, XLOOKUP/VLOOKUP, SUMIFS, COUNTIFS, IF formulas, dashboards, charts, data validation, etc.
- Good understanding of MIS reporting and data analysis.
- Experience with CRM/Lead Management systems.
- Knowledge of Power BI will be an advantage.
- Understanding of digital marketing metrics such as CPL, CTR, CPC, conversion rate and campaign ROI.
- Strong analytical and problem-solving skills.
- Good attention to detail and data accuracy.
- Ability to present data in a simple and management-friendly format.
Preferred Candidate
- Experience in Real Estate Sales & Marketing MIS will be preferred.
- Candidate should understand the Lead → Walk-in → Booking sales funnel.
- Should be able to independently create reports rather than only entering data.
- Should have the ability to analyze data and tell management what the numbers mean.
Application Process:
Interested candidates can share their updated Resume with the subject line:
“[Job Title] – [Your Name]” on [email protected] (CC: [email protected] ) You can also connect at +91-9321583057 / 8850220484
In your email, mention:
Current CTC, Expected CTC, Notice period, Location and total number of experience in years.
Pay: ₹500,000.00 - ₹600,000.00 per year
Application Question(s):
- How many years of relevant MIS / Data Analysis experience do you have?
- Do you have experience handling MIS for Sales & Marketing teams?
- How would you rate your MS Excel skills?
- Which of the following Excel functions/features do you use independently?
- What is your current CTC, expected CTC, notice period, and earliest joining date?
- Have you calculated and reported metrics such as CPL, CPW, CPB and conversion ratios?
Work Location: In person
