Description
On-site in Cincinnati, OH
Our client seeks a Senior Snowflake Platform Engineer to provide hands-on technical leadership for administration, reliability, security, performance, and cost optimization of the enterprise Snowflake platform. The role partners with Data Engineering, Architecture, Security, and business teams to ensure a secure, scalable, and efficient data platform supporting critical workloads. The ideal candidate brings deep Snowflake administration experience, strong SQL and performance tuning skills, and the ability to troubleshoot complex production issues and implement platform improvements.
Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.
Rate: $100.00 to $115.00/hr. w2
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 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.
Experience Requirements
- 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 with 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.
- Understanding of database administration, data governance, and enterprise security practices.
- Ability to work independently, communicate effectively, and produce clear technical documentation.
- Preferred: Integration with AWS S3, IAM, Glue, and enterprise data pipelines.
- Preferred: Python or shell scripting for automation and administrative tasks.
- Preferred: Terraform or other Infrastructure as Code tools.
- Preferred: Familiarity with resource monitors, ACCOUNT_USAGE, ORGANIZATION_USAGE, and query history analysis.
- Preferred: Experience with masking policies, row access policies, network policies, and authentication integrations.
- Preferred: Workload management, multi-cluster warehouses, replication, failover, and business continuity.
- Preferred: SnowPro Core or Advanced certification.
- Preferred: Experience in financial services or another regulated enterprise environment.