Skills required
Snowflake adapter
Dynamic Tables
data_modelling
git-based_version_control_cicd
snowflake_sql_optimization
Education/Qualification
Bachelor’s degree in a related field
Desirable skills
Ability to influence and build trust with C-suite stakeholders.
Years of experience
5–12 years
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.