Ansh Sarawagi

About Ansh Sarawagi

As a Data Engineer specializing in healthcare analytics, I transform complex clinical and compliance datasets into actionable insights for pharmaceutical clients. At ZS Associates as a Business Technology Solutions Associate, I architect end-to-end data solutions that power advanced analytics—from clinical trial risk assessments to automated compliance monitoring systems.What I Do:I build scalable data pipelines on modern cloud platforms (Databricks, AWS, Snowflake) using Python, PySpark, and Apache Spark. My work spans the full data engineering lifecycle: designing data architectures, implementing ETL/ELT workflows, optimizing query performance, and integrating CI/CD automation. I\'ve processed 25+ complex datasets from clinical trials, IQVIA commercial data, and pharma compliance sources—always prioritizing data quality, governance, and regulatory requirements.Key Achievements- Reduced data processing time by 30% through SQL and Spark optimization across production pipelines- Built automated compliance monitoring systems eliminating 50-60% of manual effort while maintaining 99.9% data accuracy- Recognized with bonus awards twice for technical excellence and delivering high-impact solutions on tight timelines- Architected clinical trials risk analytics platform processing TB-scale data for proactive regulatory complianceTechnical Expertise:Languages: Python, SQL, PySpark, Spark SQLBig Data & Cloud: Apache Spark, Databricks, Delta Lake, Hadoop, AWS (S3, Redshift, Glue, EMR), SnowflakeOrchestration: Apache Airflow, Jenkins, Git, CI/CDAnalytics: Tableau, Power BI, AlteryxCertifications: Databricks Certified Data Engineer Professional AWS Certified AI PractitionerWhat Sets Me Apart:My consulting background sharpened both technical skills and business acumen—translating requirements into solutions, communicating with stakeholders, and delivering under pressure. I understand that data pipelines aren\'t just about moving data; they enable better decisions.Currently Learning:Deepening expertise in streaming analytics, machine learning integration, and AI-powered data solutions to stay at the forefront of data engineering innovation.Let\'s Connect:Open to opportunities in data engineering, cloud data architecture, or healthcare analytics. Whether you\'re building data platforms or tackling analytics challenges, let\'s exchange ideas. a••••••••@gmail.com

Experience

1. Data Engineer (Business Technology Solutions Associate)

   ZS

   Nov 2023 — Present · Pune, IN

   Data Engineer at ZS Associates specializing in healthcare and pharmaceutical analytics, building scalable data pipelines and cloud-native solutions that power critical business decisions for global pharma clients.Key Responsibilities- Architect ETL/ELT data pipelines using Python, PySpark, and Apache Spark on Databricks, processing 25+ complex datasets from clinical trials (CTMS, adverse events), commercial pharma sources (IQVIA, VEEVA), and compliance systems- Design data warehouses in Snowflake and AWS Redshift supporting Tableau and Power BI analytics dashboards- Build automated compliance monitoring systems with real-time risk detection, data quality frameworks, and regulatory governance controls- Orchestrate workflows using Apache Airflow, Jenkins, and CI/CD pipelines for production deployments- Implement data modeling including SCD Type 2 for historical tracking and audit compliance- Collaborate with cross-functional teams—clinical operations, compliance, business analysts, stakeholdersMajor Projects: Clinical Trials Risk Analytics: Built system processing TB-scale data from 25+ clinical sources, implementing anomaly detection for patient safety and regulatory compliance Automated Compliance Monitoring: Developed real-time compliance system analyzing commercial pharma data, eliminating 50-60% manual tracking Digital Privacy & Consent Management: Led cross-functional project implementing CCPA/GDPR-compliant cookie consent across 20+ websitesKey Achievements: Reduced data processing time by 30% through SQL and Spark optimization Processed TB-scale healthcare datasets maintaining performance and cost efficiency Awarded bonus recognition twice for outstanding technical delivery Deployed 5+ production pipelinesTechnical Stack: Python, SQL, PySpark, Apache Spark, Databricks, Delta Lake, AWS (S3, Redshift, Glue, EMR), Snowflake, Apache Airflow, Hadoop, Tableau, Power BI, Alteryx, Git, Jenkins

Education

• The LNM Institute of Information Technology

  Bachelor of Technology - BTech, Electrical, Electronics and Communications Engineering

  2019 — 2023