Snowflake Architect

Overview

On Site
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 month(s)

Skills

Snowflake

Job Details

Key Responsibilities:

  • Solution Design:

Designing the overall data architecture within Snowflake, including database/schema structures, data flow patterns (ELT/ETL strategies involving Snowflake), and integration points with other systems (source systems, BI tools, data science platforms).

  • Data Modeling:

Designing efficient and scalable physical data models within Snowflake.

Defining table structures, distribution/clustering keys, data types, and constraints to optimize storage and query performance. Security Architecture: Designing the overall security framework, including the RBAC strategy, data masking policies, encryption standards, and how Snowflake security integrates with broader enterprise security policies.

  • Performance and Scalability Strategy:

Designing solutions with performance and scalability in mind.

Defining warehouse sizing strategies, query optimization patterns, and best practices for development teams. Ensuring the architecture can handle future growth in data volume and user concurrency.

  • Cost Optimization Strategy:

Designing architectures that are inherently cost-effective.

Making strategic choices about data storage, warehouse usage patterns, and feature utilization (e.g., when to use materialized views, streams, tasks).

  • Technology Evaluation and Selection:

Evaluating and recommending specific Snowflake features (e.g., Snowpark, Streams, Tasks, External Functions, Snowpipe) and third-party tools (ETL/ELT, BI, governance) that best fit the requirements.

  • Standards and Governance:

Defining best practices, naming conventions, development guidelines, and governance policies for using Snowflake effectively and consistently across the organization.

  • Roadmap and Strategy:

Aligning the Snowflake data architecture with overall business intelligence and data strategy goals.

Planning for future enhancements and platform evolution.

  • Technical Leadership:

Providing guidance and mentorship to developers, data engineers, and administrators working with Snowflake.

Key Skills:

  • Deep understanding of Snowflake's advanced features and architecture.
  • Strong data warehousing concepts and data modeling expertise.
  • Solution architecture and system design skills.
  • Experience with cloud platforms (AWS, Azure, Google Cloud Platform) and how Snowflake integrates.
  • Expertise in performance tuning principles and techniques at an architectural level.
  • Strong understanding of data security principles and implementation patterns.
  • Knowledge of various data integration patterns (ETL, ELT, Streaming).
  • Excellent communication and presentation skills to articulate designs to technical and non-technical audiences.
  • Strategic thinking and planning abilities
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.