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
• Solid 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)
• Solid 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 (Chennai)
🏢 System Soft Technologies
📍 Chennai