Job Description

Job Title: Senior Snowflake Data and Platform Engineer

Location: Dallas, TX 5 days onsite

Duration: Contract

Key Responsibilities:

Snowflake Data Engineering:

• Implement real-time and batch ingestion, transformation, and ETL pipelines using Snowpipe, Streams and Tasks
• Develop stored procedures, functions, and views to support business intelligence and reporting
• Configure and manage external storage integrations in a multi-cloud environment (e.g., Azure Blob, AWS S3, GCP)
• Build and maintain logical and physical data models
• Automate data quality checks, monitoring, and alerting using Python scripts and orchestration tools

Snowflake Platform Engineering:

• Administer and optimize Snowflake environments, including warehouses, roles, network and security policies and performance tuning
• Design and implement robust Business Continuity/Disaster Recovery process, including backup, failover, replication, and recovery procedures
• Continuously track Snowflake enhancements and share relevant updates with the team to ensure the team remains informed
• Partner with the Internal IT Security team to assess and remediate findings identified during security audits
• Manage user provisioning, data security, roles, and access controls across multiple environments
• Lead the team in adhering to established Snowflake best practices

Must-have Requirements:

Atleast 5 years of experience in Snowflake platform administration and data engineering

Strong skills in SQL, Change Data Capture, Snow Pipes, Streams, Tasks, Stored procedures, Functions and SnowSQL

Should have data modeling experience in Snowflake along with creating ERD's

Hands-on Python development experience

Should have knowledge of Real time or Near-real time streaming data using Snowpipe, Streams and Tasks

Knowledge of Cloud platforms (AWS, Azure, or GCP) and data integration

Experience with performance tuning, indexing, and query optimization in Snowflake

Snowflake SnowPro Advanced certification

Preferred Requirements:

Data Vault 2.0 modeling experience

Experience with CI/CD pipelines and DevOps practices for Snowflake

Knowledge of DBT is a plus

Job Tags

Similar Jobs