Snowflake Administrator

Milestone Technologies is currently searching for a Snowflake Administrator candidate to join our IT Development team.

Responsibilities

Security & Access Management: Implement RBAC, manage users/roles, control object-level access, and maintain network/security policies. Resource Management: Create and manage warehouses, databases, and schemas; optimize compute usage and enable secure data sharing. Performance Optimization: Monitor query and warehouse performance, resolve bottlenecks, and implement clustering, caching, and auto-suspend/resume. Cost & Usage Governance: Track compute/storage usage, manage warehouse sizes, and apply resource monitors for cost control. Data Governance & Compliance: Enforce data security, masking, and access policies to meet compliance requirements (HIPAA, GDPR, SOC2). Automation & Integration: Automate Snowflake tasks and integrate with CI/CD, dbt, Terraform, and monitoring tools (e.g., Airflow, DataDog). Collaboration & Documentation: Maintain platform documentation, best practices, and support cross-functional data teams for operational excellence.

Skills
•Snowflake Platform Administration

• Manage Snowflake accounts, warehouses, databases, schemas, roles, and users
• Implement RBAC, security policies, and data governance standards
• Monitor warehouse usage, query performance, and cost optimization
• Handle cloning, Time Travel, failover, replication, and disaster recovery
• Manage Dev / QA / Prod environments — capacity planning and scaling
• Troubleshoot performance issues, failed tasks, and platform incidents

Development & Integration

• Develop stored procedures, UDFs, and Snowflake Scripting solutions
• Implement CDC using Streams, Tasks, and Snowpipe for incremental data changes
• Integrate Snowflake with external sources (AWS S3, Azure ADLS, GCS, APIs, BI tools)
• Create and manage Snowflake Tasks and orchestration workflows

Automation & Operations

• Automate provisioning, monitoring, alerting, and housekeeping
• Build CI/CD pipelines for Snowflake objects and deployments
• Document technical standards, runbooks, and best practices

Collaboration & Governance

• Partner with data engineering, analytics, and business teams
• Enforce data quality, lineage, and compliance standards
• Support audits, access reviews, and security compliance
• Mentor junior members and contribute to platform roadmap

Required Qualifications

• 4+ years hands-on Snowflake administration and development
• Strong SQL, stored procedures, and Snowflake Scripting
• CDC — Streams, Tasks, Snowpipe
• RBAC, masking policies, row access policies, data governance
• Cloud platforms — AWS, Azure, or GCP integration with Snowflake
• Automation of data workflows and operational tasks
• Query tuning, warehouse optimization, troubleshooting
• Agile/DevOps — Git and CI/CD tools

Preferred Qualifications

• SnowPro Advanced Administrator or SnowPro Core
• dbt, Airflow, Python/Snowpark
• Private Link, SSO/SAML, SCIM
• Snowflake Horizon — tagging, classification, lineage
• Regulated industry experience (SOX, GDPR, HIPAA)

Technical Skills

Area
AdministrationAccounts: RBAC, warehouses, resource monitors, cost optimization

Security: Masking, row access policies, network policies

Development: SQL, stored procedures, UDFs, Snowflake Scripting

CDC & Pipelines: Streams, Tasks, Snowpipe, Dynamic Tables

Integration:AWS S3, Azure ADLS, GCS, storage integrations

DR & Environment:Clone, Time Travel, replication, failover, Dev/QA/Prod

Automation:CI/CD, Git, schemachange/Flyway, Python, alerting

Monitoring:QUERY_HISTORY, TASK_HISTORY, ACCESS_HISTORY