Data Analyst in Healthcare & Pharma India 2026

Pattern 1 — MR performance scorecard (pharma SFE)

-- Monthly MR performance scorecard
SELECT
  mr.employee_id,
  mr.name                                                AS mr_name,
  mr.territory,
  mr.manager_name,
  COUNT(DISTINCT v.visit_date)                           AS working_days,
  COUNT(v.visit_id)                                      AS total_calls,
  ROUND(COUNT(v.visit_id) /
        NULLIF(COUNT(DISTINCT v.visit_date), 0), 1)      AS call_average,
  COUNT(DISTINCT v.doctor_id)                            AS doctors_visited,
  ROUND(100.0 * COUNT(DISTINCT v.doctor_id) /
        mr.target_doctors, 1)                            AS coverage_pct,
  COALESCE(SUM(s.units_sold), 0)                        AS secondary_sales_units,
  mr.monthly_target_units,
  ROUND(100.0 * COALESCE(SUM(s.units_sold), 0) /
        NULLIF(mr.monthly_target_units, 0), 1)           AS target_achievement_pct
FROM medical_reps mr
LEFT JOIN doctor_visits v
  ON mr.employee_id = v.mr_id
  AND DATE_FORMAT(v.visit_date, '%Y-%m') = '2026-08'
LEFT JOIN secondary_sales s
  ON mr.territory = s.territory
  AND DATE_FORMAT(s.sale_date, '%Y-%m') = '2026-08'
GROUP BY mr.employee_id, mr.name, mr.territory,
         mr.manager_name, mr.target_doctors, mr.monthly_target_units
ORDER BY target_achievement_pct ASC;   -- lowest performers first

Pattern 2 — Hospital bed utilisation and revenue per bed

-- Monthly bed occupancy and revenue by department
WITH bed_stats AS (
  SELECT
    department,
    SUM(DATEDIFF(discharge_date, admission_date))   AS total_patient_days,
    COUNT(admission_id)                             AS total_admissions,
    SUM(total_bill)                                 AS total_revenue,
    AVG(DATEDIFF(discharge_date, admission_date))   AS avg_length_of_stay
  FROM inpatient_admissions
  WHERE admission_date >= DATE_FORMAT(CURDATE(), '%Y-%m-01')
    AND discharge_date < DATE_ADD(
          DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH)
  GROUP BY department
)
SELECT
  bs.department,
  bs.total_admissions,
  ROUND(bs.avg_length_of_stay, 1)                  AS alos_days,
  bs.total_patient_days,
  cb.available_beds,
  DAY(LAST_DAY(CURDATE()))                          AS days_in_month,
  ROUND(
    100.0 * bs.total_patient_days /
    (cb.available_beds * DAY(LAST_DAY(CURDATE()))), 1
  )                                                 AS occupancy_rate_pct,
  ROUND(bs.total_revenue / 1000, 1)                AS revenue_k,
  ROUND(bs.total_revenue / NULLIF(bs.total_patient_days, 0), 0)
                                                   AS revenue_per_patient_day
FROM bed_stats bs
JOIN capacity_by_dept cb ON bs.department = cb.department
ORDER BY occupancy_rate_pct DESC;

What does a data analyst do in a pharma company in India?

Data analysts in Indian pharma companies work primarily in sales force effectiveness (SFE), commercial analytics, and market research. Typical responsibilities: tracking medical representative (MR) performance — doctor visit frequency, prescription share, target vs actual; secondary sales analysis — how much product moved from stockist to retailer to patient; market share analysis using IQVIA or PharmaTrac data; promotional ROI — which doctors respond to which promotional inputs; territory and headquarter performance reporting; and demand forecasting for manufacturing planning. At larger MNCs (Abbott, Sun Pharma, Cipla, Lupin), there are dedicated analytics teams using SQL, Python, and Power BI. At smaller pharma companies, analysts often use Excel + Power BI.

What is sales force effectiveness (SFE) analytics in pharma?

