Title: Snowflake Architect
Duration: Contract
Work Location: St. Louis, MO (Day 1 -Onsite, Candidate needs to work 5 Days at the Client Office)
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
Abhishek Kumar
SPAR Information Systems
(an E-verify Company)
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message
To unsubscribe from future emails or to update your email preferences click here
