What are the responsibilities and job description for the Snowflake Platform Engineer position at Javen Technologies, Inc?
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.