Achalshail Khadka

About Achalshail Khadka

Turning Data into Insights | Data Enthusiast

Experience

1. Data Engineer

   agilon health

   Oct 2023 — Present · Austin, TX, US

   Designed and deployed end-to-end ETL pipelines using Azure Data Factory, Snowflake, and Spark, enabling scalable ingestion and transformation of patient, claims, and provider data from multiple source systems.• Developed real-time streaming workflows using Spark Streaming, Azure Event Grid, and Databricks to process patient encounters and care event alerts, reducing data availability delays from hours to minutes.• Built PySpark-based transformation logic in Databricks notebooks to clean, validate, and enrich high-volume datasets for care analytics and provider scorecards.• Managed multi-stage data ingestion pipelines involving Cosmos DB, Azure SQL, and Data Lake Storage, using ADF JSON configurations for modular orchestration and reusability.• Constructed and maintained Azure Synapse data warehouses, implementing optimized star schemas, materialized views, and partitioning strategies for low-latency query performance across 50M+ row datasets.• Integrated Snowflake and Synapse for hybrid analytical workloads, leveraging Snowflake’s native capabilities (Streams, Tasks, Time Travel) for historical tracking and reverse ETL.• Enforced data governance policies including row/column-level access control, data classification, and encryption to meet HIPAA and HITRUST compliance standards.• Configured Azure Functions for event-triggered ETL tasks and API integrations, enabling automated downstream processes tied to clinical data updates.• Monitored and optimized Talend workflows for large-scale batch ingestion, including logging, error handling, and retry logic to improve pipeline reliability.• Built Power BI dashboards with DAX, Power Query, and row-level security, supporting clinical ops teams with real-time metrics on provider engagement, care gaps, and patient outcomes.• Implemented CI/CD automation using Azure DevOps and Git, managing version-controlled deployment of pipelines and infrastructure-as-code assets for consistent environment promotion.