Data Engineer - Snowflake

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.