Snowflake AI/Agent Engineer- Mid Level

Strong Snowflake fundamentals: warehouses, databases, schemas, stages, streams, tasks, dynamic tables, Snowpark, security, RBAC, masking policies.

• Hands-on experience with Snowflake Cortex / CoCo use cases, including AI-assisted data engineering, intelligent data discovery, and agent-based workflows.

• Strong SQL skills for data transformation, reconciliation, validation, and performance tuning.

• Experience building Snowflake-native automation using Snowflake CLI, Snowpark Python, stored procedures, and APIs.

• Strong preference for CLI-based development over only Snowsight-based work

Agent Building/ AI Skills:

• Experience building AI agents or AI workflows inside Snowflake ecosystem.

• Knowledge of LLM-based use cases such as data quality agents, reconciliation agents, chatbot agents, metadata agents, and reporting agents.

• Ability to design agent workflows that interact with Snowflake tables, metadata, SQL execution, validation rules, and business logic.

• Exposure to Cortex Search, Cortex Analyst, Cortex Agents, or similar Snowflake AI capabilities is preferred

Engineering Skills:

• Strong Python programming experience.

• dbt experience for modular transformation development, testing, documentation, and deployment.

• CI/CD experience using GitHub Actions, Azure DevOps, Jenkins, or similar tools.

• Git-based development, branching, code review, environment promotion, and deployment automation.

• Ability to build reusable frameworks, scripts, accelerators, and validation utilities.

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.