Motley Fool

Snowflake Data Architect (Contract)

United States

Not SpecifiedCompensation
Junior (1 to 2 years)Experience Level
Full TimeJob Type
UnknownVisa
Financial ServicesIndustries

Position Overview

  • Location Type: Remote (United States)
  • Job Type: Independent Contract (40 hours per week for at least 6 months)
  • Level: Mid to Senior Level
  • Experience: 4-5+ years of relevant experience

The Motley Fool is seeking a highly skilled Freelance Data Architect specializing in Snowflake to join our Data Democratization, Governance & Strategy team. This role focuses on re-architecting and optimizing our reporting layer within Snowflake, with a primary emphasis on improving cost efficiency and compute optimization.

Company Information

The Motley Fool is a purpose-driven financial services company dedicated to making the world smarter, happier, and richer. For 30 years, we've provided transparency, education, and entertainment to help people make better investment decisions. We are a fast-moving, collaborative team that values high-quality work, curiosity, and initiative, driven by the impact our work has on people's financial futures.

Team Overview

The Data Democratization, Governance & Strategy team makes data accessible and actionable for all business end-users. We specialize in the final stages of data delivery, transforming warehouse data into easily consumable formats. We build data structures that support seamless reporting and valuable business insights through collaboration with third-party vendors and stakeholders, ensuring all teams can leverage data for informed decisions and strategic growth.

Responsibilities

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

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.

Compensation

The company has a target compensation range, but is budget conscious.

Skills

Snowflake
Data Warehouse
Analytic Engineering
Data Architecture
Cost Optimization
Compute Optimization
Data Processing
Performance Tuning

Motley Fool

Provides investment advice and financial education

About Motley Fool

The Motley Fool offers financial services focused on helping individual investors make informed decisions about their money. It provides premium subscription services like Stock Advisor and Rule Breakers, which deliver stock recommendations and investment advice to assist clients in building and managing their investment portfolios. The company generates revenue through subscription fees, website advertising, and affiliate partnerships. Unlike many competitors, The Motley Fool emphasizes a long-term investment philosophy and prioritizes financial education, catering to both novice and experienced investors. Its goal is to enhance financial literacy and empower individuals to achieve smarter, happier, and wealthier lives.

Alexandria, VirginiaHeadquarters
1993Year Founded
$54.2MTotal Funding
LATE_VCCompany Stage
Fintech, Financial ServicesIndustries
501-1,000Employees

Risks

Teads acquisition may lead to integration challenges and cultural clashes.
Cannabis facility investment involves regulatory risks and market volatility.
$5 million Bitcoin investment exposes the company to cryptocurrency market volatility.

Differentiation

The Motley Fool offers a unique blend of financial education and investment advice.
It provides premium subscription services like Stock Advisor and Rule Breakers.
The company champions shareholder values and advocates for individual investors.

Upsides

Increased interest in financial literacy boosts demand for The Motley Fool's services.
The rise of retail investors expands the audience for subscription services.
AI integration allows for personalized investment advice and improved user experience.

Land your dream remote job 3x faster with AI