← All roles

Senior Analytics Engineer

Passage· Technology
Apply on company site
Toronto OntarioCA$100k - CA$150kFull-timePosted 2mo ago

About the role

Senior analytics role owning Passage's data platform end to end, maintaining a working warehouse with executive KPIs, marketing attribution, funnel analytics, and internal ops tooling; focuses on trustworthy data, scalable modeling, and cross-functional impact.

Responsibilities

  • 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.
  • 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 GraphQL powers internal ops tools in the product itself; Metabase serves dashboards and self-serve queries.
  • Turn messy operational reality into tables people trust. Business-logic modeling: screening outcomes, payment and fee states, deferral lineage, guarantor chains; encode truth after stakeholder discussions.
  • Keep quality and cost in check. dbt tests, per-model documentation, BigQuery partitioning/clustering, and bytes-scanned discipline.
  • Document for humans and AI. Every model documented; docs auto-sync to a companion repo for human and AI querying; AI-assisted development standards.

Qualifications

  • 4+ years building analytics or data platforms, expert-level SQL.
  • Production dbt experience and strong dimensional-modeling instincts (grain-driven thinking; SCD Type 2).
  • Operated an orchestrator (Airflow or similar) with Python proficiency.
  • Ability to reverse-engineer production schemas, interview stakeholders, and ship a table that resolves debates.
  • Proven ability to write practical documentation that is used by others.
  • Comfort with owning a platform solo: prioritizing, communicating, and shipping without a spec.

Skills

Required:SQLdbtBigQueryAirflow
Nice to have:Python

Benefits

  • Compensation: C$100K to C$150K + Equity
Last updated Aug 13, 2026. Interested? Apply on the company site.

About Passage

Providing access to life-changing opportunities

The most advanced AI engine for processing applications. From student admissions to professional licensing, Passage connects talent to life-changing opportunities.

AI application processingstudent admissionsprofessional licensingimmigration support
Company profileWebsite

More open roles at Passage