• Snowflake Admin 100% REmote
Project & Role Overview:
• Snowflake Admin DevOps: The client is transitioning to Snowflake to address challenges with Redshift. The role sits in a DBA team and concentrates on Snowflake administration plus DevOps responsibilities, with an emphasis on infrastructure as code (Terraform). The individual will maintain and support Snowflake warehouses, provide guidance on sizing, and handle RBAC, data masking, and other Snowflake-specific administration tasks. The initial setup will be performed by a consulting firm, after which the hired resource will managed day-to-day operations, tuning, and ongoing refinements, including production support as needed. The position expects hands-on Snowflake experience and collaboration with an onshore/offshore team, including the manager and an interview panel. The role is onshore with some offshore teammates, and the candidate will join a broader DBA group that already has extensive DBA expertise (Postgres, SQL Server, MySQL) but will be the primary Snowflake expert.
Required Technical Skills:
1. Snowflake
2. Terraform
3. RBAC (role-based access control)
4. Data masking (PII handling)
5. S3 integration and cloud storage
6. Python
7. SQL
8. AWS environment operations
9. Data warehouse design and tuning
10. CI/CD practices
11.
12.
Soft Skills:
• Typical Empower soft skills – proactive – self-serving – ask questions.
Snowflake Administrator / DevOps Engineer
The Snowflake Administrator / DevOps Engineer is responsible for maintaining a secure, reliable, and cost-effective Snowflake platform on AWS. This role supports data and analytics teams by automating operations, managing cloud infrastructure, improving performance, and ensuring compliance and governance across the data platform.
Key Responsibilities
• Design, build, and maintain secure Snowflake environments and data pipelines.
• Manage Snowflake accounts, databases, schemas, warehouses, and resource monitoring across development, test, and production environments.
• Implement and support data ingestion and orchestration using Snowpipe, Streams/Tasks, Kafka Connector, and AWS S3.
• Maintain security and access controls using RBAC, masking policies, row-level security, and SSO integrations (Okta/Entra ID).
• Automate data governance processes including PII tagging and policy enforcement.
• Manage infrastructure and Snowflake configurations using Infrastructure as Code tools such as Terraform.
• Build and maintain CI/CD pipelines for dbt, ELT processes, schema migrations, and data deployments.
• Monitor platform health, query performance, data freshness, and system reliability using observability and alerting tools.
• Optimize Snowflake usage and cloud costs through warehouse tuning, query optimization, and usage reporting.
• Support integrations with AWS services, BI/reporting tools, and metadata/catalog platforms.
• Provide advanced troubleshooting, incident response, root cause analysis, and operational support.
• Collaborate with Data Engineering, Security, and Business teams to improve platform efficiency and reliability.
Required Qualifications
• Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
• 5+ years of experience in platform, systems, or DevOps engineering.
• 3+ years of hands-on Snowflake administration experience in AWS cloud environments.
• Strong knowledge of Snowflake security, RBAC, Streams/Tasks, Snowpipe, performance tuning, and resiliency strategies.
• Experience with AWS services such as EKS, EC2, RDS, S3, IAM, and VPC.
• Experience with Infrastructure as Code tools like Terraform or CloudFormation.
• Proficiency with CI/CD tools, Git workflows, SQL, and scripting languages such as Python, Bash, or Go.
• Understanding of cloud networking, security, Linux/Windows administration, and IAM/KMS concepts.
• Strong documentation, troubleshooting, and communication skills.
Preferred Qualifications
• Experience with Kubernetes, EKS, and Istio.
• Familiarity with monitoring tools such as CloudWatch, Datadog, or Splunk.
• Experience integrating Snowflake with BI and data governance tools like Tableau, Qlik, Collibra, SAS, or Alteryx.
• Experience supporting highly available, cost-optimized data platforms.
• Strong customer-service mindset with a focus on automation and documentation.
Benefits:
• Medical, Dental & Vision coverage effective on the first of the month from your date of hire.
• 4% match on 401(k) and fully vested.
• Voluntary benefits such as Short & Long-Term Disability, Critical Illness, Accident, AD&D, and Legal Shield.
• Paid subscription to the Calm app.
• Cashback available through thousands of vendors.
