Snowflake Platform Engineer, AI & Data Platforms (AiDP)

A specialized role for a Snowflake Platform Administration u0026 Performance Engineer role focuses on the seamless synergy between automated administration and high-tier workload optimization. This position is about transforming the data warehouse into an autonomous high-performance engine that fuels real-time decision-making.

Performance Tuning u0026 Optimization: Proactively monitor and tune workloads using Snowsight Performance Explorer and account usage will optimize query execution by analyzing query profiles for disk spillage identifying Cartesian joins and implementing Search Optimization Services or Query Acceleration where necessary. Lakehouse Implementation: Design and manage unified storage using Apache Iceberg to allow open-format data to be queried directly in Snowflake with warehouse-level performance. Python-Driven Automation: Develop advanced scripts and pipelines using Snowpark Python and Snowpark pandas APIs for scalable data transformations. Automate administrative tasks such as environment provisioning and security policy enforcement through Infrastructure as Code (IaC) tools like : Manage Snowflake Iceberg Tables in AWS in cloud s3 gateway private link EKS Load Balancing VPC peering and secure data sharingnnAdvanced Cost Management: Implement autonomous warehouse management right-sizing clusters based on real-time usage patterns and configuring auto-suspend/resume with 60-second timeouts to eliminate idle compute wastennSnowflake Platform Administration: Manage accounts virtual warehouses and database objects. This includes configuring auto-scaling monitoring warehouse utilization and implementing backup strategies via Time Travel and CloningnnSecurity u0026 Governance: Implement Role-Based Access Control (RBAC) Multi-Factor Authentication (MFA) and data masking policies. You are responsible for ensuring compliance with data protection standards like GDPR or HIPAA

Snowflake Platform Administration: Manage accounts virtual warehouses and database objects. This includes configuring auto-scaling monitoring warehouse utilization and implementing backup strategies via Time Travel and Cost Management: Implement autonomous warehouse management right-sizing clusters based on real-time usage patterns and configuring auto-suspend/resume with 60-second timeouts to eliminate idle compute Implementation: Design and manage unified storage using Apache Iceberg to allow open-format data to be queried directly in Snowflake with warehouse-level -Driven Automation: Develop advanced scripts and pipelines using Snowpark Python andnSnowpark pandas APIs for scalable data transformations. Automate administrative tasks such as environment provisioning and security policy enforcement through Infrastructure as Code (IaC) tools like Terraform.

Snowflake experiencenData Engineer or Database Administration or Performance Tuning experience nArchitecture Knowledge: Deep understanding of multi-cluster shared data architecture and micro-partitioningnBachelors Degree Computer Science or equivalent degree or experience

2 years in database administration or Performance Tuning with specific hands-on Snowflake experiencennMasters Degree Computer Science or equivalent degreennArchitecture Knowledge: Deep understanding of Snowflakes multi-cluster shared data architecture and : SnowPro Core Certification is highly preferred along with cloud-specific associate or professional certificationsnnPerformance Tuning u0026 Optimization: Proactively monitor and tune workloads using Snowsight Performance Explorer and ACCOUNT USAGE will optimize query execution by analyzing query profiles for disk spillage identifying Cartesian joins and implementing Search Optimization Services or Query Acceleration where Optimization: Analyze credit consumption and query performance to reduce spend while maintaining SLAsnnPython-Driven Automation: Develop advanced scripts and pipelines using Snowpark Python andnSnowpark pandas APIs for scalable data transformations. Automate administrative tasks such as environment provisioning and security policy enforcement through Infrastructure as Code (IaC) tools like Terraform.