Title : - Snowflake Architect

Duration : - Long Term

Job Location:- St. Louis, MO (Day 1 -Onsite, Candidate needs to work 5 Days at the Client Office)

Job Description : -

Level

Skill

Expert

Snowflake Solution Architecture

Proficient

Database/schema design, ELT/ETL pipelines, Integration, Data sharing, Snowflake stages

Proficient

Data Modeling

Proficient

RBAC, Data masking, Network policies, Encryption, SAML

Proficient

Warehouse sizing, Query profiling, Caching, Result reuse

Proficient

Cost Optimization Strategy

Competent

Snowpipe, Snowpark, Streams, DBT, Fivetran

Competent

Governance, Metadata, Naming conventions, Lineage

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, GCP) 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