Kundan Surve

Data Engineer with 3+ years of experience building cloud data warehouses, ETL/ELT pipelines, and data models. Expertise in Snowflake, Advanced SQL, dbt with CI/CD, Python, and Azure Data Factory — delivering

40% faster queries, 30% efficiency gains, and 99.9% pipeline reliability across Agile teams.

Software Engineer – Data Engineering | Sapience Analytics, Pune

Oct 2023 – Present

• Snowflake DW & Analytics: Architected Snowflake data warehouse with ETL/ELT pipelines using Talend and ADF; improved analytics efficiency by 30%, reduced data latency, and translated business requirements from 10+ stakeholders into Power BI and Sigma dashboards.
• Workflow Orchestration: Automated end-to-end data workflows using Snowflake Tasks and Streams,

achieving 99.9% pipeline reliability from raw ingestion to curated stores.

• Performance Optimization: Optimized Snowflake performance via Clustering Keys, Materialized Views, and

SQL query tuning — reducing average query execution time by 40%.

• Data Security & Governance: Implemented RBAC, Dynamic Data Masking, and row-level security across data domains to enforce governance and privacy compliance.
• Data Modeling & dbt: Designed star schema, snowflake schema, and Data Vault models in dbt; enforced data quality through dbt tests and CI/CD-integrated documentation.
• Data Loading & Integration: Ingested JSON, Parquet, and AVRO from Azure Blob and AWS S3 via

Snowpipe and external stages to deliver API-ready datasets.

Data Engineer | Caliber

Mar 2023 – Sep 2023

• Data Pipeline & Cloud: Designed Python-based data ingestion pipelines to extract, transform, and load structured datasets into AWS S3; maintained Git feature-branch workflows and lifecycle policies for a clean,

documented codebase.

• SQL & Data Modeling: Wrote advanced SQL queries and built dimensional data models for scoring and ranking analytics, improving data accuracy and accessibility for downstream consumers.

M.Tech in Software Engineering – BITS Pilani

Expected 2027 | CGPA: 7.0/10.0

B.E. in Computer Engineering – MES College of Engineering, Pune

2023 | CGPA: 8.7/10.0