Senior/Lead Snowflake Developer/Admin

Senior/Lead Snowflake Data and Platform Engineer
Location: Irving, TX 5 days onsite
Duration: 6+ Months Contract to hire

Summary:

• The Senior Snowflake Data and Platform Engineer would lead the design, development, and administration of our Snowflake ecosystem.
• This role blends deep platform administration with hands-on data engineering, enabling secure, scalable, and high-performance data solutions across the organization.

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, Google Cloud Platform)
• 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:

• At least 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 Google Cloud Platform) 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

Matching Qualifications:

• Certifications: Advanced Snow Pro certification preferred, not beginner-level.
• Platforms: Azure and AWS experience required.
• Technical Skills: Python libraries, CI/CD implementation expertise, Data Vault knowledge.
• Senior candidates with 8 10+ years of experience with leadership competence are highly encouraged.

Collaborative Scope:

• All positions will actively engage with internal teams, external customers, and support staff to maintain system accessibility and project scalability.