Snowflake Developer

Overview

On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

Amazon Kinesis
Amazon Web Services
Analytics
Apache Kafka
Continuous Delivery
Continuous Integration
Core Data
Customer Facing
Data Engineering
Data Modeling
Data Quality
DevOps
Dimensional Modeling
Documentation
Extract
Transform
Load
Good Clinical Practice
Google Cloud Platform
IT Management
Leadership
Machine Learning (ML)
Macros
Management
Mentorship
Meta-data Management
Microsoft Azure
Modeling
Optimization
Orchestration
Presentations
RBAC
Real-time
Regulatory Compliance
Reporting
Requirements Elicitation
Slowly Changing Dimensions
Snow Flake Schema
Solution Architecture
Streaming
Terraform
Version Control
Warehouse
Artificial Intelligence
Automated Testing
Cloud Computing
Clustering
Git

Job Details

Position:- Snowflake Developer

Location:- Dallas, TX

Duration:- 12 Months Contract

10+ and W2 Only

Key Responsibilities

  • Client Collaboration: Engage with business and technical stakeholders to capture requirements and translate them into scalable, secure data platform designs.
  • Solution Architecture: Design and implement modern data platforms leveraging Snowflake as the core data warehouse and DBT for transformation.
  • DBT Standards: Establish best practices, frameworks, macros, and governance for DBT projects, ensuring consistency across teams.
  • Data Modeling: Implement dimensional modeling (Star/Snowflake schemas) and other modeling patterns (SCDs, Data Vault) to enable analytics and reporting.
  • Pipeline Orchestration: Guide ingestion and transformation pipelines, including near real-time approaches such as Snowpipe.
  • DevOps & Automation: Define CI/CD pipelines for DBT and Snowflake deployments, ensuring version control, automated testing, and smooth releases.
  • Data Quality Frameworks: Embed automated testing and validation (e.g., Great Expectations or similar) into the data stack to ensure trusted analytics.
  • Performance & Cost Optimization: Profile and tune Snowflake queries, warehouses, and data pipelines to maximize performance and manage cloud spend.
  • Documentation & Governance: Work with enterprise catalog and metadata tools to ensure data lineage, discoverability, and compliance.
  • Mentorship & Leadership: Provide technical leadership, mentor junior engineers, and evangelize modern data engineering practices with clients.

Required Skills & Experience

  • Proven track record architecting Snowflake-based data platforms at scale.
  • Hands-on DBT expertise modular models, macros, schema & data tests, snapshots, incremental models, CI/CD integration.
  • Deep knowledge of Snowflake features (Snowpipe, Streams/Tasks, RBAC/security, Snowpark, Time Travel, clustering, materialized views).
  • Strong data modeling experience (Star, Snowflake schemas, SCDs, Data Vault 2.0).
  • Cloud-native data platform experience (AWS, Azure, or Google Cloud Platform).
  • DevOps skills (Git, CI/CD pipelines, Terraform, or similar).
  • Background in data quality, governance, and catalog integration (Purview, Collibra, Alation, etc.).
  • Ability to be hands-on while also client-facing comfortable gathering requirements, presenting solutions, and leading discussions.

Nice-to-Have Skills

  • Experience with enterprise data catalogs (Purview, Alation, Collibra).
  • Knowledge of real-time streaming tools (Kafka, Kinesis, Event Hub).
  • Familiarity with additional orchestration/ETL tools (Airflow, Matillion, Fivetran, StreamSets).
  • Exposure to AI/ML integration with Snowflake (Snowpark ML, Cortex).
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.