Sr DBT Analytics Engineer

Mastech Digital is seeking a Sr DBT Analytics Engineer to design and implement robust data models and maintain scalable dbt transformation pipelines. The role involves collaborating with various stakeholders, implementing data quality tests, and following best practices in analytics engineering.

Responsibilities:

• 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

Requirements:

• 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