snowflake Architect

Key Responsibilities:

• Lead the design and implementation of robust, scalable, and cost-effective Snowflake data warehouse solutions.  
• Define and document technical architecture, standards, and best practices for data modeling, ETL/ELT, and data consumption.  
• Evaluate and recommend appropriate Snowflake features (Virtual Warehouses, Time Travel, Zero-Copy Cloning, Caching) to meet business requirements.  
• Oversee development of data pipelines using tools like Snowpipe, Snowflake Streams, and external ETL/ELT tools (dbt, Fivetran, Informatica).  
• Develop and optimize SQL and stored procedures (using Snowflake Scripting or compatible languages) for data transformation.  
• Implement data governance, access controls, and security policies within Snowflake.  
• Monitor and manage Snowflake credit usage and overall performance.  
• Perform query tuning and optimize Virtual Warehouse configurations for low latency and cost efficiency.  
• Implement effective data partitioning and clustering strategies.  
• Collaborate with Data Scientists, Business Analysts, and Application Teams to understand data requirements and deliver solutions.  
• Provide technical guidance and mentorship to junior developers and data engineers.  
• Stay updated on new Snowflake features and cloud data platform trends, recommending their adoption where beneficial.  

Qualifications & Skills:

• Bachelors or Master’s degree in Computer Science or Engineering.  
• 8+ years of experience in Data Warehousing and Data Architecture.  
• 3+ years of hands-on, in-depth experience as a Snowflake Architect or Senior Data Engineer focused on Snowflake.  
• Proven experience with cloud platforms such as AWS, Azure, or GCP.  
• Strong expertise in SQL and data modeling (Dimensional, 3NF, Data Vault).  
• Deep understanding of Snowflake architecture and its unique features.  
• Hands-on experience with ETL/ELT tools and techniques for migrating data to Snowflake.  
• Experience with scripting languages like Python for data processing and automation.  
• Knowledge of version control (e.g., Git) and CI/CD processes.  

Preferred:

• Snowflake Certification (e.g., Snowflake SnowPro Advanced Architect).  
• Experience with Data Lake technologies (e.g., S3, ADLS) and integration with Snowflake.  
• Familiarity with BI tools (e.g., Tableau, Power BI) and their integration with Snowflake.  
• Experience with Infrastructure as Code (IaC) tools like Terraform.