
Data Engineer
Helson Software Solutions Private Limited · Sep 2024 – Apr 2026
- Designed and implemented automated, HIPAA-compliant data ingestion and transformation pipelines using Azure Data Factory, Azure Databricks, and PySpark to manage end-to-end claim adjudication data flows, reducing data latency by 35%.
- Ingested and parsed structured and semi-structured health insurance data, including HIPAA EDI 837, 835, and 834 files, processing over 15M daily records into a Medallion Architecture (Bronze to Silver to Gold).
- Mapped legacy healthcare data onto modern HL7 FHIR data profiles within Databricks to standardize provider and patient records, establishing a unified data layer for downstream Predictive Machine Learning models.
- Built modular DBT models to clean, anonymize, and execute dynamic data masking on Protected Health Information (PHI), improving data compliance audit speeds by 40% while standardizing raw medical and pharmacy claims.
- Leveraged DBT to architect optimized Star and Snowflake schemas for Member Eligibility Dimensions, Provider Networks, and Institutional/Professional Claim Fact tables.
- Aligned processed health data layers with CMS guidelines to support Hierarchical Condition Category (HCC) coding, actuarial risk adjustment factor (RAF) scores, and capitation payment modeling, supplying clean feature sets for AI-driven healthcare risk forecasting.
- Developed transformation logic to extract and compute clinical data metrics required for HEDIS quality scorecards, improving query execution times by 25% for downstream business intelligence and analytics tracking.
- Implemented rigorous DBT data validation tests for membership enrolment overlaps, duplicate claims detection, and cross-reference validation to guarantee 100% financial and billing accuracy before consumption.




