Snowflake Data Architect

Overview:

The Technical Architect is a key position that reports to the Principal Architect in the Enterprise/COTS department at Prodapt. The role is responsible for designing business processes as per customer needs, strategizing cloud architecture and migration, and upholding Prodapt's winning values and contributing to the company's vision.

Roles & Responsibilities:

• Business Process Design: Designing one or more business processes as per customer needs
• Requirement Management: Creating High-level and Low-level design documents in collaboration with senior architects for COTS solution
• Product Analysis: Performing functionality analysis, designing solutions around customizations, and identifying interfaces and integration considerations
• Proposal Building: Driving and leading proposal pitches regarding the functional implementation of COTS products
  • Cloud data platform - design, architect and enable build of data platform on products like snowflake

Requirements:

• Collaborate with clients and stakeholders to gather and understand technical and business requirements.
• Assess various technologies and tools to recommend the most suitable solutions for different projects.
• Assess Data warehouse implementation procedures to ensure they comply with internal and external regulations.
• Prepare accurate Data warehouse design and architecture reports for management.
• Oversee the migration of data from legacy systems to new solutions.
• Monitor the system performance by performing regular tests, troubleshooting and integrating new features.
• Recommend solutions to improve new and existing Data warehouse solutions.
• Ensure solutions are scalable and adaptable for future modifications, considering the organization's goals.
• Understand and document data flows in and between different systems/applications
• Act as Data domain expert for Snowflake in a collaborative environment to provide demonstrated understanding of data management best practices and patterns.
• Implement cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake environment to build data movement strategy.
• Collaborate with project managers and developers to guide development processes in line with solution requirements.
• Lead in Developing Project requirements for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.
• Make necessary on-going updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment. 
• Guidance to developers in preparing functional/technical specs to define reporting requirement and ETL process. 
• Educate staff members through training and individual support.
• Offer support by responding to system problems in a timely manner.

Experience

• Proven experience as a Data Architect, Data Engineer with expertise in designing and implementing data solutions on Snowflake.
• In-depth knowledge of Snowflake's architecture, features (ELT using Snowpipe, implementing stored procedures and setting up resource monitors, RBAC controls, virtual warehouse, query performance tuning, Zero copy clone, time travel), functionalities and understand how to use these features.   
• Understanding of data security, encryption, access controls ( RBAC, authentication & authorization), and compliance standards (GDPR, HIPAA, etc.).
• Proficiency in SQL, scripting languages (e.g., Python, Bash) and experience optimizing queries for performance.
  Strong understanding of data modeling principles, data warehousing concepts, ETL/ELT processes , and building data pipelines.
• Experience in implementation, execution, and maintenance of Data Integration solutions
• Experience with cloud technologies (AWS, Azure, or GCP) and integration tools.
• Experience in Data Migration from various sources to Snowflake cloud data warehouse
• Experience working with code repositories,  continuous integration & continuous deployment.
• Excellent problem-solving skills and the ability to communicate complex technical concepts to non-technical stakeholders.
• Relevant certifications or qualifications in Snowflake or related fields are a plus.