Kalpit Shrestha
@kalpitshrestha
Data Analyst who builds reliable pipelines and dashboards, turning complex data into executive-ready insights.
United StatesWhat I'm looking for
I’m a Data Analyst with advanced experience in data engineering and analytics across healthcare and financial services. I design and optimize end-to-end data pipelines, transforming raw data into clean, reliable datasets and executive dashboards that drive actionable decisions.
In my recent role as a Sr. Data Analyst, I developed dbt models to standardize business logic, built advanced T-SQL stored procedures and indexed views for performance, and implemented Change Data Capture with incremental processing to improve data freshness.
I also support near-real-time ingestion using Kafka and AWS Kinesis, automate Snowflake transformations with Streams and Tasks, and integrate API-based JSON datasets and third-party vendor feeds into governed warehouse layers using Python. I focus on data quality through validation, reconciliation, and enterprise data-quality frameworks aligned with compliance needs.
Earlier, as a Data Engineer and SQL Developer, I led migrations from on-prem SQL Server to Azure and cloud platforms (Snowflake, Amazon Redshift), built ETL/ELT workflows with SSIS, Azure Data Factory, AWS Glue, and Airflow, and delivered performance gains by tuning queries, indexing strategies, and clustering/distribution.
Experience
Work history, roles, and key accomplishments
Sr. Data Analyst
Sutter Health
Feb 2025 - Present (1 year 5 months)
Built Python-based data transformation and validation workflows and maintained dbt models to standardize business logic into analytics-ready datasets. Designed dimensional models, implemented CDC/incremental processing, and created near-real-time ingestion pipelines using Kafka and AWS Kinesis while delivering Snowflake/Redshift BI-ready outputs and Power BI dashboards.
Data Engineer
Berkshire Hathaway
Sep 2021 - Nov 2024 (3 years 2 months)
Optimized SQL Server workloads by tuning stored procedures and queries and applying indexing and execution plan analysis. Developed and migrated enterprise ETL/ELT pipelines to Azure and AWS, including Azure Data Factory/ADLS pipelines, SSIS workflows, and Spark-based processing, while building dimensional data vault schemas and implementing data validation and reconciliation frameworks.
SQL Developer
NantHealth
Mar 2020 - Aug 2021 (1 year 5 months)
Designed end-to-end data pipelines from ingestion through transformation and validation to support reliable datasets for data scientists and business users. Built and optimized T-SQL objects, dimensional models (star/snowflake), SSIS/Azure Data Factory ETL workflows, Snowflake ELT pipelines, and reporting assets including SSRS and Power BI, while integrating REST API and vendor JSON data and suppo
Education
Degrees, certifications, and relevant coursework
Westcliff University
Master of Science in Information Technology, Information Technology
Earned a Master of Science in Information Technology from Westcliff University.
Tech stack
Software and tools used professionally
Availability
Location
United StatesAuthorized to work in
Job categories
Skills
Interested in hiring Kalpit?
You can contact Kalpit and 90k+ other talented remote workers on Himalayas.
Message KalpitGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
