Qode
Snowflake Architect
Location : Arlington, VA and Boston, MA Job Description: The ideal candidate should have
10+ years of experience
with a strong background in
Snowflake architecture, SQL optimization, data warehousing, cloud data platforms, and enterprise data strategy . Additionally, they should possess leadership experience and the ability to provide technical guidance and architectural oversight.
Key Responsibilities:
Design and architect
enterprise-scale
Snowflake data warehouse solutions , including database schemas, data models, and multi-cluster warehouses Experience of implementing
Data Vault on Snowflake
is highly desirable Develop
Snowflake best practices
for performance optimization, cost management, and resource allocation Implement
advanced Snowflake features
including Time Travel, Zero Copy Cloning, data sharing, and secure data exchanges Design and optimize
complex SQL queries, stored procedures, and functions
specifically for Snowflake's unique architecture Architect
data integration strategies
using Snowflake's native connectors, Snowpipe, and external stages Conduct
Root Cause Analysis (RCA)
for Snowflake performance issues and implement optimization strategies Lead and mentor
data engineering teams on Snowflake development, providing architectural guidance and best practices Design and implement
scalable ELT/ETL pipelines
leveraging Snowflake's cloud-native capabilities Establish
data governance frameworks
including role-based access control (RBAC), data classification, and compliance monitoring Collaborate with stakeholders to translate business requirements into scalable Snowflake data architecture solutions Implement
Snowflake security best practices
including network policies, encryption, and data masking Required Technical Skills:
Expert-level Snowflake knowledge
including SnowSQL, Snowsight, and Snowflake APIs Strong understanding of
Snowflake's unique architecture
(virtual warehouses, storage layers, cloud services) Experience with
Snowflake data loading
techniques (Snowpipe, bulk loading, continuous data ingestion) Proficiency in
advanced SQL
and
stored procedures
optimized for Snowflake Knowledge of
Snowflake's ecosystem
including partner tools and third-party integrations Preferred Qualifications:
Snowflake certifications
(SnowPro Core, Advanced Architect, or Data Engineer) Experience with
dbt (data build tool)
for transformation workflows in Snowflake Familiarity with
Python, JavaScript, or Java
for Snowflake UDFs and stored procedures Experience with
data visualization tools
such as
Power BI, Tableau, or Looker
connected to Snowflake Understanding of
DataOps and CI/CD practices
for Snowflake development Knowledge of
Snowflake's data marketplace
and external data integration
Location : Arlington, VA and Boston, MA Job Description: The ideal candidate should have
10+ years of experience
with a strong background in
Snowflake architecture, SQL optimization, data warehousing, cloud data platforms, and enterprise data strategy . Additionally, they should possess leadership experience and the ability to provide technical guidance and architectural oversight.
Key Responsibilities:
Design and architect
enterprise-scale
Snowflake data warehouse solutions , including database schemas, data models, and multi-cluster warehouses Experience of implementing
Data Vault on Snowflake
is highly desirable Develop
Snowflake best practices
for performance optimization, cost management, and resource allocation Implement
advanced Snowflake features
including Time Travel, Zero Copy Cloning, data sharing, and secure data exchanges Design and optimize
complex SQL queries, stored procedures, and functions
specifically for Snowflake's unique architecture Architect
data integration strategies
using Snowflake's native connectors, Snowpipe, and external stages Conduct
Root Cause Analysis (RCA)
for Snowflake performance issues and implement optimization strategies Lead and mentor
data engineering teams on Snowflake development, providing architectural guidance and best practices Design and implement
scalable ELT/ETL pipelines
leveraging Snowflake's cloud-native capabilities Establish
data governance frameworks
including role-based access control (RBAC), data classification, and compliance monitoring Collaborate with stakeholders to translate business requirements into scalable Snowflake data architecture solutions Implement
Snowflake security best practices
including network policies, encryption, and data masking Required Technical Skills:
Expert-level Snowflake knowledge
including SnowSQL, Snowsight, and Snowflake APIs Strong understanding of
Snowflake's unique architecture
(virtual warehouses, storage layers, cloud services) Experience with
Snowflake data loading
techniques (Snowpipe, bulk loading, continuous data ingestion) Proficiency in
advanced SQL
and
stored procedures
optimized for Snowflake Knowledge of
Snowflake's ecosystem
including partner tools and third-party integrations Preferred Qualifications:
Snowflake certifications
(SnowPro Core, Advanced Architect, or Data Engineer) Experience with
dbt (data build tool)
for transformation workflows in Snowflake Familiarity with
Python, JavaScript, or Java
for Snowflake UDFs and stored procedures Experience with
data visualization tools
such as
Power BI, Tableau, or Looker
connected to Snowflake Understanding of
DataOps and CI/CD practices
for Snowflake development Knowledge of
Snowflake's data marketplace
and external data integration