Can work from either Hyderabad, Chennai, Bengaluru and Nagpur

We are looking for an experienced Snowflake DBT Architect with

- strong expertise in Snowflake Data Cloud, DBT, Snowflake Cortex AI, and AWS cloud services.
- The ideal candidate should have extensive experience in designing scalable data architectures, developing modern data pipelines, implementing data transformation frameworks, and leveraging AI capabilities within the Snowflake ecosystem.
- The candidate should be capable of driving end-to-end data architecture, optimization, governance, and AI-driven data solutions.

- Key Responsibilities

- Design and implement scalable, high-performance data warehouse architectures using Snowflake.
- Lead the development and implementation of DBT-based data transformation frameworks.
- Architect and optimize ELT/ETL pipelines for enterprise data platforms.
- Leverage Snowflake Cortex AI capabilities for AI-powered data applications, including LLM-based solutions, text processing, and semantic search.
- Integrate Snowflake with AWS services such as S3, Glue, Lambda, IAM and other relevant services.
- Design and implement data ingestion, transformation, and orchestration workflows.
- Establish best practices for data modeling, data quality, metadata management, and data governance.
- Optimize Snowflake performance, query execution, warehouse utilization, and cost management.




- Implement CI/CD pipelines and automated deployment processes for DBT and Snowflake.
- Collaborate with business stakeholders, data engineers, and enterprise architects to deliver data solutions.
- Provide technical leadership, architecture guidance, and mentorship to engineering teams.

Mandatory Technical Skill

- Snowflake
- Robust expertise in Snowflake architecture and data warehousing.
- Snowflake SQL, Streams, Tasks, Snowpipe, Dynamic Tables.
- Performance tuning and query optimization.
- Data sharing, security, and governance.
- DBT (Data Build Tool)
- Strong experience in DBT Core / DBT Cloud.
- DBT models, macros, snapshots, tests, and incremental models.
- Data transformation and dimensional modeling.
- DBT deployment, CI/CD, and workflow orchestration.
- Snowflake Cortex AI
- Hands-on experience with Snowflake Cortex AI capabilities.
- Cortex LLM functions and AI-powered data processing.
- Cortex Search and Cortex Analyst.
- Experience building AI/LLM-based applications using enterprise data.
- Knowledge of RAG and semantic search is an added advantage.
- AWS Cloud
- Hands-on experience with AWS S3, Glue, Lambda, IAM, and related services.
- Experience integrating AWS data services with Snowflake.
- Cloud-based data pipeline architecture and implementation.

📌 Snowflake DBT Architect (Snowflake, Cortex AI, AWS) (Chennai)
🏢 System Soft Technologies
📍 Chennai