Looking for a job

Kalpit Joshi

@kalpitjoshi

I build Snowflake, DBT and AWS lakehouse platforms that modernize enterprise data, reduce costs, and enable AI using Data Modeling techniques.

India

Message

What I'm looking for

I'm looking to lead hands-on architecture and modernization of enterprise data platforms, combining Snowflake, AWS, lakehouse design, and AI-enabled engineering while setting standards and mentoring teams.

At ISPL, I own the architecture and technical direction for an enterprise Snowflake Lakehouse platform on AWS, integrating DBT, Airflow, Glue, Lambda, and S3 for reporting and operational analytics.

I build metadata-driven ETL/ELT frameworks processing 20TB per day and use Snowflake Cortex AI, LLMs, RAG, and Agentic AI to automate metadata discovery, documentation, and pipeline troubleshooting.

Previously at Encora, I architected more than 200 Snowflake ELT pipelines for investment banking and capital-markets clients, designed Data Vault 2.0 models for auditable reporting, and led 10 engineers as technical authority. At Jeavio, I migrated 220TB of legacy workloads to Snowflake on AWS and improved reporting SLAs by 70% through reusable DBT frameworks.

Across healthcare, pharma, banking, payments, telecom, and capital markets, I design governed data foundations, tune performance, and mentor engineers. I bring 15+ years of hands-on experience in data modeling, cloud modernization, and scalable batch and streaming platforms.

Experience

Work history, roles, and key accomplishments

Current

Staff Data Engineer

Current

ISPL

Mar 2026 - Present (6 months)

Owns end-to-end architecture for enterprise Snowflake Lakehouse platform on AWS, integrating DBT, Airflow, Glue, Lambda, and S3. Builds metadata-driven ETL/ELT frameworks processing 20TB/day and applies Snowflake Cortex AI for automation.

Snowflake Cortex DBT Airflow AWS Glue Lambda S3 Delta Lake Iceberg Parquet RAG Agentic AI Data Modeling Data Lineage

Technical Lead – Data Engineering

Encora

Jul 2024 - Mar 2026 (1 year 8 months)

Architected 200+ Snowflake ELT pipelines using DBT, Airflow, and AWS for Investment Banking clients. Designed Data Vault 2.0 models and led a team of 10 engineers, establishing governance practices.

Snowflake DBT Airflow AWS Glue Lambda S3 Redshift Kinesis Data Vault Terraform CI CD Data Governance RBAC SQL Optimization

Senior Software Engineer – Data

Jeavio

Oct 2021 - Jul 2024 (2 years 9 months)

Designed Snowflake-based enterprise data warehouses using Kimball dimensional modeling. Architected metadata-driven ETL/ELT pipelines with DBT, Airflow, ADF, Databricks, and Python, and led migration of 220TB legacy workloads to Snowflake.

Snowflake Kimball DBT Airflow Azure Data Factory Databricks Python SQL Data Migration CI CD Data Modeling

Senior Member Technical Staff – 2

Model N

Dec 2015 - Sep 2021 (5 years 9 months)

Designed scalable relational and dimensional data models for pricing analytics and revenue optimization. Built PySpark ETL workflows and delivered high-performance SQL solutions for large transactional reporting.

Data Modeling PySpark Python SQL ETL Healthcare

Data Engineer

SunGard

Mar 2015 - Nov 2015 (8 months)

Provided SQL-based data integration and enterprise data warehouse/ETL solutions for global Capital Markets clients, focusing on securities processing and reporting.

SQL ETL Data Warehouse Capital Markets

Data Engineer

Amdocs

Sep 2010 - Mar 2015 (4 years 6 months)

Delivered SQL-based data integration and enterprise data warehouse/ETL solutions for global Telecom clients, focusing on billing and customer analytics reporting.

SQL ETL Data Warehouse Billing Customer Analytics