Data Analyst

Heritage Hospital

Posted 3w ago

Full-timeOn-site

Job Overview

Job Type

Full-time

Work Mode

On-site

Location

Varanasi, Uttar Pradesh

Job Description

Job Summary

We are looking for a Data Analyst with good experience to analyze hospital and healthcare data,generate meaningful insights, and support management in data-driven decision-making. The candidate should have proficiency in Microsoft Excel and the ability to work with large and

complex healthcare datasets.

Key Responsibilities

  • Collect, validate, clean, and analyze healthcare and hospital operational data.
  • Develop MIS reports, dashboards, KPIs, and management reports using Excel and BI

tools.

  • Analyze data related to patient volumes, admissions, discharges, OPD/IPD, revenue,

billing, diagnostics, pharmacy, bed occupancy, TAT, doctor performance, and

departmental KPIs.

  • Identify trends, patterns, anomalies, and data-quality issues and provide actionable insights.
  • Prepare daily, weekly, monthly, and management-level analytical reports.
  • Develop and maintain automated Excel-based reports and dashboards.
  • Consolidate data from HIS/HMS, EMR, LIS, RIS/PACS, billing, and other healthcare

applications.

  • Work closely with IT, Finance, Operations, Clinical and other departments to

understand reporting requirements.

  • Ensure accuracy and consistency of data across different systems and reports.
  • Support management with ad-hoc analysis, forecasting, and decision-support data.
  • Assist in defining and monitoring hospital KPIs and performance indicators.
  • Maintain proper documentation of reports, data sources, calculations, and reporting

logic.

Required Technical Skills

  • Advanced Microsoft Excel – Pivot Tables, Pivot Charts, XLOOKUP/VLOOKUP, INDEX-

MATCH, SUMIFS/COUNTIFS, IF functions, data validation, conditional formatting, Power

Query, dashboards, and advanced formulas.

  • Strong understanding of data cleaning, transformation, validation, and reconciliation.
  • Experience in creating professional MIS reports and interactive dashboards.
  • Working knowledge of SQL for data extraction and analysis.
  • Knowledge of Power BI and Tableau for data visualization, dashboard development, and

reporting.

  • Understanding of databases and healthcare information systems.

Key Competencies

  • Strong analytical and problem-solving skills.
  • Excellent attention to detail and data accuracy.
  • Ability to handle large datasets and tight reporting timelines.
  • Strong communication and stakeholder-management skills.
  • Ability to convert complex data into clear and actionable insights.
  • Good documentation and presentation skills.
  • Ability to work independently as well as with cross-functional teams.

Qualification

Bachelor's degree [Preferred – Degree holder in Statistics, Mathematics, Computer Science,

Data Analytics, Information Technology, Business Analytics, or a related field.]

Preferred: Experience in a hospital, healthcare organization, HIS/HMS implementation,

healthcare analytics, or healthcare MIS environment.

Work Location: In person