Snowflake Data Architect

Summary

Join The Motley Fool's Data Democratization, Governance & Strategy team as a Snowflake Data Architect! Lead the strategic development of our enterprise data platform, guiding the evolution of our Snowflake environment. Set architectural standards, optimize cost and performance, and partner across teams to enable scalable analytics. Collaborate with a Platform Engineer and Data Governance Specialist to ensure a secure, well-governed, and cost-efficient Snowflake footprint. This role requires 7+ years in data engineering or architecture, including 3+ years of hands-on Snowflake experience. The annual pay range is $150,000-$190,000 USD.

Requirements

• 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

Responsibilities

• 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

Benefits

$150,000 — $190,000 USD