Built and maintained backend APIs powering customer-facing analytics dashboards, integrating data from Snowflake, PostgreSQL, and internal services
Designed and implemented high-cardinality data pipelines and rollup tables in Snowflake to support new product features (e.g., referrer analytics)
Led development of historical recirculation metrics, collaborating with data science to define and validate complex analytical logic
Optimized Snowflake performance and cost by tuning queries, resizing compute warehouses, and identifying high-cost workloads (e.g., remote byte spillage)
Improved system observability and debugging by implementing query tagging and analyzing query performance across services
Ensured data accuracy and reliability by identifying and resolving discrepancies in production data pipelines
Strengthened system security by fixing a critical authorization vulnerability and enforcing stricter access control across services
Participated in on-call rotation, troubleshooting production incidents and scaling systems during high-traffic events
