1. Role Objective

We are looking for a data-driven and analytically strong Business Analyst to support hospital management through comprehensive data analysis, performance monitoring, business intelligence and actionable insights. The candidate will be responsible for collecting, consolidating, analysing and interpreting complex hospital data and converting it into structured MIS reports, interactive dashboards and management presentations to facilitate informed business and operational decisions.
1. Key Roles & Responsibilities

A. Hospital Business & Operational Analytics
- Analyse hospital operational data across OPD, IPD, surgeries, diagnostics, pharmacy and other revenue-generating departments.
- Track key business indicators such as patient footfall, OPD conversion, admission conversion, surgery volumes, bed occupancy, ALOS and revenue per patient.
- Analyse doctor-wise, specialty-wise, department-wise and service-line-wise performance.
- Identify operational bottlenecks, revenue leakage, business opportunities and areas for improvement.
- Perform trend analysis, variance analysis and root-cause analysis.

B. MIS & Management Reporting
- Develop daily, weekly and monthly MIS reports for hospital leadership.
- Prepare structured management dashboards with clear KPIs and performance trends.
- Create visually appealing and presentable reports and PowerPoint presentations for management reviews.
- Ensure data accuracy, consistency, reconciliation and timely reporting.
- Translate complex datasets into meaningful business insights and actionable recommendations.

C. Data Management & Advanced Analytics
- Work with large and complex datasets from HIS, EMR, billing, CRM and other hospital information systems.
- Perform data extraction, cleaning, validation, consolidation and analysis.
- Develop automated reporting formats and data models to minimise manual intervention.
- Build analytical models to identify trends, patterns,



correlations and performance gaps.
- Support forecasting, budgeting, business planning and revenue projections.

1. Required Technical Skills

Tool / Technology| Expected Proficiency MS Excel| Advanced – Pivot Tables, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, Power Query, advanced formulas

Google Sheets| Advanced – Complex formulas, QUERY, IMPORTRANGE, dashboards, data validation and automation

SQL| Working to intermediate – Joins, subqueries, aggregations, CTEs and data extraction

Power BI / Tableau| Basic to intermediate – Dashboard development and data visualisation

MS PowerPoint| Strong – Management presentations and data storytelling

Google Slides| Good – Structured business presentations

1. Desired Analytical Competencies

- Strong numerical and analytical aptitude.
- Ability to work with large datasets and perform complex data analysis.
- Excellent attention to detail and data accuracy.
- Ability to identify patterns, trends and business performance gaps.
- Strong logical reasoning and problem-solving skills.
- Ability to communicate analytical findings in a straightforward, structured and visually compelling manner.

1. Key Performance Indicators (KPIs)
2. Accuracy and timeliness of daily, weekly and monthly MIS reports.
3. Development of automated dashboards and reporting systems.
4. Quality and depth of business and operational analysis.
5. Identification of revenue improvement and cost optimisation opportunities.
6. Effectiveness of data-driven recommendations.
7. Turnaround time for management reports and analytical assignments.
8. Data integrity and reconciliation across reporting sources.

Pay: ₹600,000.00 per year

Ability to commute/relocate

- Gurgaon H.O, Gurugram, Haryana: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):
- How many years of experience do you have in Business analytics in Healthcare ?

Experience:
- Business analysis: 1 year (Required)

Work Location: In person

📌 Business Analyst – Hospital Operations & MIS (Gurugram)
🏢 Best For Him
📍 Gurugram