Snowflake Data Warehouse

Xurpas Inc; Taguig; On-site; PHP 1,500,000 - 2,100,000; Full time

Job summary

Xurpas Inc is seeking an experienced Snowflake Engineer to configure, deploy, and maintain Snowflake infrastructure across databases, warehouses, and schemas. You will leverage Terraform for provisioning and work on performance tuning, security, and cost control.

Collaboration with data engineers and cross-functional teams is essential to deliver scalable data solutions. Your role includes managing releases, security policies, disaster recovery, and ensuring data integrity and availability

Qualifications

• Minimum 5 years of experience with Snowflake infrastructure.
• Experience configuring and maintaining Snowflake accounts, warehouses, databases, and schemas.
• Experience using Terraform to provision Snowflake resources.

Responsibilities

• Configure, deploy, and maintain Snowflake accounts, virtual warehouses, databases, and schemas.
• Use Terraform to provision and manage Snowflake resources and associated cloud infrastructure.
• Monitor warehouse performance, query performance, and resource utilization; troubleshoot issues to ensure optimal system performance.
• Implement and manage access controls, including RBAC, secure data sharing, and data governance policies to protect sensitive data.
• Manage Snowflake releases, features, and account-level configurations; evaluate and enable new capabilities as needed.
• Provide technical support to Snowflake users, including query troubleshooting, performance tuning, and issue resolution.
• Optimize warehouse sizing, auto-suspend/resume settings, and query design for performance and cost efficiency.
• Monitor and manage auto-scaling of virtual warehouses to ensure efficient resource allocation.
• Implement and enforce security policies, including RBAC, masking policies, row-level security, and encryption mechanisms.
• Develop and maintain backup, failover, and disaster recovery strategies using features like Time Travel and Fail-safe to ensure data integrity and availability.
• Collaborate with data engineers to integrate Snowflake with external data sources, data lakes, and ETL/ELT pipelines.
• Monitor and manage platform costs, including credit usage, storage costs, and optimizing workloads to control expenses.
• Collaborate with cross-functional teams to understand requirements and deliver scalable data solutions.

Skills

Snowflake Infra

RBAC & Data Governance

Cost Optimization

Tools

Snowflake

Terraform

Databricks

Job description

• Configure, deploy, and maintain Snowflake accounts, virtual warehouses, databases, and schemas.
• Use Terraform to provision and manage Snowflake resources (databases, warehouses, roles, users) and associated cloud infrastructure, ensuring consistency and repeatability through Infrastructure as Code.
• Monitor warehouse performance, query performance, and resource utilization; troubleshoot issues to ensure optimal system performance.
• Implement and manage access controls, including role-based access control (RBAC), secure data sharing, and data governance policies to protect sensitive data.
• Manage Snowflake releases, features, and account-level configurations; evaluate and enable new capabilities as needed.
• Provide technical support to Snowflake users, including query troubleshooting, performance tuning, and issue resolution.
• Optimize warehouse sizing, auto-suspend/resume settings, and query design for performance and cost efficiency.
• Monitor and manage auto-scaling of virtual warehouses to ensure efficient resource allocation.
• Implement and enforce security policies, including RBAC, masking policies, row-level security, and encryption mechanisms.
• Develop and maintain backup, failover, and disaster recovery strategies using features like Time Travel and Fail-safe to ensure data integrity and availability.
• Collaborate with data engineers to integrate Snowflake with external data sources, data lakes, and ETL/ELT pipelines.
• Monitor and manage platform costs, including credit usage, storage costs, and optimizing workloads to control expenses.
• Collaborate with cross-functional teams (data engineers, data scientists, analysts, and business stakeholders) to understand requirements and deliver scalable data solutions.

Must have

Snowflake Infrastructure

Good To Have

Terraform, Databricks

Number of years of experience needed

5 years (or more is accepted)