The Motley Fool is looking for a freelance Data Architect specializing in Snowflake to join our team on a 40-hour per week independent contract basis. Your primary mission will be to re-architect and optimize the reporting layer of our Snowflake data warehouse to improve cost efficiency and compute performance. You will work within our purpose-driven financial services company, where your work directly impacts our mission to make the world smarter, happier, and richer.
What You'll Do
- 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.
- Collaborate with data engineers to ensure efficient ETL processes and data transformations.
What We're Looking For
- 5+ years of relevant experience.
- 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.
- Must be located in the United States.
Technical Stack
- Snowflake
- SQL
Team & Environment
You will be part of the Data Democratization, Governance & Strategy team. We are a fast-moving, collaborative group that values high-quality work, curiosity, and initiative.
Work Mode
This is a freelance contract position requiring 40 hours per week. The role is local-country, open to candidates residing in the United States.
The Motley Fool is an equal opportunity employer.
