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 ...