Data Architect

Job Description

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