Job Description
Job Description – MIS Executive
Department:
Marketing & Call Centre
Reporting To:
Head – Marketing & Strategy
Location:
Central MIS Office (Aastha Hospital, Vikaspuri) with coordination for Maccure Janakpuri & Dwarka branches
Role Objective
To maintain accurate and real-time data across hospital branches by tracking marketing leads, patient conversions, and revenue contribution. The MIS Executive ensures that daily, weekly, and monthly dashboards reflect performance accuracy and help management make timely, data-driven decisions.
Key Responsibilities
Lead & Marketing Data Tracking
- Collect daily data from all digital and offline lead sources (Google, Meta, AiSensy, Practo, JustDial, Referral, Walk-in).
- Maintain and update the
central Lead Tracker Sheet
with accurate lead status (Recent, Follow-up, Converted, Lost).
- Prepare
daily lead summary
reports for Aastha, Maccure Janakpuri, and Maccure Dwarka.
- Record conversion reasons and drop-off remarks to improve campaign targeting.
- Share a
daily report by 10:00 AM
summarizing leads, calls, and appointments.
2. Call Centre Performance Reports
- Extract daily data from
AiSensy and call centre logs
(calls received, missed, connected, follow-ups).
- Generate
branch-wise and counsellor-wise performance sheets.
- Track TAT (Turnaround Time) and missed-call closures.
- Highlight unresponded leads and coordinate with counsellors for timely follow-ups.Revenue & Conversion Analytics
- Match converted leads with billing data to track
source-wise revenue
.
- Coordinate with the billing team to map
enquiry → appointment → admission → revenue
flow.
- Prepare
weekly ROI reports
for each running campaign.
- Compare
lead quality vs. conversion %
to guide marketing adjustments.
4. Dashboard & Data Management
- Maintain
Google Sheets or Excel dashboards
with all daily and monthly metrics.
- Use formulas (Pivot, VLOOKUP, CountIF, etc.) to automate summaries.
- Generate
doctor-wise, package-wise, and source-wise conversion sheets.
- Ensure all sheets are formatted and backed up weekly.
Coordination & Communication
- Work closely with call centre staff, marketing executives, and billing teams.
- Coordinate data flow between
Janakpuri, Dwarka, and Aastha
branches.
- Assist in management reviews with consolidated reports.
- Maintain confidentiality of patient, billing, and referral data.
Key Performance Indicators (KPIs)
Metric
Target / Frequency
Daily report submission
Before 10 AM
Data accuracy
100%
Missed lead follow-up tracking
Same day
Weekly revenue & ROI dashboard
Every MondayMonthly performance summary
By 3rd of each month
Soft Skills
- High accuracy and attention to detail.
- Analytical mindset and problem-solving ability.
- Team coordination and communication skills.
- Commitment to confidentiality and professionalism.
Department:
Marketing & Call Centre
Reporting To:
Head – Marketing & Strategy
Location:
Central MIS Office (Aastha Hospital, Vikaspuri) with coordination for Maccure Janakpuri & Dwarka branches
Role Objective
To maintain accurate and real-time data across hospital branches by tracking marketing leads, patient conversions, and revenue contribution. The MIS Executive ensures that daily, weekly, and monthly dashboards reflect performance accuracy and help management make timely, data-driven decisions.
Key Responsibilities
Lead & Marketing Data Tracking
- Collect daily data from all digital and offline lead sources (Google, Meta, AiSensy, Practo, JustDial, Referral, Walk-in).
- Maintain and update the
central Lead Tracker Sheet
with accurate lead status (Recent, Follow-up, Converted, Lost).
- Prepare
daily lead summary
reports for Aastha, Maccure Janakpuri, and Maccure Dwarka.
- Record conversion reasons and drop-off remarks to improve campaign targeting.
- Share a
daily report by 10:00 AM
summarizing leads, calls, and appointments.
2. Call Centre Performance Reports
- Extract daily data from
AiSensy and call centre logs
(calls received, missed, connected, follow-ups).
- Generate
branch-wise and counsellor-wise performance sheets.
- Track TAT (Turnaround Time) and missed-call closures.
- Highlight unresponded leads and coordinate with counsellors for timely follow-ups.Revenue & Conversion Analytics
- Match converted leads with billing data to track
source-wise revenue
.
- Coordinate with the billing team to map
enquiry → appointment → admission → revenue
flow.
- Prepare
weekly ROI reports
for each running campaign.
- Compare
lead quality vs. conversion %
to guide marketing adjustments.
4. Dashboard & Data Management
- Maintain
Google Sheets or Excel dashboards
with all daily and monthly metrics.
- Use formulas (Pivot, VLOOKUP, CountIF, etc.) to automate summaries.
- Generate
doctor-wise, package-wise, and source-wise conversion sheets.
- Ensure all sheets are formatted and backed up weekly.
Coordination & Communication
- Work closely with call centre staff, marketing executives, and billing teams.
- Coordinate data flow between
Janakpuri, Dwarka, and Aastha
branches.
- Assist in management reviews with consolidated reports.
- Maintain confidentiality of patient, billing, and referral data.
Key Performance Indicators (KPIs)
Metric
Target / Frequency
Daily report submission
Before 10 AM
Data accuracy
100%
Missed lead follow-up tracking
Same day
Weekly revenue & ROI dashboard
Every MondayMonthly performance summary
By 3rd of each month
Soft Skills
- High accuracy and attention to detail.
- Analytical mindset and problem-solving ability.
- Team coordination and communication skills.
- Commitment to confidentiality and professionalism.
💡 Quick Summary
Seeking a career-building opportunity? The Management Information Systems Executive (Delhi) position is now open for candidates interested in the MIS Executive sector. This role in New Delhi offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in MIS Executive is a plus.
