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 Big Query. Own a ~100-model project (staging to intermediate to 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 marketing attribution across Google Ads, Meta Ads, and UTM/click-ID data.Run the pipelines. Airflow 3 orchestration with Slack alerting, data-quality tests, freshness monitoring, and backfills. Ingestion is CDC from our production Postgres via Debezium + Kafka Connect on GKE (with Airbyte and Fivetran alongside).Serve the data. A dedicated dbt serving layer exposed through Hasura Graph QL powers internal ops tools in the product itself; Metabase serves dashboards and self-serve queries.Turn messy operational reality into tables people trust. Much of the work is business-logic modeling: screening outcomes,

📌 Senior Analytics Engineer (Toronto)
🏢 Passage
📍 Toronto