Remote Data Architect

Summary

Join The Motley Fool as a Freelance Data Architect specializing in Snowflake to re-architect and optimize our reporting layer. This mid to senior level position requires 4-5+ years of relevant experience.

Requirements

• Proven experience working with Snowflake data warehouse, including optimization projects
• Strong expertise in analytic engineering techniques within Snowflake, such as query optimization, indexing, and partitioning
• Deep understanding of Snowflake's architecture, including virtual warehouses, storage optimization, and clustering keys
• Proficiency in SQL and data modeling for Snowflake
• Familiarity with ETL processes and data pipeline optimization
• Excellent problem-solving skills and the ability to troubleshoot complex performance issues
• Strong communication skills to collaborate with cross-functional teams and stakeholders
• Self-motivated with a proactive approach to identifying and implementing optimizations

Responsibilities

• Evaluate and optimize the reporting layer of our Snowflake data warehouse to enhance cost efficiency and compute utilization
• Develop and implement strategies to improve query performance, reduce data processing time, and enhance overall efficiency
• Collaborate closely with the data engineering team to implement optimizations without compromising data integrity or security
• Utilize advanced analytic engineering techniques within Snowflake to optimize data transformations and computations
• Design efficient data models and schemas to support optimized reporting and analytics
• Implement best practices for data loading, storage, and retrieval to minimize costs and maximize performance
• Optimize query performance by tuning Snowflake configurations and query execution plans
• Implement caching strategies and materialized views to improve response times for commonly used reports