Snowflake Data Architect

Job Description

Experience: 9 12 Years Location: Bangalore / Hyderabad Notice Period: Immediate to 15 Days Overview We are looking for a highly experienced and strategic Snowflake Data Architect to lead the transformation and modernization of our data architecture. You will be responsible for designing scalable, high-performance data solutions and ensuring seamless data quality and integration across the organization. This role requires close collaboration with data modelers, business stakeholders, governance teams, and engineers to develop robust and efficient data architectures. This is an excellent opportunity to join a dynamic, innovation-driven environment with significant room for professional growth. We encourage initiative, creative problem-solving, and a proactive approach to optimizing our data ecosystem. Responsibilities Architect, design, and implement scalable data solutions using Snowflake . Build and maintain efficient data pipelines using SQL and ETL tools to integrate data from multiple ERP and other source systems. Leverage data mappings, modeling (2NF/3NF) , and best practices to ensure consistent and accurate data structures. Collaborate with stakeholders to gather requirements and design data models that support business needs. Optimize and debug complex SQL queries and ensure performance tuning of pipelines. Create secure, reusable, and maintainable components for data ingestion and transformation workflows. Implement and maintain data quality frameworks , ensuring adherence to governance standards. Lead User Acceptance Testing (UAT) support, production deployment activities, and manage change requests. Produce comprehensive technical documentation for future reference and auditing purposes. Provide technical leadership in the use of cloud platforms (Snowflake, AWS) and support teams through knowledge transfer. Requirements Bachelor’s degree in Computer Science, Information Technology, or a related field. 9 to 12 years of overall experience in data engineering and architecture roles. Strong, hands-on expertise in Snowflake with a solid understanding of its advanced features. Proficient in advanced SQL with extensive experience in data transformation and pipeline optimization . Deep understanding of data modeling techniques , especially 2NF/3NF normalization . Experience with cloud-native platforms , especially AWS (S3, Glue, Lambda, Step Functions) is highly desirable. Knowledge of ETL tools (Informatica, Talend, etc.) and working in agile environments . Familiarity with structured deployment workflows (e.g., Carrier CAB process). Strong debugging, troubleshooting , and analytical skills . Excellent communication and stakeholder management skills. Key Skills Snowflake (Advanced) SQL (Expert) Data Modeling (2NF/3NF) ETL Tools AWS (S3, Glue, Lambda, Step Functions) Agile Development Data Quality & Governance Performance Optimization Technical Documentation Stakeholder Collaboration