Skip to Main Content

Job Title


Sr AWS DBT Engineer


Company : Mastech Digital


Location : Canada,


Created : 2026-05-01


Job Type : Full Time


Job Description

Responsibilities: As a Senior Analytics Engineer, you will transform this wealth of data into trusted, well-modeled datasets that power analytics, reporting, and data science initiatives across the organization. What Youll 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 Were 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. - Bachelors Degree in a technical field, or equivalent experience.