Snowflake Architect

Smart IT Frame LLC; United States; On-site; USD 140,000 - 210,000; Full time

Job summary

Smart IT Frame LLC seeks an experienced Snowflake Architect to design and lead scalable enterprise data platforms. The role emphasizes data architecture, Snowflake administration, Data Vault, and dimensional modeling to drive robust EDW solutions.

Applicants should demonstrate expertise in Spark SQL and advanced SQL, Snowflake RBAC, performance tuning, and AWS services (S3, Lambda, Step Functions, CodeBuild). Prior experience with large-scale data modernization is a plus.

Qualifications

• Experience with Snowflake architecture and administration.
• Proficiency in Data Vault and dimensional modeling.
• Strong SQL skills including Spark SQL.
• Hands-on with Snowflake RBAC, performance tuning and optimization.
• Experience designing an enterprise data warehouse (EDW) architecture.
• Familiarity with AWS services (S3, Lambda, Step Functions, CodeBuild).

Skills

Snowflake & Snowflake Administration

Data Vault & Dimensional Data Modeling

Spark SQL & Advanced SQL

Snowflake RBAC, performance tuning & 0

EDW architecture

AWS S3, Lambda, Step Functions & CodeB

Tools

Talend ETL

Terraform

Snowpark / dbt

ML/AI integration & MLOps

Large-scale data modernization

Job description

We’re looking for an experienced Snowflake Architect with strong expertise in Data Architecture, Snowflake Administration, Data Vault, and Dimensional Data Modeling to design and lead scalable enterprise data platforms.

Mandatory Skills

• Snowflake & Snowflake Administration
• Data Vault & Dimensional Data Modeling
• Spark SQL & Advanced SQL
• Snowflake RBAC, performance tuning & optimization
• Enterprise Data Warehouse (EDW) architecture
• AWS S3, Lambda, Step Functions & CodeBuild

Good to Have

• Talend ETL
• Terraform
• Snowpark / dbt
• ML/AI integration & MLOps
• Experience with large-scale data modernization