June 21, 2026
| Title: | A Practical Exploration of Healthcare Data Analytics at Deerhold Ltd.: Challenges Faced, Solutions Applied, and Key Learnings |
| Author: | Devansh Lath |
| Advisor: | Mr. Raj Sankrit |
| Degree: | Bachelor of Business Administration Program in Finance and Investment (International Program) |
| Major: | B.B.A. Finance and Investment (International Program) |
| Faculty: | Business Administration |
| Semester/Year: | 2/2568 (2025) |
Abstract
This report titled “A Practical Exploration of Healthcare Data Analytics at Deerhold: Challenges Faced, Solutions Applied, and Key Learnings” presents a comprehensive overview of the Co-operative Education experience undertaken at Deerhold as a Data Analyst Intern. The primary objective of the internship was to bridge the gap between theoretical knowledge and practical application in data analytics, healthcare data processing, and ETL pipeline validation. The study highlights key activities, including working with Machine-Readable Files (MRFs), processing JSON and Parquet datasets, performing exploratory data analysis (EDA), and validating large-scale datasets using Python and SQL (Amazon Athena). The report explores the challenges encountered during the internship, including complex data structures, inconsistent dataset mappings, ETL join issues, and difficulties in tracing data lineage across multiple layers. Various practical approaches were applied to address these issues, such as cross-validation between parsed and ETL datasets, SQL-based verification, and structured root cause analysis. Overall, the internship contributed significantly to the development of technical skills in Python, SQL, and data analysis, while providing valuable insights into real-world healthcare data systems and analytics workflows.
Keywords: Healthcare Data Analytics, Machine-Readable Files (MRFs), ETL Validation, Python, SQL (Athena), Data Quality, Pricing Transparency, Healthcare Claims Data.
Views: 4
