About the Role
You'll own Passage's data platform end to end. This is a high-leverage, high-trust seat where the models you build define how the company measures itself, and your stakeholders are leadership, marketing, and operations.
Responsibilities
- Model the business in dbt on BigQuery, owning a ~100-model project.
- Own metrics people rely on, including executive KPIs, conversion funnels, cohort analytics, and marketing attribution.
- Run the pipelines using Airflow 3 orchestration with Slack alerting, data-quality tests, freshness monitoring, and backfills.
- Serve the data through a dbt serving layer exposed through Hasura GraphQL and Metabase.
- Turn messy operational reality into trusted tables by digging into source systems and talking to stakeholders.
- Keep quality and cost in check through dbt tests, documentation, and BigQuery optimization.
- Document for humans and AI, ensuring auto-sync to a companion repo.
Requirements
- 4+ years building analytics or data platforms with expert-level SQL.
- Experience running dbt in production with strong dimensional modeling instincts.
- Experience operating an orchestrator (Airflow or similar) and comfort in Python.
- Enjoy ambiguous business-logic modeling, reverse-engineering schemas, and interviewing stakeholders.
- Ability to write documentation people actually use.
- Can own a platform solo: prioritize, communicate, and ship without a spec.
Skills
- SQL
- dbt
- BigQuery
- Airflow 3
- Debezium
- Kafka Connect
- GKE
- Airbyte
- Fivetran
- Hasura
- GraphQL
- Metabase
- PostgreSQL
- Django
- Docker
- GCP
- Python
- Dimensional Modeling
- Kimball dimensional modeling
- SCD Type 2
- CDC pipelines
- Kubernetes
- Helm
- Reverse ETL
- Looker
- AI-assisted development
Experience Level
- 4+ years
Salary/Compensations
- C$100K to C$150K
Benefits
- Offers Equity
About the Company
- Passage helps international students navigate their journey abroad — from choosing a program and getting admitted to financing their studies and helping with their visa.
- We are building a company designed to expand access to life-changing opportunities around the world.
- If you are excited about building systems, solving complex problems, and shaping how a company makes decisions, we would love to meet you.
Equal Opportunity
- Artificial intelligence may be used in the screening or assessment of applicants.
- If your experience does not match every requirement but you believe you can thrive in this role, we encourage you to apply.
