Open to conversations
BhoomitPatel
Senior Data Engineer·Arlington, VA
Zero-downtime migrations. Finance-grade pipelines. Koch scale.
dbt · Snowflake · Airflow · Koch Industries DMET. 8+ years in production.
BP
Experience
Work History
2024
Koch IndustriesNow
Data Engineer
i360 · DMET division. Part of Koch Industries ($130B+ private company).
- Led migration of the enterprise sales pipeline from Matillion to dbt on Snowflake, retiring AtScale and delivering full output parity across 145+ models.
- Architected SQL Server to PostgreSQL migration for the AR pipeline using Python, eliminating $100K+ in annual licensing costs while enabling 5+ downstream credit models.
- Owned end-to-end delivery of 5+ dbt/Snowflake data products over 12+ months — source migrations, schema changes, CRF framework extensions, and validation design.
- Extended CRF validation framework across 145+ models post-migration, ensuring 100% data integrity at cutover with zero regression in downstream reporting.
- Migrated intercompany data source from SharePoint to Sigma writeback, preserving schema alignment and historical data continuity with 30+ dbt assertions.
- Diagnosed and resolved 7 production pipeline failures in the fixed assets dbt product within 5 weeks, maintaining on-time quarter-end reporting for Koch finance teams.
- Enforced ABAC across 5+ Snowflake mart schemas via stored procedures, meeting enterprise security and compliance requirements.
- Standardized CI/CD pipeline templates across 5+ data products using GitLab, reducing configuration drift.
- Expanded AWS S3-to-PostgreSQL Airflow ETL pipeline by 26% with Python, adding automated error classification and alerting.
2021
Qualtrics LLC
Senior Technical Consultant, Data Engineering
SaaS experience management platform. ~$1B+ ARR, NYSE: XM.
- Led multi-API pipeline development that increased department revenue by $480K+ annually by enabling new data-intensive client workflows.
- Delivered data integrations for 6 pre-sales proof-of-concept projects, partnering with sales and engineering to win enterprise contracts.
- Reduced Sales Team POC delivery time by 15% through a reusable automation framework built during a 6-week cross-functional initiative.
- Designed customized data engineering solutions integrated with the Discover Analytics Platform using Python, SQL, and diverse pipeline architectures.
2019
Qualtrics LLC
Technical Consultant
SaaS experience management platform.
- Designed data solutions using Pentaho Kettle, PostgreSQL, Python, and JavaScript for 50+ clients across the full pipeline lifecycle.
- Led API integration for automated data purging — generated 20 sales opportunities, 5 SOWs from 35% of customers, saving 20 hours of manual work monthly.
- Designed SOPs for data export from the Qualtrics Discover platform, driving adoption across 30+ clients.
2018
Gemological Institute of America
Business Intelligence Developer
World's foremost authority on diamonds and gemstones. Carlsbad, CA.
- Designed ETL workflows integrating multi-source data into the enterprise data warehouse.
- Automated weekly, monthly, and ad-hoc executive reports using Python, reducing manual effort by 30%.
2017
University of Rochester Medical Center
ETL Data Analyst Intern
Academic medical center. Rochester, NY.
- Created SSIS packages to transform inbound data in compliance with HIPAA data privacy requirements.
- Designed ETL process to load data into the Enterprise Data Warehouse; documented on Confluence.
- Facilitated data migration to SQL Server using Migration Assistant.
2016
Paychex
SQL Developer Intern
HR and payroll services provider. Rochester, NY.
Skills
Technical Stack
Data Infrastructure
dbt (Data Build Tool)SnowflakeApache Airflowdbt CloudSnowpipedbt (Data Build Tool)SnowflakeApache Airflowdbt CloudSnowpipe
Languages
PythonSQLJavaScriptBashPythonSQLJavaScriptBash
Cloud & DevOps
AWS S3AWS IAMCross-Account AWSGitLab CI/CDAWS S3AWS IAMCross-Account AWSGitLab CI/CD
Data Quality & Governance
dbt AssertionsSchema Contract TestingABACSnowflake SecuritySQLFluffCRF Validation Frameworksdbt AssertionsSchema Contract TestingABACSnowflake SecuritySQLFluffCRF Validation Frameworks
Databases & ETL
PostgreSQLSQL ServerPentaho KettleSSISParquetREST API IntegrationPostgreSQLSQL ServerPentaho KettleSSISParquetREST API Integration
Projects
Selected Work
01
Enterprise Sales Pipeline: Matillion → dbt on Snowflake
Koch Industries i360 — production finance pipeline. Internal deployment.
Led end-to-end migration of Koch's enterprise sales pipeline from Matillion to dbt, retiring the AtScale semantic layer. Preserved full output parity across 145+ SQL models while modernizing to a staging → working → marts architecture.
145+ dbt models migrated with verified output parityAtScale semantic layer retiredMigration playbook adopted across team
AR Pipeline Migration: SQL Server → PostgreSQL
Architected and executed migration of Koch's Accounts Receivable pipeline from SQL Server to PostgreSQL using Python. Eliminated $100K+ in annual licensing costs and enabled 5+ downstream credit models.
Koch Industries i360 — production finance pipeline. Internal deployment.
$100K+ annual licensing costs eliminated5+ credit models unblockedZero data loss — schema contract verified
CRF Data Quality Framework — Snowflake Platform
Extended Koch's CRF validation framework to cover cross-source migration scenarios. Built 30+ dbt assertions from scratch, generalized across 3 source migrations and 145+ models.
Koch Industries DMET — cross-product data quality platform. Internal deployment.
30+ custom dbt assertions built from scratch100% data integrity across 145+ models post-cutoverZero production regressions across 3 source migrations
Airflow ETL Expansion — AWS S3 to PostgreSQL
Extended an existing AWS S3-to-PostgreSQL Airflow pipeline by 26%, adding new data sources, automated error classification, and alerting. Eliminated silent failures that previously required manual audit.
Koch Industries i360 — internal reliability team. Internal deployment.
26% expansion in pipeline coverageAutomated error classification and alerting added
Qualtrics API Pipeline — Revenue Enablement
Led multi-API pipeline development for large-scale voice and digital interaction datasets at Qualtrics. Unlocked enterprise client workflows blocked by integration limitations.
Qualtrics Discover Platform — enterprise client delivery.
$480K+ annual incremental revenue6 enterprise POC integrations delivered15% reduction in POC delivery time
Education
Academic Background
Rochester Institute of Technology
Master of Science, Information Science
Aug 2018
University of Mumbai
Bachelor of Engineering, Information Technology
May 2015
UVA Darden School of Business
Specialization Certificate, Digital Product Management
May 2023
About
A bit about me
I'm a Senior Data Engineer with 8+ years designing and operating production data systems across enterprise organizations. At Koch Industries, I own the DMET team's dbt/Snowflake data products — finance, tax, and accounting pipelines at one of the largest private companies in the US.
My last three migrations shipped on schedule with no rollback events. I build for the engineer who inherits the system — documentation, assertions, and a pipeline that fails loudly so the problem is never ambiguous
8+
years, zero downtime
396
SQL models in production
$100K+
annual licensing eliminated
0
rollback events across 3 migrations