Aayush C.

About Aayush C.

I am a Data Engineer with 4+ years of experience in designing, building, and optimizing scalable data solutions. My expertise lies in cloud platforms, data pipelines, and modern data warehousing, with a proven ability to transform raw data into actionable insights that drive business decisions.Core Expertise:Cloud & Platforms: Microsoft Azure (ADF, Data Lake, Synapse, Azure SQL)Big Data Processing: PySpark, distributed systems, large-scale ETL/ELT pipelinesOrchestration & Workflow Management: Apache Airflow, Azure Data FactoryData Warehousing & Modeling: Snowflake, dimensional modeling, performance tuningTransformation & Automation: dbt for modular, testable, and scalable SQL transformationsAdvanced SQL: Complex queries, optimization, and analytics supportData Governance & Quality: CI/CD pipelines, automated testing, and documentationProfessional Highlights:Designed and implemented end-to-end data pipelines for structured and semi-structured data.Migrated and optimized data platforms to the cloud (Azure, Snowflake) for scalability and cost efficiency.Improved query performance and reduced processing time by optimizing data models and transformations.Enabled self-service analytics for business and analytics teams through clean data marts and semantic models.Collaborated with cross-functional teams to translate business needs into technical data solutions.

Experience

1. Data Engineer

   Westfield Insurance

   Oct 2023 — Present · Westfield, OH, US

   Led migration of ~12K insurance policies worth $100M+, ensuring zero data loss and accurate financial reconciliation• Built end-to-end ETL pipelines with ADF to ingest data from Netezza to ADLS for scalable, fault-tolerant processing• Applied Medallion Architecture (bronze-silver-gold) to standardize data processing and deliver analytics-ready datasets• Developed DBT models for complex transformations and data enrichment, enhancing business data consistency• Created PySpark and Spark SQL pipelines to transform and aggregate large datasets in ADLS for enterprise analytics• Designed Iceberg tables (snowflake) in the Silver Sales layer storing data in Parquet format for optimized efficiency• Transferred and replicated data from S3 to ADLS using Qlik Replicate, ensuring reliable and efficient data migration• Developed enterprise data warehouse and datamarts, enabling efficient analytics and reporting across business domains

Education

• Cleveland State University

  Master's degree, Computer Science

• Nagpur Institute of Technology, Katol road

  Bachelor of Engineering, Information Technology

  2015 — 2019