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 tuningDesign and implement robust Business Continuity / Disaster Recovery process, including backup, failover, replication, and recovery proceduresContinuously track Snowflake enhancements and share relevant updates with the team to ensure the team remains informedPartner with the Internal IT Security team to assess and remediate findings identified during security auditsManage user provisioning, data security, roles, and access controls across multiple environmentsLead the team in adhering to established Snowflake best practicesMust-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