Apply Now

Snowflake Data Warehouse Consultant

Remote • Posted 3 hours ago • Updated 3 hours ago

Contract W2

Remote

Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

Data Engineering
Data Warehouse
Database
Microsoft Azure
Cloud Storage
Financial Software
Data Modeling
Slowly Changing Dimensions
Analytics
Time Series
ELT
Streaming
Change Data Capture
Pricing
Reference Data
Analytical Skill
Use Cases
Performance Tuning
Clustering
Warehouse
Caching
Management
Data Quality
Finance
Snow Flake Schema
SQL
GitLab
Continuous Integration
Continuous Delivery
Version Control

Summary

Title: Snowflake Data Warehouse Engineer (Contract)

Location: Remote- Work MUST be done in US

Duration: 6+ months with extensions

We're partnering with a confidential, investment-focused organization to add a Snowflake Data Warehouse Engineer. If you have strong Snowflake, SQL, dbt, and performance optimization experience - especially in complex analytical or financial data environments - this is a strong opportunity to work on high-impact data warehouse initiatives.

Qualifications- Required

7+ years of experience in data engineering or data warehousing roles.
5+ years of hands-on Snowflake experience in production environments.
Experience creating and managing Snowflake databases, schemas, roles, and grants.
Experience designing and implementing Streams and Tasks for CDC and scheduled processing.
Experience building and optimizing materialized views and performance-driven data models.
Expert-level SQL skills, including complex window functions, CTEs, analytic queries, set-based transformations, and performance tuning.
4+ years of experience with ELT or transformation tools, ideally dbt.
Experience integrating Snowflake with Azure cloud storage and upstream financial systems.
Experience implementing GitLab CI/CD for SQL-based transformations and Snowflake object deployments.
Strong analytical data modeling experience, including star schemas, slowly changing dimensions, fact tables, aggregates, and large-scale time-series structures.
Experience supporting high-volume, performance-sensitive financial or portfolio datasets.

Responsibilities

Design and implement Snowflake schemas and object lifecycle strategies optimized for analytics workloads.
Build scalable dimensional and time-series data models supporting portfolio hierarchies, positions, security master integration, exposures, and risk metrics.
Develop robust ELT pipelines using dbt and native Snowflake capabilities, including Streams, Tasks, and Snowpipe, for daily and intraday processing.
Implement efficient change data capture and incremental processing strategies across position, pricing, risk, and reference data domains.
Create and maintain high-performance tables, views, and materialized views aligned to performance-sensitive analytical use cases.
Lead query performance optimization efforts, including clustering strategy, micro-partition awareness, warehouse sizing, caching behavior, and workload management.
Establish data quality and reconciliation frameworks, including completeness checks, monitoring, and alerting for financial datasets.
Automate Snowflake deployments and SQL transformations using GitLab CI/CD and version control best practices.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: aewi001
Position Id: Job-012239
Posted 3 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Snowflake Engineer

Remote

•

Today

About Us: CodeForce 360 is a trusted global IT talent partner helping Fortune 500 companies, system integrators, and enterprise organizations build high-performing technology teams. With over 16 years of industry expertise, we combine speed, precision, and market intelligence to deliver exceptional talent across today's most in-demand technologies. About the Job- We are looking for an experienced Snowflake Engineer to join one of our enterprise client engagements. The ideal candidate sho

Easy Apply

Third Party, Contract

$75 - $80

Snowflake Developer/Data Engineer

Remote

•

3d ago

JOB DESCRIPTION | Snowflake Developer This is a very urgent requirement!! Location:New Haven, CT (Preferred) or Remote/Hybrid (Occasionaltravel, once a month) Job Title: Snowflake Engineer Duration:6-12 months (Contract to Hire) The Insurance client is looking for a Data Engineer who can provide production support to our existing and future ETL environments. The candidate must possess strong technical expertise in Snowflake, data warehousing methodologies like Data Vault 2.0. Core Responsibiliti

Easy Apply

Full-time

Depends on Experience

Snowflake Data Engineer With Cortex Exp need 15 years

Remote

•

6d ago

Skills: -Snowflake Cortex, DBT , SQL Experience in evaluating / troubleshooting and measuring agent performance, identifying issues, and optimizing it Experience with dbt, semantic view design, or governed self-service analytics patterns. Python experience for automation, metadata processing, data validation, or AI-assisted engineering workflows. Exposure to agentic AI, natural language analytics, or Snowflake Cortex Analyst / Cortex Search use cases. Responsibilities: - Healthcare or payer do

Easy Apply

Third Party, Contract

60 - 65

Solution Engineer - Data Engineering Specialist (FSI)

Remote

•

6d ago

At Snowflake, we are powering the era of the agentic enterprise. To usher in this new era, we seek AI-native thinkers across every function who are energized by the opportunity to reinvent how they work. You don't just use tools; you possess an innate curiosity, treating AI as a high-trust collaborator that is core to how you solve problems and accelerate your impact. We look for low-ego individuals who thrive in dynamic and fast-moving environments and move with an experimental mindset - who ra

Full-time

USD 189,000.00 - 248,062.00 per year

Search all similar jobs

Remote jobs at AE Business Solutions