Back to Jobs

Snowflake Data Architect

The Motley Fool
🇺🇸 United States – Remote
Internship
$102K–$118K
Estimated
Remote
Apply Now

Required Skills

⏰ Full Time
🟠 Senior
🔴 Lead
🚰 Data Engineer
Airflow
ETL
Python
SQL
🦅 H1B Visa Sponsor
AWS
Cloud
Google Cloud Platform
🟡 Mid-level
JavaScript
Node.js
Apache
Chef
Distributed Systems
Grafana
Kafka
Kubernetes
Postgres
Prometheus
Spark
TypeScript
Azure
BigQuery
MongoDB
NoSQL
R
Go
Scala
Sql
Snowflake
Git
Analytics
Cross-functional Collaboration

Job Description

<h3>📋 Description</h3> •Lead Snowflake platform architecture across U.S. and International instances, ensuring alignment to medallion-layer principles and scalable data modeling. •Define best practices for data structures and modeling, object naming, and compute utilization. •Partner with the Data Engineering team to guide schema design, improve performance, and promote consistency. •Drive cost optimization efforts through query and data structure performance optimization. •Represent the Snowflake platform in strategic projects, like migration projects and enterprise analytics initiatives. •Collaborate with a dedicated Platform Engineer to implement and maintain Git-based version control, metadata documentation, and object lifecycle standards. •Mentor engineers and analysts on Snowflake best practices and performance tuning. •Participate in governance efforts, architecture reviews, and cross-functional collaboration. <h3>🎯 Requirements</h3> •7+ years in data engineering or architecture roles, including 3+ years of hands-on Snowflake experience. •Expertise in data modeling, SQL performance tuning, and Snowflake architectural principles. •Strong proficiency in SQL and working knowledge of Python. •Experience with compute monitoring, cost control, and resource optimization in Snowflake. •Familiarity with GitOps or CI/CD workflows in a data platform setting. •A collaborative mindset and the ability to communicate effectively across both technical and business audiences. •Familiarity with ETL processes and tools, like Airflow, and data pipeline optimization. •Self-motivated with a proactive approach to identifying and implementing optimizations.

Job Details

Employment Type

Internship

Salary Range

$102K–$118K

Estimated

Location

🇺🇸 United States – Remote

Remote Work

Remote Friendly