Senior Snowflake Data Engineer

NYGC Services, Inc.; Manila; On-site; PHP 900,000 - 1,500,000; Full time

Job summary

NYGC Services, Inc. is seeking a Snowflake Engineer to configure and manage Snowflake accounts, warehouses, databases, and schemas in a cloud environment.

You will implement IaC with Terraform to provision Snowflake resources and related infrastructure, ensuring repeatability and compliance. The role requires monitoring performance, troubleshooting issues, optimizing costs, and enforcing security policies such as RBAC and data masking.

Qualifications

• Experience configuring Snowflake accounts, virtual warehouses, databases, and schemas.
• Strong knowledge of Terraform for provisioning Snowflake resources and cloud infra using IaC.
• Experience with data governance, RBAC, and secure data sharing practices.

Responsibilities

• 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.

Skills

Snowflake Infrastructure

Terraform

Databricks

Job description

Must have: Snowflake Infrastructure
Good To Have: 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.