Snowflake Architect

Role :Data Architect, Snowflake Architect

Location: Gurgaon

Experience: 7+ Years (Relevant)

CTC: Up to 35 LPA

Working Days: 5 Days a Week

Job Summary

A Seasoned Data Architect with 7+ years of experience in Data Warehousing, Business Intelligence, and Enterprise Data Architecture . The ideal candidate will possess deep hands-on expertise in Snowflake , Azure Synapse Analytics , and Microsoft Fabric , with a strong ability to design, build, and optimize modern cloud-based data platforms. This role requires a strategic thinker who can architect scalable, governed, and high-performing data ecosystems for enterprise analytics.

Key Responsibilities

• Architect and implement end-to-end cloud data platforms using Snowflake, Azure Synapse Analytics, and Microsoft Fabric .
• Design and deploy Snowflake data architectures (multi-cluster, multi-zone, cost-optimized) ensuring scalability, reliability, and governance.
• Build robust ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, dbt, Snowflake Tasks, and Streams.
• Develop data lakehouse and warehouse models leveraging Snowflake and Fabric Lakehouse frameworks.
• Implement secure Snowflake features such as RBAC , data masking , encryption, secure data sharing , and cross-region replication.
• Lead migration of legacy data warehouses to Snowflake and Azure Synapse , modernizing enterprise analytics architectures.
• Conduct performance tuning , cost optimization, resource monitoring, and storage governance across Snowflake workloads.
• Collaborate with cross-functional teams to deliver high-quality, reusable, and governed enterprise data assets.
• Ensure compliance with data privacy and governance policies using Azure Purview and Fabric governance tools.

Technical Skills Required

Snowflake Expertise

• Architecture design, multi-cluster setup, performance tuning
• Clustering, data sharing, streams, tasks, zero-copy cloning
• RBAC, data masking, encryption, cost governance
• Cross-region replication and multi-cloud integration

Azure & Fabric Skills

• Azure Synapse Analytics (Dedicated & Serverless SQL Pools)
• Microsoft Fabric: Data Factory, Lakehouse, OneLake, KQL, Power BI integration
• ETL/ELT Tools: Azure Data Factory, Synapse Pipelines, dbt
• Languages: SQL, T-SQL, Python
• Data Modeling: Star/Snowflake schema, Dimensional, Lakehouse modeling
• DevOps: Azure DevOps, CI/CD for data pipelines
• Governance: Azure Purview, Power BI, Log Analytics

Certifications (Preferred)

• Microsoft Certified: Azure Data Engineer Associate
• Microsoft Certified: Azure Solutions Architect Expert
• DP-500: Enterprise-Scale Analytics Solutions
• Snowflake SnowPro Core / Advanced Architect
• Microsoft Fabric Specialization or Training
• (Optional) Power BI Data Analyst Associate

Soft Skills

• Strong analytical and problem-solving skills
• Excellent communication and stakeholder management
• Strategic mindset with focus on scalability and governance
• Detail-oriented, proactive, and quality-driven
• Passionate about modern cloud data technologies and innovation