Snowflake Platform Engineer

OpTech LLC
Cincinnati, OH, United States
13 days ago
Apply on www.nettemps.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$228,800.0
Working hours
Regular working hours

Tech stack

Query Performance Application Programming Interfaces (APIs) Amazon Web Services Amazon S3 User Authentication Computer Networks Databases Information Engineering Data Governance Monitoring of Systems Identity and Access Management Python (Programming Language)
+12 more
Performance Tuning Role-Based Access Control Shell Script SQL Databases Enterprise Data Management Scripting Sql Optimization Snowflake Concurrency Caching Infrastructure Automation Frameworks Terraform

Job description

We are seeking a highly skilled Senior Snowflake Platform Engineer to provide technical leadership and hands-on administration for an enterprise Snowflake environment. This role is responsible for ensuring the platform remains secure, reliable, scalable, and cost-effective while supporting critical business workloads.

The ideal candidate will possess deep Snowflake administration expertise, advanced SQL skills, strong performance tuning capabilities, and experience troubleshooting complex production environments. This individual will work closely with Data Engineering, Architecture, Security, and business stakeholders to drive platform excellence and enable enterprise data initiatives., Snowflake Platform Administration

  • Own day-to-day administration of the Snowflake platform, including:
  • User and role management
  • Access controls and security administration
  • Warehouse configuration and optimization
  • Resource monitoring and operational support

Performance & Cost Optimization

  • Analyze and optimize:
  • Query performance
  • Warehouse utilization
  • Concurrency and workload management
  • Compute consumption and overall platform costs
  • Leverage Snowflake monitoring tools and account usage reporting to identify optimization opportunities.

Security & Access Management

  • Implement and maintain:
  • Role-Based Access Control (RBAC)
  • Least-privilege security models
  • Service accounts
  • Authentication integrations
  • Data protection controls

Platform Standards & Governance

  • Establish standards and best practices for:
  • Warehouse sizing
  • Auto-suspend and auto-resume settings
  • Resource monitors
  • Cost management strategies
  • Workload isolation

Reliability & Operational Excellence

  • Monitor platform health and performance.
  • Investigate and resolve production incidents.
  • Conduct root cause analysis and implement preventative solutions.
  • Improve platform availability, reliability, and operational efficiency.

Database & Object Management

  • Manage platform assets including:
  • Databases
  • Schemas
  • Tables
  • Views
  • Retention configurations
  • Maintain platform hygiene through cleanup and lifecycle management activities.

Integration & Automation

  • Support Snowflake integrations with AWS services such as:
  • S3
  • IAM
  • Enterprise data ingestion and processing tools
  • Automate operational processes using SQL, Python, scripting, APIs, and related technologies.

Documentation & Collaboration

  • Develop dashboards, operational procedures, technical documentation, and cost reporting.
  • Partner with engineering and architecture teams on platform enhancements, upgrades, and enterprise data initiatives.

Requirements

  • Extensive hands-on experience administering and supporting Snowflake in a production enterprise environment.
  • Deep understanding of Snowflake architecture, including:
  • Virtual warehouses
  • Micro-partitions
  • Caching strategies
  • Query execution
  • Resource consumption
  • Advanced SQL expertise.
  • Proven experience diagnosing and resolving query performance issues.
  • Strong experience implementing:
  • RBAC
  • Role hierarchies
  • Grants and access policies
  • Secure access patterns
  • Experience with:
  • Warehouse sizing
  • Workload management
  • Cost monitoring
  • Compute optimization
  • Demonstrated success troubleshooting production incidents and improving platform reliability.
  • Strong knowledge of database administration, enterprise security, and data governance principles.
  • Excellent communication, documentation, and problem-solving skills.
  • Ability to work independently in a fast-paced enterprise environment.

Preferred Qualifications

Experience integrating Snowflake with AWS services including S3, IAM, Glue, and enterprise data pipelines.

  • Python or Shell Scripting experience for automation.
  • Experience with Terraform or Infrastructure as Code (IaC) tools.
  • Familiarity with:
  • ACCOUNT_USAGE views
  • ORGANIZATION_USAGE views
  • Resource monitors
  • Query history analysis
  • Experience implementing:
  • Masking policies
  • Row access policies
  • Network policies
  • Authentication integrations
  • Experience with:
  • Multi-cluster warehouses
  • Replication and failover strategies
  • Business continuity planning
  • SnowPro Core or Advanced Certification.
  • Experience working within a highly regulated enterprise environment.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.nettemps.com
Prepare application

Good distractions

Loading talks and stories from around this role…