Open to opportunities

Tony Garcia

@tonygarcia

Message

Senior Data Engineer building resilient, privacy-aware AWS and Snowflake data platforms.

United States

Message

What I'm looking for

I’m looking for a role where I can build privacy-aware AWS/Snowflake pipelines with Airflow and dbt, enforce strong data contracts and quality gates, and improve observability and performance—so analytics teams can trust results and move faster.

I’m a Senior Data Engineer with 10+ years building production-grade AWS data pipelines and Snowflake warehouses, orchestrated by Airflow and modeled with dbt. I focus on delivering resilient, privacy-aware measurement data for advertising analytics at EDO scale, with an emphasis on reliability, security, and trustworthy reporting.

At Sand Technologies, I built an identity-aware ad measurement pipeline that joins occurrence, outcome, and household data into production schemas across streaming and batch sources. I designed dbt incremental models and schema contracts to prevent silent breakages, and I hardened privacy handling with deterministic tokenization, least-privilege roles, and audit trails for compliance-driven datasets.

I also drive measurable quality and operational readiness through Great Expectations and dbt tests, structured event logging, and runbooks around partition freshness, SLA breaches, and anomaly signals. From tuning SQL performance to supporting safer backfills during migrations, I collaborate closely with data scientists to ensure features and warehouse semantics stay aligned in production.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Engineer

Current

Sand Technologies

May 2021 - Present (5 years 1 month)

Built an identity-aware ad measurement pipeline in AWS/Snowflake, joining streaming and batch sources into production schemas for analytics consumers. Improved data reliability and trust by adding dbt incremental loading with schema contracts, Airflow failure recovery with retries/idempotency, and privacy protections (tokenization, least-privilege access, audit logging).

Python SQL AWS S3 Snowflake Apache Airflow DBT Kafka Great Expectations Data Observability

Data Engineer

Capital One

Jun 2017 - Jan 2021 (3 years 7 months)

Designed an AWS ingestion and warehousing layer for marketing and customer analytics using S3, Glue, and Redshift to standardize event streams into consistent schemas. Increased pipeline resilience and reporting performance through Airflow batch/incremental orchestration, idempotent reloads, dbt dimensional modeling, and SQL query optimizations.

SQL AWS Glue Amazon Redshift AWS S3 Apache Airflow DBT Dimensional Models Anomaly Detection

Associated Software Developer

Wonder

Feb 2016 - May 2017 (1 year 3 months)

Developed early ETL services moving data between internal stores and reporting layers, adding validation to reduce downstream breakages from upstream changes. Improved dashboard reliability and performance by implementing SQL transformations/API query endpoints and fixing a join-key issue that stabilized nightly reconciliation runs across millions of records.

SQL API Development Data Validation Indexing