Open to opportunities

David Pavao

@davidpavao

Message

Staff software engineer specializing in data platforms and analytics.

United States

Message

What I'm looking for

I seek a role building reliable, scalable data platforms and streaming pipelines where I can drive data contracts, optimize cost/performance, and collaborate with product and analytics teams to enable self-serve insights.

I am a staff-level software engineer with 15+ years designing and operating data platforms, streaming pipelines, and analytics infrastructure across marketplace, e-commerce, and healthcare domains. I have led end-to-end platform builds that standardized Kafka topics and schemas, implemented dbt dimensional models, and delivered near-real-time data freshness for critical business domains.

My work has driven measurable improvements: reduced ad-hoc reporting by ~40%, cut monthly data platform costs by ~25%, accelerated reporting from days to minutes, and improved detection of operational issues through streaming dashboards. I prioritize reliability, data contracts, performance optimization, and close collaboration with product and analytics teams to enable self-serve insights and dependable metrics.

Experience

Work history, roles, and key accomplishments

Current

Staff Software Engineer

Current

OfferUp

Jan 2021 - Present (5 years 1 month)

Led design and build of a unified event-driven data platform (Kafka → Flink/Spark → Snowflake/S3) to deliver sub-5-minute data freshness, standardized schemas/contracts, and reduced downstream failures while cutting platform costs ~25%.

Kafka Snowflake Spark DBT Airflow S3 Data Modeling Data Quality

Senior Software Engineer

OfferUp

Nov 2019 - Jan 2021 (1 year 2 months)

Designed and implemented the consolidated event collection pipeline and ETL jobs (Airflow + Python + Spark) to normalize marketplace activity into Snowflake/Redshift, reducing report generation time from days to minutes and improving metric consistency.

Kafka Python Airflow Spark Redshift Snowflake ETL DBT Data Warehousing

Senior Software Engineer

Chewy

Jul 2016 - Nov 2019 (3 years 4 months)

Owned order, inventory, and pricing pipelines and built ETL (Airflow + Python + Spark) and dimensional models to move data into Redshift/S3, improving data freshness to hourly/near-real-time and reducing OLTP load ~30%.

Airflow Python Spark Redshift S3 Data Modeling ETL Looker Tableau

Senior Software Engineer

Intermedix

May 2008 - Feb 2016 (7 years 9 months)

Designed and maintained ETL processes and a SQL Server data warehouse for healthcare/emergency management, reducing batch processing time ~60% via indexing, partitioning, and parallelization and enabling operational reporting.