Team: Data Engineering & Automation

• Implemented SSO with JIT provisioning via SAML 2.0, allowing users to login with an IdP (e.g. Okta).

• Unified login across Klaviyo & external services (Klaviyo Community + Academy) with SAML 2.0, boosting registration by >35%.

• Optimized MySQL query patterns by migrating reads to replicas, refactoring, and detecting anomalies, lowering data volume & CPU usage.

• Created authentication layer for Klaviyo V3 developer-facing APIs, enabling secure access.

• Coordinated & worked on Python 2/3 + Django 1/2 version upgrades for increased reliability.

Team: Application Security

• Decoupled data ingestion from monolith, achieving 300K daily messages and faster integration time for Amazon & Walmart marketplace/seller APIs.

• Built ELT pipeline from data lake to Snowflake, enabling analytics & real-time bidding ML models.

• Wrote Scala library for managing JDBC connections to Snowflake utilizing HikariCP, simplifying development.

Team: Infrastructure

• Integrated social media APIs (e.g. Twitter Ads) into a business-critical, distributed data ingestion system, processing millions of events into the data lake daily.

• Constructed dimensional models for UGC performance via incremental, batch ETL pipeline in Redshift, generating >250 million facts.

• Created data marts (e.g cross-platform aggregates) in Redshift tracking >$1 billion of social advertising spend, served with Ruby on Rails.

• Performed ad hoc tasks such as querying SQL data stores and reprocessing Kafka backups from an S3 data lake.

Team: Data Ingestion / Backend