S
MIS Executive / MIS Analyst – Sales & Marketing
SM Group
Job Description
Job Title: MIS Executive / MIS Analyst – Sales & Marketing
Location: Bandra, Mumbai
Experience: 2-5 Years
Industry: Real Estate
Department: Marketing
Employment Type: Full-time
Key Responsibilities
- Collect and consolidate data from Digital Marketing, Google, Meta, Property Portals, Channel Partners, Events, References, and other lead-generation sources.
- Prepare daily, weekly, and monthly MIS reports for management.
- Track CPL, CPW, CPB, conversion ratios, marketing spend, booking value, and campaign ROI.
- Monitor the complete Lead ? Calling ? Walk-in/Site Visit ? Follow-up ? Booking funnel.
- Analyse performance by campaign, source, project, location, salesperson, and time period.
- Identify quality lead sources and provide insights to support marketing budget decisions.
- Prepare management dashboards and highlight trends, variances, problem areas, and opportunities.
- Automate recurring reports using Excel, Power BI, or Google Sheets.
- Coordinate with Sales, Marketing, CRM, and Finance teams to ensure data accuracy.
What We're Looking For
- 2-5 years of relevant MIS / data analysis experience.
- Advanced MS Excel skills including Pivot Tables, XLOOKUP/VLOOKUP, SUMIFS, COUNTIFS, IF formulas, dashboards, charts, and data validation.
- Good understanding of MIS reporting, data analysis, and 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 with excellent attention to detail.
- Ability to independently create reports and explain what the numbers mean to management.
- Experience in Real Estate Sales & Marketing MIS will be preferred.