Senior Analytics Engineer
Passage — Toronto Ontario
Posted 2026-08-06
ABOUT PASSAGE
Passage helps international students navigate their journey abroad — from choosing a program and getting admitted to financing their studies and helping with their visa.
THE ROLE
You'll own Passage's data platform end to end. Not a greenfield project and not a legacy mess: a working, documented warehouse that the company already runs on — executive KPIs, marketing attribution, funnel analytics, and internal ops tools are all powered by it today. Your job is to take ownership, keep it trustworthy, and extend it as the business grows.
This is a high-leverage, high-trust seat. The models you build define how the company measures itself, and your stakeholders are leadership, marketing, and operations — not a ticket queue.
WHAT YOU'LL DO
- Model the business in dbt on BigQuery. Own a ~100-model project (staging → intermediate → marts) built on Kimball dimensional modeling: SCD Type 2 dimensions, fact tables with explicit grain, and aggregate tables for reporting. Recent work includes applicant milestone tracking, loan-process stage modeling, and ad-click-level attribution.
- Own metrics people rely on. Executive KPIs, conversion funnels, cohort analytics, and