I design and deliver production-grade Snowflake ELT platforms that modernize legacy Oracle and SQL Server workloads into scalable, governed, and high-performance cloud data platforms.
My work focuses on data modeling, orchestration, performance optimization, and cost-efficient data processing — building reliable pipelines that are easy to maintain, audit-ready, and built for enterprise-scale analytics.
With 14+ years of overall IT experience, including 5+ years specializing in Snowflake Data Engineering, I enjoy solving complex data engineering challenges through modern architecture, automation, and cloud-native best practices.
My day-to-day is Medallion architecture — Bronze, Silver, Gold — built on dbt Core and orchestrated through Apache Airflow, with Python filling the gaps around ingestion and validation. I lean toward metadata-driven design: config-driven joins over hardcoded SQL, reusable Jinja macros over copy-pasted models, SCD Type 2 snapshots over manual history tracking. A pipeline is only good if the next engineer can extend it without rewriting it.
The other half of the job is migration and governance. I've moved production Oracle systems onto Snowflake, converted nightly batch procedures into incremental dbt models, and spent a fair amount of time inside Query Profile chasing down the warehouse settings quietly inflating a Snowflake bill. RBAC and Dynamic Data Masking aren't an afterthought — they go in alongside the pipeline, not after an audit asks for them.
- Snowflake Engineering — Enterprise edition, External Stages, Storage Integration, Snowpipe, Time Travel, Zero-Copy Cloning, Clustering Keys, Query Profile tuning
- ELT with dbt Core — Incremental models, Jinja macros, Snapshots (SCD Type 2), singular tests, ephemeral models, source & lineage documentation
- Orchestration — Apache Airflow DAGs, dependency management, retry logic, failure alerting, scheduled production runs
- Data Modeling — Medallion architecture, Star Schema, One Big Table (OBT), metadata-driven pipeline design, fact/dimension modeling
- Cloud Migration — Oracle & SQL Server → Snowflake, schema conversion, batch-to-incremental re-architecture, cutover validation
- Governance & Security — RBAC, Dynamic Data Masking, Row Access Policies, column-level security
- Cloud & Storage — Azure Blob Storage, Azure Data Factory, AWS S3, Service Principal auth
- Languages — Advanced SQL, T-SQL, PL/SQL, Python (Pandas, Snowflake Connector), Jinja2
Transformation & Orchestration
🚀 sql-server-to-snowflake-migration
Migrating off SQL Server usually means hand-converting schemas and hoping the data lands intact. This project automates the schema conversion and data validation steps of that migration end to end, so the cutover itself is repeatable instead of a one-off script someone runs at 2am.
Snowflake Python Azure Data Factory
💰 snowflake-finops-toolkit
Snowflake bills climb quietly — an idle warehouse here, an oversized auto-suspend setting there. This toolkit tracks credit consumption in real time and surfaces the warehouse configurations actually driving cost, the same class of tuning that cut compute spend by 40% on a past production migration.
SQL Python Streamlit
⚡ modern-elt-pipeline-dbt-adf
A reference implementation of the Medallion architecture (Bronze → Silver → Gold) I run in production — dbt Core for transformation, Azure Data Factory for ingestion, built to scale as new source systems get added.
Snowflake dbt Core Azure Data Factory
🔒 enterprise-rbac-data-masking
A layered RBAC hierarchy paired with Dynamic Data Masking at the column level, modeled on the governance patterns used to pass 100% of internal audits across 30+ production schemas in a prior engagement.
Snowflake Security RBAC Dynamic Data Masking
🧊 snowflake-iceberg-lakehouse
A strategy and reference setup for Iceberg tables on Snowflake — evaluating where open table formats make sense for cheaper, more flexible long-term storage.
Iceberg Snowflake
- Production-grade ELT pipelines on Medallion architecture
- Legacy Oracle & SQL Server → Snowflake migrations
- Metadata-driven, config-based data models
- Incremental dbt models with SCD Type 2 history
- Airflow-orchestrated pipelines with retry and alerting
- Warehouse performance tuning & cost optimization
- RBAC and Dynamic Data Masking for governed data delivery
Currently open to Snowflake Data Engineer, Data Engineer, and Cloud Data Engineering roles — full-time or contract.
Building scalable data platforms, one pipeline at a time.