Sales Force Effectiveness (SFE) analytics in pharma measures how well the field sales team (medical representatives and area managers) is performing against targets. Key SFE metrics: call average (number of doctor visits per day per MR, target typically 8-12 in India); coverage (% of target doctors visited at least once per month); frequency (average visits per doctor in a month); doctor productivity (prescriptions written per visited doctor); input compliance (% of MRs who carried and used promotional material); and market share (your brand's prescription share vs competitors in a territory). SFE analysts use SQL to query CRM and secondary sales databases, and build Power BI dashboards that Area Managers and Regional Managers review in monthly performance meetings.

What is the salary of a data analyst in healthcare and pharma in India in 2026?

Data analyst salaries in Indian healthcare and pharma in 2026: at Indian pharma companies (Sun Pharma, Cipla, Lupin, Torrent) — ₹5-10 LPA for analysts with 1-3 years experience; at MNC pharma companies in India (Abbott, Pfizer, Novartis, Sanofi) — ₹8-15 LPA, especially for SFE and commercial analytics roles; at hospital chains (Apollo, Fortis, Max Healthcare) — ₹5-9 LPA for operations and clinical analytics roles; at healthtech startups (Practo, PharmEasy, 1mg, Mfine) — ₹8-18 LPA with strong SQL and Python skills; at pharma analytics outsourcing firms (IQVIA, Syneos, Axtria, ZS Associates) — ₹7-18 LPA depending on experience and client work. ZS Associates and IQVIA in Gurugram are the highest-paying pharma analytics employers in Delhi NCR.

What is IQVIA data and why do pharma analysts use it?

IQVIA (formerly IMS Health) provides pharmaceutical market intelligence data — specifically secondary sales data showing how much of each drug brand was sold through retail pharmacies and hospitals across India, aggregated by city, region, and therapy area. Pharma companies buy IQVIA data subscriptions to track their own market share against competitors without revealing individual patient or pharmacy data. Analysts use IQVIA data to: calculate market share (your brand vs total market in a therapy class); identify growing vs declining therapy areas; benchmark your MR productivity against industry averages; and target new territories where competitor share is high but your penetration is low. IQVIA data comes in standardised formats — analysts work with it in Excel, SQL, or Python depending on the company's data infrastructure.

What does a data analyst do in a hospital or healthcare system in India?

Data analysts in Indian hospital chains and healthcare systems work on: operations analytics — OPD and IPD patient volumes, bed occupancy rates, average length of stay (ALOS), turnaround time in emergency, OT (operation theatre) utilisation; revenue analytics — revenue per patient, payer mix (insurance vs cash), package utilisation rates, billing accuracy; clinical quality indicators — readmission rates, surgical complication rates, mortality rates by department; patient experience — NPS scores, complaint resolution time, appointment wait times; and supply chain — pharmacy inventory turnover, medical equipment utilisation, vendor performance. Hospital analytics analysts typically use SQL on Hospital Information Systems (HIS like Meditech, CliniComp, Insta HMS), Excel for MIS, and Power BI for dashboards shared with department heads.

Which healthcare and pharma companies hire data analysts in Noida and Delhi NCR?

Major healthcare and pharma analytics employers in Delhi NCR in 2026: Noida — Max Healthcare analytics (chain headquartered in Delhi NCR), Dabur analytics team (FMCG-health hybrid), several pharma companies with registered offices in Noida; Greater Noida — pharmaceutical manufacturing companies with analytics roles (API and formulations plants); Gurugram — ZS Associates India (leading pharma analytics firm, strong recruiter), IQVIA India, Axtria, Novartis Business Services, Abbott Nutrition analytics, Syneos Health; Delhi — AIIMS-connected research analytics (academic), Fortis Healthcare analytics team, Religare Health. ZS Associates in Gurugram is particularly notable — it exclusively serves pharma clients globally and is one of the largest pharma analytics employers in India.

Is a science or medical background required to become a data analyst in pharma in India?

No — a science or medical background is helpful but not required for most pharma analytics roles in India. What is required: strong SQL and data skills (the same as any analyst role), and the willingness to learn pharma domain knowledge on the job. Pharma analytics at companies like ZS Associates, IQVIA, and Axtria specifically recruits engineers, commerce graduates, and MBA students without pharma backgrounds and trains them in domain knowledge. The commercial analytics and SFE roles (which are the majority of pharma analytics jobs) involve structured sales data — not clinical trial data or drug chemistry — so domain learning is fast. If you want to do clinical data management or regulatory analytics (clinical trials, adverse event reporting), a science or pharmacy background is more valuable.