Kaiwen Yang

Work

From messy inputs to useful systems. A record of what I’ve built and who I’ve built it with.

2021—2027 · hatched = expected
  1. 2021-09 → 2025-05Honours Bachelor of ScienceUniversity of Toronto
  2. 2023-05 → 2023-07Business Analyst Intern, Human ResourcesCapgemini China
  3. 2024-04 → 2024-08Research AssistantDepartment of Economics, University of Toronto
  4. 2025-06 → 2025-07Data Analyst Intern, Executive OfficeCodemao
  5. 2025-09 → 2027-05 (expected)MEng, Computer EngineeringUniversity of Toronto
  6. 2025-09 → nowTeaching AssistantUniversity of Toronto
  7. 2026-04 → nowMapping & Data Visualization AssistantSchool of Cities, University of Toronto
Education and work, 2021 to 2027Outlined bars show education. Filled bars show work. Hatching shows an expected future period. Each bar links to its detailed entry. Dates and descriptions are also in the education and work lists.2021202220232024202520262027HBScMEngCapgemini ChinaEconomics RACodemaoTeachingSchool of CitiesNow · 2026-10-27

Outlined: education · Filled: work · Select a bar to read more.

012026-04 → now

Mapping & Data Visualization Assistant

School of Cities, University of Toronto · Toronto, ON

  • Integrated three elections and census data in Python; implemented election–census interpolation using population weights.
  • Modeled electoral participation using PLS, Elastic Net, and supervised PCA; validated with spatially blocked nested cross-validation.
  • Delivered 6 reproducible ELT pipelines and a real-time monitor; developed 5 interactive dashboards and 6 analytical figures.
  • Co-authored “One city, uneven participation” with Aniket Kali: an interactive report exploring neighbourhood patterns in voter turnout across three Toronto elections. Published by the School of Cities as Part 8 of Place & Politics in Toronto (October 2026).
  • python
  • pls
  • elastic-net
  • elt
  • dashboards
022025-09 → now

Teaching Assistant

University of Toronto · Toronto, ON

12 Python labs designed · 600+ students mentored · 55 teams guided

See teaching appointments →
032025-06 → 2025-07

Data Analyst Intern, Executive Office

Codemao · Shenzhen, China

  • Analyzed retention for 2,000+ users using SQL and Python, including cohort analysis and retention curve modeling.
  • Built ETL pipelines processing 30,000+ user records and developed 4 Superset dashboards, enabling real-time monitoring.
  • sql
  • python
  • etl
  • superset
042024-04 → 2024-08

Research Assistant

Department of Economics, University of Toronto · Toronto, ON

  • Collected 3,000+ rows of structured data via web scraping and APIs in R; consolidated a SQL schema from 7 tables to 5.
  • Applied regression and difference-in-differences with visualization to identify high-value satellite portfolio strategies.
  • r
  • sql
  • regression
  • difference-in-differences

↳ Also in Research

052023-05 → 2023-07

Business Analyst Intern, Human Resources

Capgemini China · Beijing, China

  • Analyzed 10 years of graduate salary data across universities using Excel and SQL to support HR decision-making.
  • Evaluated employee workload using SQL models, reducing program costs by $45,000; worked in a team of 6 to shorten training-material preparation from 2 weeks to 5 days, saving an additional $20,000.
  • Designed functional logic diagrams and system architecture; collaborated with front-end and back-end engineers to validate 20+ functionalities before release.
  • sql
  • excel
  • analysis
  • system-design