Snowflake AWS Architect

**Job Title- Snowflake AWS Architect

Experience-10+ years

Location- Pune, Indore, Hyderabad, Bangalore** Job Summary We are looking for an experienced Snowflake Data Architect with 10+ years of experience in designing and implementing enterprise-scale Snowflake Data Warehouse and Lakehouse solutions. The ideal candidate should have strong expertise in data architecture, cloud data platforms, data modernization, ETL, Snowflake, AWS, and DevOps, along with excellent stakeholder management skills.

Key Responsibilities

• 10 + years of Design and implement experience into Snowflake-based data warehouse and Lakehouse solutions.
• Lead the architecture and design of enterprise-wide data modernization programs and cloud data platforms (AWS )
• Define target-state architectures, migration strategies, and modernization roadmaps for legacy data warehouses and ETL ecosystems.
• Define Snowflake data modelling strategies, clustering, partitioning, workload optimization, and cost management practices.
• Design scalable data ingestion, transformation, and consumption patterns for structured and unstructured data.
• Provide technical leadership, solution reviews, and architecture governance.
• Collaborate with business stakeholders, product teams, data engineers, analysts, and enterprise architects.
• Strong knowledge in ETL (Any of the ETL Tools- Ex: Informatica/Datastage/Talend etc. ) & SQL/PL-SQL and Knowledge in Python / Pyspark is preferable
• Good to have experience in the Manufacturing domain, with a strong understanding of industry processes and data workflows
• Enable CI/CD, DevOps, and automation practices for data engineering and analytics workflows.
• Proven experience leveraging AI-assisted tools and modern automation technologies to accelerate architecture design, optimize cloud and data platform performance.
• Excellent communication and stakeholder management

Mandatory Skills

• 10+ years of overall IT/Data experience.
• Strong hands-on experience designing and implementing Snowflake Data Warehouse and Lakehouse solutions.
• Strong expertise in Snowflake Data Architecture and Data Modeling.
• Experience with AWS cloud data platforms and services.
• Strong experience in data modernization and legacy-to-cloud migration.
• Expertise in ETL/ELT technologies such as Informatica, IBM DataStage, Talend, or equivalent.
• Strong SQL/PL-SQL skills.
• Experience with Python and/or PySpark.
• Strong understanding of Snowflake performance optimization, clustering, partitioning, workload management, and cost optimization.
• Experience with CI/CD, DevOps, automation, and version control.
• Strong experience in architecture governance, solution design, and technical leadership.
• Excellent communication and stakeholder management skills.