Senior DBT Engineer, Toronto

Authorized to work in Canada - Open Work Permit, PR, Canadian Citizen acceptable

Title: Data Analytics Engineer

Duration: Long term

Location: Remote/Canada

Job Description:

What You'll Do

• Design and implement robust dimensional and relational data models.
• Build and maintain scalable dbt transformation pipelines.
• Own transformation and modeling of curated (Silver/Gold) datasets.
• Collaborate with analysts, product analytics, data scientists, and stakeholders.
• Implement data quality tests, monitoring, SLAs, and alerting.
• Partner with Data Engineers to define and enforce data contracts.
• Follow analytics engineering best practices (version control, testing, documentation).
• Empower self-service analytics with intuitive, well-documented data marts.

What We're Looking For

• 5+ years in analytics engineering, data modeling, or similar roles.
• Expert-level SQL skills (optimization & performance tuning).
• Extensive dbt experience (testing, documentation, package management).
• Strong Python programming skills.
• Deep understanding of dimensional modeling (star schemas, one big table).
• Experience with cloud data warehouses (Snowflake, BigQuery, Redshift, Databricks).
• Familiarity with Airflow and orchestration frameworks.
• Experience with Git and CI/CD for analytics code.
• Strong business acumen and ability to translate requirements into data models.
• Knowledge of data governance, privacy, compliance (GDPR, CCPA, SOX).
• Familiarity with BI tools (Tableau, Looker, Mode).
• Strong ownership mindset and communication skills.
• Dedication to data quality, documentation, and enabling self-service analytics.
• Bachelor's Degree in a technical field, or equivalent experience.