Job Overview: We are seeking an experienced Snowflake Tech Lead/Architect to join our team. The ideal candidate will have a solid background in data architecture, cloud data warehousing, and analytics. As a Snowflake Tech Lead, you will be responsible for leading the design, development, and implementation of data solutions using Snowflake. You will collaborate closely with cross-functional teams to ensure data solutions are accurate, accessible, and secure. Key Responsibilities: + Lead the design and implementation of Snowflake solutions to meet business requirements. + Collaborate with business stakeholders, data engineers, and analysts to gather requirements, ensuring data quality and integrity. + Lead the development and maintenance of data models and pipelines using Snowflake. + Manage diverse data sets (XML, JSON, CSV) from disparate sources. + Optimize Snowflake performance, including query tuning and storage optimization. + Manage and mentor a team of data professionals in Snowflake best practices. + Develop and maintain ETL processes to integrate data from various sources. + Monitor and troubleshoot data issues and implement solutions. + Research and develop POCs to demonstrate business capabilities using Snowflake. + Working with global team (onsite & offshore model) and guiding both shores to successfully drive the project/program. + Stay updated with industry trends and advancements in Snowflake and related technologies. Qualifications: + 15+ years of experience in data engineering, data warehousing, or related roles. + Strong expertise in Snowflake architecture, SQL, and data modeling. + Experience with ETL tools (Informatica) and data integration methodologies. + Solid understanding of data warehousing concepts, metadata management, data lakes, and multi-dimensional models. + Familiarity with AWS cloud platforms and data pipeline orchestration tools (e.g., Apache Airflow). + Excellent problem-solving skills and attention to detail. + Strong communication and leadership skills, with the ability to work collaboratively across teams. Preferred Qualifications: + Snowflake (SnowPro Core or higher) & AWS Cloud certification (CCP or higher) + Experience with data visualization tools (e.g., Qlik, SAS) is an advantage. + Knowledge of programming languages such as Python, Java, or Scala. + Having experience in insurance domain is an advantage. + Experience in Agile/Scrum methodologies.