Skip to Main Content

Job Title


Sr AWS DBT Engineer


Company : Mastech Digital


Location : regina, Saskatchewan


Created : 2026-04-16


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 DoDesign 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 For5+ 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.