Freelance Snowflake Data Architect

$166,400 - $187,200/Yr

The Motley Fool - Alexandria, VA

Full-time - Mid Level

Remote - Alexandria, VA

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The Motley Fool is seeking a Freelance Data Architect specializing in Snowflake to join their Data Democratization, Governance & Strategy team. This role is focused on optimizing the reporting layer of the Snowflake data warehouse, enhancing cost efficiency and compute utilization. The position is fully remote and requires a commitment of 40 hours per week for at least 6 months, targeting candidates with 4-5+ years of relevant experience.

Responsibilities

• Evaluate and optimize the reporting layer of the 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.
• Collaborate with data engineers to ensure efficient ETL processes and data transformations.

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.

Benefits

• Flexible working hours
• Remote work opportunity
• Competitive hourly pay of $80 - $90