Passage
Senior Analytics Engineer
Toronto Ontario. Posted 3 months ago
The role
You will own the data platform end to end. You will model the business in dbt on BigQuery and run pipelines using Airflow 3.
What you will do
- Model the business in dbt on BigQuery using Kimball dimensional modeling.
- Own metrics including executive KPIs, conversion funnels, cohort analytics, and marketing attribution.
- Run pipelines using Airflow 3 orchestration with Slack alerting, data-quality tests, and freshness monitoring.
- Serve data through a dbt serving layer via Hasura GraphQL and Metabase.
- Turn operational reality into trusted tables through business-logic modeling.
- Keep quality and cost in check using dbt tests, documentation, and BigQuery partitioning.
- Document models for humans and AI.
Required qualifications
- 4+ years building analytics or data platforms
- Expert-level SQL
- Run dbt in production
- Real dimensional-modeling instincts
- Operated an orchestrator (Airflow or similar)
- Comfortable in Python
- Ability to prioritize, communicate, and ship without a spec
Nice to have
- CDC pipelines (Debezium, Airbyte) or Kafka Connect
- Kubernetes/Helm exposure
- BigQuery performance and cost tuning
- Hasura/GraphQL, reverse ETL, or embedding warehouse data into product surfaces
- Metabase or Looker administration
- Experience as an early or solo data hire at a startup
- Fluency with AI-assisted development workflows
About the company
Passage helps international students navigate their journey abroad by assisting with program choice, admission, financing, and visas.