Back to Experience

Infrastructure Engineering Intern

Shopify
2025-09 - 2025-12
TypeScriptGoogle BigQueryLooker StudioSQL

Overview

Worked on the infrastructure team focusing on performance benchmarking and end-to-end test orchestration.

Key Achievements

  • Architected Google BigQuery schema for ingesting over 5 million performance datapoints weekly, and crafted analytical SQL queries for Looker Studio dashboards analyzing key metrics
  • Built a performance benchmark pipeline using TypeScript, reducing performance regression investigation time by 81%
  • Designed and implemented orchestration infrastructure for end-to-end tests using TypeScript, accelerating end-to-end test runtime by 22%
Jerry Zhang