Overview
Hybrid
$70 - $80
Contract - Independent
Skills
snowflake
SQL
snowconvert
ETL
Datawarehouse
Job Details
Job Title: Lead Snowflake Engineer
Location: Dallas, TX
Key Responsibilities:
- Lead the end-to-end Snowflake platform implementation, including architecture, design, data modeling, and governance.
- Oversee the migration of data and pipelines from legacy platforms to Snowflake, ensuring quality, reliability, and business continuity.
- Design and optimize Snowflake-specific data models, including use of clustering keys, materialized views, Streams, and Tasks.
- Build and manage scalable ELT/ETL pipelines using modern tools and best practices.
- Define and implement standards for Snowflake development, testing, and deployment, including CI/CD automation.
- Collaborate with cross-functional teams including data engineering, analytics, DevOps, and business stakeholders.
- Establish and enforce data security, privacy, and governance policies using Snowflake s native capabilities.
- Monitor and tune system performance and cost efficiency through appropriate warehouse sizing and usage patterns.
- Lead code reviews, technical mentoring, and documentation for Snowflake-related processes.
Required Snowflake Expertise:
- Snowflake Architecture Deep understanding of virtual warehouses, data sharing, multi-cluster, zero-copy cloning. Ability to enhance architecture and implement solutions as per the architecture.
- Performance Optimization Proficient in tuning queries, clustering, caching, and workload management.
- Data Engineering Experience with processing batch, real time using multiple Snowflake features like Snowpipe, Streams & Tasks, stored procedures, and data ingestion patterns.
- Data Security & Governance Strong experience with RBAC, dynamic data masking, row-level security, and tagging. Experience enabling such capabilities in Snowflake and at least one enterprise product solution.
- Advanced SQL Expertise writing, analyzing, performance optimization of complex SQL queries, transformations, semi-structured data handling (JSON, XML).
Cloud Integration Experience with at least one of the major cloud platforms (AWS/Google Cloud Platform/Azure) and services like S3, Lambda, Step Functions, etc
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.