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:

• Bachelor's 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.