Business Analyst - Hospital Industry - IIM/MDI/ISB

• Who can apply - From Hospital Industry only
• MBA (IIM or reputed institution) only
• Executive Summary of the Role

As a Business Analyst, you will move beyond simple reporting to uncover "the why" behind the numbers. You will collaborate with Finance, Operations, Clinical leads, and SCM to identify revenue leakages, optimize procedure costs, and build interactive BI dashboards that drive the hospital's strategic growth.

Core Responsibilities :

1. Revenue & Financial Intelligence :

• Analyze billing patterns, payer mixes, and credit cycles to prevent revenue leakage.
• Monitor key performance indicators like ARPOB (Average Revenue Per Occupied Bed) and service-mix profitability.

2. Supply Chain & Cost Optimization (SCM focus) :

• Consumption Tracking : Monitor pharmacy and consumable usage to reduce wastage.
• BOM Development : Define and develop a Bill of Materials (BOM) for non-billable items in Labs and Imaging.

• SKU Management : Evaluate and optimize SKU margins and govern standardized surgical kits for common procedures.
• Cost Modeling : Perform cost-benefit analyses for new equipment and procedure/package cost optimization.
• 3. Clinical & Operational Excellence :

• Track clinical outcomes (mortality ratios, infection rates, ALOS) to support NABH/JCI accreditation.
• Analyze doctor-wise contributions and identify bottlenecks in patient Turnaround Time (TAT).

4. BI Dashboarding & Executive Reporting :

• Design and maintain interactive dashboards (Power BI/Tableau).
• Automate weekly/monthly Business Performance Reviews (BPR).
• Translate complex datasets into concise executive summaries for senior leadership.

• Category Requirements :
• Education :
• MBA (IIM or reputed institution), M.Stat, or Engineering degree with a Data Science focus.
• Experience :
• 2+ years in Business Analytics. Healthcare or Hospital industry experience is a significant advantage.
• Technical Skills :
• Advanced Excel (VBA/Macros) is mandatory. Proficiency in BI tools (Power BI/Tableau) and familiarity with HIS/ERP structures. (SQL is preferred but not mandatory).
• Soft Skills :
• Strong storytelling ability, presentation skills, and the capacity to communicate data insights to non-technical stakeholders.