Назад
Company hidden
4 дня назад

Senior Analytics Engineer (BigQuery/dbt)

100 000 - 150 000CAD
Формат работы
onsite
Тип работы
fulltime
Грейд
senior
Английский
b2
Страна
Canada
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
Senior Analytics Engineer (BigQuery/dbt): Owning and extending a production data platform that powers executive KPIs, marketing attribution, funnel analytics, and internal operations tools with an accent on dimensional modeling, pipeline reliability, and trusted business metrics. Focus on building dbt models and marts, operating Airflow and CDC pipelines, encoding complex operational logic, and controlling BigQuery data quality and costs.

Location: Toronto, Ontario; on-site

Compensation: C$100K–C$150K + equity

Company

hirify.global helps international students choose programs, get admitted, finance their studies, and navigate the visa process.

What you will do

  • Own and extend the production data warehouse supporting executive KPIs, marketing attribution, funnel analytics, and internal operations tools.
  • Build and maintain approximately 100 dbt models in BigQuery, including staging, intermediate, marts, SCD Type 2 dimensions, fact tables, and aggregate tables.
  • Operate Airflow 3 pipelines with Slack alerting, data-quality tests, freshness monitoring, and backfills.
  • Maintain CDC ingestion from production PostgreSQL using Debezium, Kafka Connect on GKE, Airbyte, and Fivetran.
  • Serve warehouse data through Hasura GraphQL for internal product tools and through Metabase for dashboards and self-service analysis.
  • Translate complex operational processes into documented, tested tables and metrics while working with leadership, marketing, and operations stakeholders.

Requirements

  • 4+ years of experience building analytics or data platforms with expert-level SQL.
  • Production dbt experience and strong dimensional-modeling skills, including explicit grain, SCD Type 2 dimensions, and fact tables.
  • Experience operating Airflow or a similar orchestrator and comfort with Python.
  • Ability to reverse-engineer production schemas, interview stakeholders, model ambiguous business logic, and work independently.
  • Strong technical documentation skills and the ability to own a data platform day to day.

Nice to have

  • Experience with Debezium, Airbyte, Kafka Connect, Kubernetes, or Helm.
  • BigQuery performance and cost tuning experience.
  • Hasura, GraphQL, reverse ETL, or embedding warehouse data into product surfaces.
  • Metabase or Looker administration experience.
  • Experience as an early or solo data hire at a startup and familiarity with AI-assisted development workflows.

Culture & Benefits

  • High-trust, high-leverage ownership with direct stakeholders in leadership, marketing, and operations.
  • Opportunity to shape how the company measures performance and makes decisions.
  • Documented coding standards and AI-assisted development practices.
  • Equity included in the compensation package.
  • Artificial intelligence may be used during applicant screening or assessment.

Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →