3 months ago
Toronto, CanadaSenior
Responsibilities
- Own and extend Passage’s BigQuery data warehouse and approximately 100-model dbt project.
- Build dimensional models including staging, intermediate, and mart layers, SCD Type 2 dimensions, fact tables, and aggregate reporting tables.
- Define and maintain executive KPIs, conversion funnels, cohort analytics, and marketing attribution across Google Ads, Meta Ads, and UTM/click-ID data.
- Operate Airflow pipelines with Slack alerting, data-quality tests, freshness monitoring, and backfills.
- Manage CDC ingestion from production PostgreSQL using Debezium, Kafka Connect, GKE, Airbyte, and Fivetran.
- Serve warehouse data through a dbt serving layer, Hasura GraphQL, Metabase, and internal operations tools.
- Model complex operational business logic including screening outcomes, payment and fee states, deferral lineage, and guarantor chains.
- Maintain documentation, BigQuery partitioning and clustering, data quality, and query-cost controls.
- Work with leadership, marketing, operations, and process owners to deliver trusted metrics and documented data marts.
Requirements
- At least 4 years of experience building analytics or data platforms.
- Expert-level SQL skills and production experience with dbt.
- Strong dimensional-modeling knowledge, including data grain and SCD Type 2 modeling.
- Experience operating Airflow or a similar orchestrator and comfort with Python.
- Ability to reverse-engineer production schemas, interview stakeholders, and model ambiguous business logic.
- Ability to own a data platform independently, prioritize work, communicate clearly, and deliver without a detailed specification.
- Strong documentation skills.
Benefits
- C$100K to C$150K base compensation.
- Equity offers.
- AI may be used in applicant screening or assessment.
- Applicants who do not match every requirement are encouraged to apply.
Tech Stack
AirbyteApache AirflowdbtDjangoDockerGoogle BigQueryGoogle Cloud PlatformGraphQLHelmKubernetesMetabasePostgreSQLPythonSQL
Categories
Data Engineering
About Passage
Passage builds a platform that guides international students and skilled workers into Canada—helping with program selection and admission, funding studies, and visa support—and connects them to employers facing labor shortages. The Toronto-based company, founded in 2023, combines recruiting services with access to financing to lower the upfront cost of study-abroad and immigration. It is privately held and focuses on channels that bring applicants from multiple countries into Canadian schools and jobs.