Snowflake Data Warehouse Engineer
- Posted 2 months ago
- Be among the first 10 applicants
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.
Good To Have: Terraform, Databricks
More Info
Key Skills
About Company
Skills:
Sql, Data Modeling, Data Governance, Etl Tools, data querying languages, database design principles, data quality frameworks, data integration techniques, Snowflake Data Warehouse
Skills:
Sql, Data Modeling, Data Governance, Etl Tools, data quality frameworks, database design principles, data querying languages, data integration techniques, Snowflake Data Warehouse