Healthcare Data Analyst

About the Role

We are seeking a motivated and detail-oriented Healthcare Data Analyst to join our analytics team. The ideal candidate will support healthcare data analysis, reporting, dashboard development, and data-quality initiatives. This position is suitable for candidates with 0–2 years of experience, including recent graduates, internship experience, academic projects, or entry-level analytical experience. The analyst will work with healthcare-related datasets such as claims, patient/member, clinical, provider, utilization, and operational data and will collaborate with senior analysts and business stakeholders to convert data into meaningful insights.

Key Responsibilities

• Extract, clean, transform, and analyse healthcare data using SQL and Microsoft Excel.
• Write basic to intermediate SQL queries involving filtering, joins, aggregations, and data validation.
• Assist in analyzing healthcare claims, member, provider, clinical, utilization, and operational datasets.
• Create and maintain reports, dashboards, and visualizations using Power BI, Tableau, or similar BI tools.
• Perform data validation, reconciliation, and quality checks to identify missing, duplicate, inconsistent, or inaccurate data.
• Track and report key performance indicators (KPIs) related to healthcare operations and quality.
• Identify trends, patterns, and anomalies in healthcare data and communicate findings to senior team members.
• Support recurring and ad-hoc reporting requests from business and healthcare stakeholders.
• Document queries, reporting processes, data definitions, and analytical methodologies.
• Collaborate with Data Engineering, Business Intelligence, Clinical, Operations, and other cross-functional teams.
• Assist with process improvement and reporting automation initiatives.
• Maintain confidentiality and follow organizational policies related to HIPAA, PHI, and healthcare data security.
• Participate in analytical projects and other responsibilities assigned by the Analytics Manager or Senior Data Analyst.

Requirements & Tech Stack

• SQL
• Microsoft Excel (including Pivot Tables, lookups, formulas, and data cleaning)
• Data Cleaning & Validation
• Data Analysis
• Reporting
• Analytical Thinking
• Problem Solving
• Attention to Detail
• Data Quality
• Communication
• Documentation
• Stakeholder Collaboration
• Healthcare Data Understanding
• Time Management

Preferred Technologies:

• Power BI
• Tableau
• Python / R
• SQL Server
• Data Visualization
• ETL/Data Transformation
• Healthcare Data Analytics

Qualifications

• Master's degree in Data Analytics, Computer Science, Statistics, Mathematics, Healthcare Administration, Health Informatics, Information Technology, or a related field.
• 0–2 years of experience in data analytics, healthcare analytics, business intelligence, research, internship, or a related field.
• Basic to intermediate knowledge of SQL.
• Strong knowledge of Microsoft Excel, including Pivot Tables, lookups, formulas, and data cleaning.
• Basic understanding of data analysis, reporting, and visualization.
• Strong analytical and problem-solving skills.
• Excellent attention to detail and data accuracy.
• Ability to communicate analytical findings clearly to technical and non-technical stakeholders.
• Ability to work independently as well as collaboratively in a team environment.

Preferred Qualifications:

• Exposure to Power BI, Tableau, or another business intelligence platform.
• Basic knowledge of Python or R.
• Familiarity with healthcare datasets such as claims, EHR, patient/member, provider, pharmacy, or clinical data.
• Understanding of healthcare terminology and basic healthcare analytics concepts.
• Familiarity with HIPAA and Protected Health Information (PHI).
• Knowledge of healthcare coding concepts such as ICD-10, CPT, HCPCS, or SNOMED is a plus.
• Internship, academic project, or portfolio experience involving healthcare or large datasets is preferred.