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.
Job Title
Sr AWS DBT Engineer - Mastech Digital