Senior Snowflake Platform Engineer

Job Title: Senior Snowflake Platform Engineer

Duration: 6+ Months Contract (Possible Extensions)

Location: Cincinnati, OH Onsite.

TECHNICAL SKILLS:

Must Have

• Advanced SQL and performance tuning
• Automation and AWS integration
• Cost and warehouse optimization
• Platform Engineering
• Production operations and troubleshooting
• Security and access management
• Snowflake platform administration

JOB DESCRIPTION

Job Summary: The Senior Snowflake Platform Engineer will provide hands-on technical leadership for the administration, reliability, security, performance, and cost optimization of the enterprise Snowflake platform. This role will partner with Data Engineering, Architecture, Security, and business teams to ensure a secure, scalable, and efficient data platform that supports critical enterprise workloads. The ideal candidate has deep, practical Snowflake administration experience, strong SQL and performance-tuning skills, and the ability to independently troubleshoot complex production issues and implement platform improvements.

Key Responsibilities

• Own day-to-day Snowflake platform administration, including user and role management, access controls, warehouse configuration, resource monitoring, and operational support.
• Analyze and optimize query performance, warehouse utilization, concurrency, and compute costs using Snowflake monitoring and account usage capabilities.
• Implement and maintain role-based access control (RBAC), least-privilege access, service accounts, authentication integrations, and data protection controls.
• Establish platform standards for warehouse sizing, auto-suspend and auto-resume, resource monitors, workload isolation, and cost management.
• Monitor platform health, investigate incidents, perform root cause analysis, and implement preventative measures to improve reliability.
• Manage database objects and platform hygiene, including schemas, tables, views, retention settings, and obsolete resource cleanup.
• Support data integration and connectivity with AWS services, including S3, IAM, and relevant data ingestion and processing tools.
• Automate administrative tasks and operational processes using SQL, Python, scripting, and APIs.
• Develop operational dashboards, documentation, and procedures for platform monitoring, incident response, access reviews, and cost reporting.
• Collaborate with engineering teams on platform architecture, upgrades, new capabilities, and enterprise data initiatives.

Minimum Qualifications

• Extensive hands-on experience administering and supporting Snowflake in a production enterprise environment.
• Strong knowledge of Snowflake architecture, virtual warehouses, micro-partitions, caching, query execution, and resource consumption.
• Advanced SQL skills and demonstrated experience diagnosing and resolving query performance issues.
• Practical experience implementing Snowflake RBAC, role hierarchies, grants, access policies, and secure access patterns.
• Experience with warehouse sizing, workload management, cost monitoring, and compute optimization.
• Experience troubleshooting production incidents and improving platform reliability.
• Strong understanding of database administration, data governance, and enterprise security practices.
• Ability to work independently, communicate effectively, and provide clear technical documentation.

Preferred Qualifications

• Experience integrating Snowflake with AWS S3, IAM, Glue, and enterprise data pipelines.
• Python or shell scripting for automation and administrative tasks.
• Experience with Terraform or other Infrastructure as Code tools.
• Familiarity with Snowflake resource monitors, ACCOUNT_USAGE views, ORGANIZATION_USAGE views, and query history analysis.
• Experience with Snowflake security features such as masking policies, row access policies, network policies, and authentication integrations.
• Experience with Snowflake workload management, multi-cluster warehouses, replication, failover, and business continuity.
• SnowPro Core or Advanced certification.
• Experience in financial services or another regulated enterprise environment.