Position: Analytics Engineer – Snowflake
Duties & Responsibilities:
- dbt Core or dbt Cloud with Snowflake adapter.
- Dynamic Tables for declarative, incremental transformations.
- Data modeling: staging, intermediate, and mart layer patterns.
- dbt testing, documentation, and data contracts.
- Incremental models, snapshots, and slowly changing dimensions (SCD).
- Jinja templating and dbt macros for reusable transformations.
- Git-based version control and CI/CD for dbt projects.
- Snowflake SQL optimization: CTEs, window functions, semi-structured data.
Experience:
- 3+ years in analytics/data engineering with at least 1 year using dbt on Snowflake
- Delivered 2+ dbt projects with 50+ models in production
- Clear communication skills for client interactions and technical documentation
Company Description:
At Mastech Digital, we solve meaningful business problems using data, AI, and modern digital technologies. Our teams work closely with global enterprises to build solutions that create real, measurable impact.
We bring deep industry expertise across Utilities & Energy, Financial Services, Healthcare, Retail, and Technology. With an AI-first mindset and a collaborative culture, we empower our people to innovate, grow, and help clients move forward with confidence.
