Senior Solution Architect - Snowflake

Role Overview: As a Senior Solution Architect specializing in Snowflake at CitiusTech, you will be an integral part of an Agile team responsible for designing and developing healthcare applications, as well as implementing new features while ensuring adherence to the highest coding development standards. Key Responsibilities: - Act as a data domain expert for Snowflake within a collaborative environment, showcasing a strong understanding of data management best practices and patterns. - Provide technical expertise to address complex business challenges by translating them into data integration and database systems designs. - Model Snowflake data structures and execute ELT processes using Snowpipe or tools like Matillion or Azure Data Factory (ADF), while also implementing stored procedures and following standard data warehousing (DWH) and ETL concepts. - Design ingestion strategies for both batch and streaming data, determine appropriate warehouse sizing, apply security best practices, and establish disaster recovery solutions. - Implement Snowflake FinOps strategies and optimize performance to enhance system efficiency. - Set up, configure, and fine-tune Snowflake platforms to ensure performance optimization, including workload segmentation. - Utilize Snowflake features such as Snowpark, Data Metric Functions, Masking, and Dynamic Tables to enhance platform capabilities. - Migrate data from on-premises data sources to Snowflake using efficient and effective strategies. - Provide consulting services and develop migration strategies for Snowflake adoption across various internal business units or entities. - Collaborate with stakeholders, including product owners, enterprise architects, and application owners, to clearly articulate Snowflake features, their purposes, and their fit for specific use cases. Qualifications Required: - Experience: 13-14 Years - Location: Mumbai, Pune, Bangalore, Chennai - Educational Qualifications: Engineering Degree - BE / BTech preferred, Technical certifications in multiple technologies are desirable, SnowPro Advanced Architect Certification - Skills: Data warehousing, SQL, Performance Tuning, Security in Snowflake, Availability, Backup Restore, Azure Cloud platform and data services Happy applying!,