4 дня назад
Senior Analytics Engineer (BigQuery/dbt)
100 000 - 150 000CAD
Мэтч & Сопровод
Для мэтча с этой вакансией нужен 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
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, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →
Похожие вакансии
4 дня назад
Analytics Engineer (Fintech)
110 000 - 135 000CAD
Owner
3 дня назад
Data Platform Enginer (AI)
190 000 - 220 000$
4 дня назад
Data Developer (AI)
113 400 - 162 000CAD
5 дней назад
Senior Solutions Engineer (Python/SQL)
110 000 - 150 000CAD
4 дня назад
Senior Technical Analyst, Data Engineering and Business Intelligence
120 000 - 150 000CAD
5 дней назад
Data Engineer, Event Data
130 000 - 165 000CAD