Snowflake Data Architect (Contract)

The Motley Fool; United States; Remote; USD 60,000 - 80,000; Full time

Job summary

The Motley Fool est à la recherche d'un Freelance Data Architect pour optimiser sa couche de reporting Snowflake. Ce rôle flexible et entièrement à distance requiert une expérience avérée en ingénierie analytique et une compétence approfondie en Snowflake. Idéal pour ceux qui souhaitent améliorer l'efficacité des coûts et des performances des données.

Qualifications

• 4-5+ ans d'expérience avec Snowflake.
• Expertise en ingénierie analytique et optimisation des requêtes.
• Compétences en modélisation de données et en résolution de problèmes.

Responsibilities

• Optimiser la couche de reporting de Snowflake.
• Collaborer avec l'équipe d'ingénierie des données pour mettre en œuvre des optimisations.
• Utiliser des techniques avancées d'ingénierie analytique pour optimiser les transformations de données.

Skills

Analytic Engineering

SQL

Problem-Solving

Communication

Data Modeling

Job description

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 for at least 6 months. This is a mid to senior level position and requires 4-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’ve been helping people make better investment decisions through transparency, education, and Foolish fun. We’re a fast-moving, collaborative team that values high-quality work, curiosity, and initiative. We care deeply about what we do, and we’re 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.
  
  

Compensation: Below is our target compensation range. While we are budget conscious, we’re also eager to find the right person for this role, so if your target is outside of this range, please don’t hesitate to apply and we’d be happy to have a conversation.

Hourly Pay Range: $85 USD - $100 USD

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.

Seniority level

• Seniority level

  Not Applicable

Employment type

• Employment type

  Contract

Job function

• Industries

  Technology, Information and Internet

Referrals increase your chances of interviewing at The Motley Fool by 2x

Get notified about new Data Architect jobs in United States.

Salt Lake City, UT $150,000.00-$190,000.00 1 week ago

United States $150,000.00-$180,000.00 2 weeks ago

United States $140,000.00-$157,500.00 1 week ago

Scientific Data Architect/Senior Scientific Data Architect - Boston

United States $160,000.00-$190,000.00 21 hours ago

United States $130,000.00-$165,000.00 1 month ago

United States $72,000.00-$148,500.00 6 days ago

Portland, Oregon Metropolitan Area $155,000.00-$200,000.00 4 weeks ago

United States $175,000.00-$200,000.00 1 week ago

United States $95,200.00-$158,800.00 2 weeks ago

New York, United States $128,000.00-$178,500.00 10 hours ago

Rhode Island, United States $128,000.00-$178,500.00 10 hours ago

Atlanta, GA $180,000.00-$200,000.00 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.