The Motley Fool

Making the world smarter, happier, and richer through free and premium investing guidance.

Contract Data Architect, Snowflake

Data EngineerData EngineerContractRemoteTeam 501-1,000Since 1993H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

4 days ago

Salary

$95 - $110 / hour

5 yrs expEnglishETLSQL

Job Description

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

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

Related Categories

Related Job Pages

More Data Engineer Jobs

Senior Data Engineer

TopDog Law

Personal Injury Law Firm

Data Engineer4 days ago
Full TimeRemoteTeam 51-200Since 2019H1B No Sponsor

Senior Data Engineer designing and maintaining data platforms for a personal injury law firm

AirflowBigQueryCloudPythonSQL
United States
$130K - $160K / year

System Architect, Data Engineer, Data Quality Owner

ProfitCoach

Boost your Financial Performance through Operations Insights!

Data Engineer4 days ago
Full TimeRemoteTeam 11-50Since 2019H1B No Sponsor

Software Architect managing data infrastructure at ProfitCoach

United States
$155K - $175K / year

Senior Data Engineer, AI/ML

Octave

Mental health, built around you.

Data Engineer4 days ago
Full TimeRemoteTeam 201-500H1B Sponsor

Sr. Data Engineer working on AI and ML platform at Octave

AirflowAmazon RedshiftAWSBigQueryCloudGoogle Cloud PlatformPythonPyTorchScikit-LearnSparkSQLTensorflow
United States
$142.6K - $176K / year

Senior Data Engineer — Analytics Platform

Trumid

Delivering a full ecosystem of credit protocols and trading solutions in one easy to-use-platform.

Data Engineer4 days ago
Full TimeRemoteTeam 51-200Since 2014H1B Sponsor

The Senior Data Engineer will design and implement scalable data models in BigQuery using dbt to power analytics, reporting, and operational insights, while also developing systems for delivering data to internal stakeholders and external clients. Key duties include maintaining data governance practices such as documentation, lineage, testing, and data quality standards, and optimizing query performance in BigQuery.

BigQueryDbtFivetranSQL
United States
$200K - $250K / year