MIS Executive

Marengo Asia Healthcare; Ahmedabad District; On-site; INR 600,000 - 900,000; Full time

Job summary

Marengo Asia Healthcare in Ahmedabad is seeking a healthcare data analyst to transform raw OPD/IPD and emergency visit data into actionable insights.

You will build recurring MIS dashboards for senior management, track patient demographics, specialties, geography and referrals, and highlight trends to support regional growth plans. A strong command of advanced Excel, HIS and CRM systems is required.

Qualifications

• Advanced MS Excel skills including Pivot Tables and VLOOKUP/XLOOKUP.
• Familiarity with Hospital Information Systems (HIS) and CRM platforms.
• Ability to gather data from multiple sources and build MIS dashboards.

Responsibilities

• Gather daily, weekly, and monthly OPD, IPD, and emergency visit data.
• Track and maintain patient demographics, specialties, geography, and referrals.
• Analyze revenue by specialty and doctor to pinpoint growth areas.
• Prepare automated MIS dashboards for senior management, marketing heads.
• Highlight trends and seasonal variations in patient admissions.
• Standardize data reporting formats for consistency.
• Collaborate with business development to assess regional growth and doctor tie-ups.

Skills

MS Excel

Data analysis

Tools

HIS

CRM platforms

Job description

• Gather daily, weekly, and monthly data on outpatient (OPD) footfalls, inpatient (IPD) admissions, and emergency visits.
• Track and maintain databases for patient demographics, specialties, geography, and referral sources.
• Analyze specialty-wise and doctor-wise revenue performance to identify high-growth and underperforming areas.
• Prepare automated or periodic MIS dashboards (Daily/Weekly/Monthly) for senior management, Marketing Heads
• Highlight key trends, seasonal variations in patient admissions
• Standardize data reporting formats to maintain consistency .
• Work alongside business development teams to evaluate regional growth potential, competitor activity, and doctor tie-ups.

Preferred candidate profile

Advanced MS Excel (Pivot Tables, VLOOKUP/XLOOKUP,

familiarity with Hospital Information Systems (HIS) and CRM platforms.