Cincinnati, Ohio (Onsite)Job SummaryClient is seeking an experienced Senior Snowflake Platform Engineer to manage, secure, optimize, and maintain its enterprise Snowflake data platform.
The ideal candidate will have extensive hands-on experience in Snowflake administration, advanced SQL, query performance tuning, warehouse optimization, security and access management, and production troubleshooting.
This role will focus on improving platform reliability, optimizing compute costs, implementing security best practices, and supporting AWS integrations. The engineer will collaborate with Data Engineering, Architecture, Security, and business teams to ensure the platform remains secure, scalable, and efficient.
Key ResponsibilitiesManage day-to-day Snowflake platform administration, including users, roles, permissions, virtual warehouses, and resource monitoring.
Analyze and optimize SQL queries, warehouse utilization, concurrency, and compute costs.
Implement Role-Based Access Control (RBAC), least-privilege access, service accounts, and authentication integrations.
Establish standards for warehouse sizing, auto-suspend, auto-resume, resource monitors, and workload management.
Monitor platform health, troubleshoot production issues, conduct root cause analysis, and implement preventive measures.
Manage Snowflake database objects, including databases, schemas, tables, and views.
Support data integration between Snowflake and AWS services, including S3 and IAM.Automate platform administration and operational tasks using SQL, Python, scripting, and APIs.
Implement security controls, data protection policies, and access reviews.
Collaborate with engineering and architecture teams on platform improvements and enterprise data initiatives.
Ensure platform reliability, operational efficiency, security, and compliance with enterprise standards.
Required QualificationsExtensive hands-on experience administering Snowflake in a production enterprise environment.
Strong understanding of Snowflake architecture, virtual warehouses, micro-partitions, caching, and query execution.
Advanced SQL skills with proven experience in query performance tuning and troubleshooting.
Practical experience implementing Snowflake RBAC, role hierarchies, grants, and access policies.
Experience with warehouse sizing, resource utilization, workload management, and cost optimization.
Strong production support and troubleshooting skills, including root cause analysis.
Knowledge of database administration, data governance, and enterprise security practices.
Experience monitoring platform performance and improving operational reliability.
Strong problem-solving, communication, and technical documentation skills.
Technical Skills1. Snowflake Platform AdministrationSnowflake account and platform administrationVirtual warehouse managementDatabase, schema, table, and view managementResource monitoring and platform maintenanceSnowflake architecture and query execution2. SQL and Performance OptimizationAdvanced SQLQuery performance tuningQuery history analysisWarehouse utilization and concurrency optimizationCompute cost management3. Security and Access ManagementRole-Based Access Control (RBAC)Role hierarchies and grantsLeast-privilege accessAuthentication integrations and service accountsMasking policies and row access policiesNetwork policies and data protection4. AWS Integration and AutomationAWS S3 and IAM integrationData ingestion and processing integrationsPython and shell scriptingSQL automation and APIsTerraform and Infrastructure as Code (IaC)5. Monitoring and Production OperationsSnowflake ACCOUNT_USAGE views
ORGANIZATION
_USAGE viewsResource monitorsProduction incident managementRoot cause analysisPlatform reliability and cost reportingPreferred QualificationsExperience integrating Snowflake with
AWS S3, IAM, AWS
Glue, and enterprise data pipelines.
Experience automating administrative tasks using Python or shell scripting.
Familiarity with Terraform or other Infrastructure as Code tools.
Knowledge of Snowflake replication, failover, multi-cluster warehouses, and business continuity.
Experience with advanced Snowflake security features and authentication mechanisms.
SnowPro Core or SnowPro Advanced certification.
Experience working in financial services, banking, or other regulated enterprise environments.