Schedule a call →

<p>Interview fractional leaders this week for <strong>free</strong>!</p>

The Motley Fool is a multimedia financial services company providing websites, books, newspaper columns, TV appearances, and newsletters.

The Motley Fool Icon

The Motley Fool Symbol

The Motley Fool is a leading brand that provides insightful analysis and guidance on stocks, helping investors stay informed and make sound investment decisions. Established in 1993 by brothers Tom and David Gardner, The Motley Fool is dedicated to making the world smarter, happier, and richer. With a wide range of products and services, The Motley Fool caters to investors of all backgrounds and experience levels. They offer premium membership services that provide stock recommendations, in-depth company analysis, model portfolios, and live streaming video during market hours. In addition, their website, fool.com, offers free market news and commentary, with hundreds of new articles published each week. The Motley Fool's philosophy centers around treating every dollar as an investment in the future and believes in the power of long-term investing in great businesses. They strive to fulfill their purpose by following the Golden Rule and providing accessible financial guidance to their community. Whether you're a novice or experienced investor, The Motley Fool is your go-to brand for expert investment guidance and valuable resources to help you achieve your financial goals.

The Motley Fool

Finance

Investing

Business and Consumer Services

Computers Electronics and Technology

Roboto

youtube

twitter

linkedin

facebook

The Motley Fool Logo

Jobs at The Motley Fool

Senior Business Intelligence Analyst

Senior Data Analyst

The Motley Fool’s name comes from William Shakespeare’s play “As You Like It”. The court jester, known as the Fool, could speak the truth to the king and queen without having his head lopped off. The Fools of yore entertained the court with humor that instructed as it amused. More importantly, the Fool was never afraid to question conventional wisdom. In the same way, we aim to speak the truth about money and investing...and to make financial guidance accessible to people of all backgrounds and experience levels.

At The Motley Fool, our purpose is to make the world smarter, happier, and richer. We help millions of people around the world achieve their financial goals every day. We believe in treating every dollar as an investment in the future you want to create. We believe that investing in great businesses, for the long term, is the most effective path to wealth. 

The Motley Fool provides free and premium investment guidance to millions of individual investors around the world on Fool.com through:
- Premium membership services that provide stock recommendations, detailed analysis of companies, model portfolios, live streaming video during market hours, and more.
- Free market news and commentary with hundreds of new articles published each week.
- Member-only tools and programming for building your ideal portfolio, tracking your performance, and monitoring companies of interest.

The Motley Fool has been providing investing insights and financial advice to millions of people for over 25 years. Learn how we make the world Smarter, Happier & Richer.

The Motley Fool is looking for a highly skilled Freelance Data Architect specializing in Snowflake to join our team on an independent contract basis, 40 hours per week. This is a mid to senior level position and requires 5+ years of relevant experience.

*While this role is flexible and 100% remote, candidates must be located in the United States for consideration.*

  

**Who are we?**

The Motley Fool is a purpose-driven financial services company on a mission to make the world smarter, happier, and richer. For 30 years we have been helping people make better investment decisions through transparency, education, and Foolish fun. We are a fast-moving, collaborative team that values high-quality work, curiosity, and initiative. We care deeply about what we do, and we are driven by the impact our work has on real people's financial futures.

  

**What does this team do?**

The Data Democratization, Governance & Strategy team at The Motley Fool is dedicated to making data accessible and actionable for all business end-users. We specialize in the final stretch of data delivery, transforming warehouse data into easily consumable formats. By working collaboratively with third-party vendors and stakeholders, we build data structures that support seamless reporting and valuable business insights. Our close partnerships with business analysts and data engineering ensures that every team at The Motley Fool can leverage data to drive informed decisions and strategic growth.

  

**What would you do in this role?**

We are seeking a skilled contractor with expertise in Snowflake's data warehouse platform to re-architect and optimize our reporting layer. The primary focus of this role will be on improving cost efficiency and compute optimization within Snowflake. The ideal candidate will have strong analytic engineering skills and a deep understanding of Snowflake's architecture to streamline data processing, enhance performance, and reduce costs associated with our data reporting.

  

**But what would you actually do in this role?**

Snowflake Optimization:

- 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.
  

Analytic Engineering:

- 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.
  

Compute Efficiency:

- 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.

  

**Required Skills and 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.

*By applying on this site, you acknowledge that The Motley Fool will be collecting the personal data you provide for our recruiting purposes. Please see our* *Applicant Privacy Notice* *for additional information about how we process, transfer, and store your data, including where that data is stored, and about any additional privacy rights you may have based on your jurisdiction.*

Contract Data Architect (Snowflake)

Washington

Business Intelligence Analyst (Contract) role at The Motley Fool, remote in the United States.

The Motley Fool

About The Motley Fool

Jobs

Past roles

About this page