Snowflake Administrator

Company Overview

Milestone Technologies is a global IT managed services firm that partners with organizations to scale their technology, infrastructure and services to drive specific business outcomes such as digital transformation, innovation, and operational agility. Milestone is focused on building an employee-first, performance-based culture and for over 25 years, we have a demonstrated history of supporting category-defining enterprise clients that are growing ahead of the market. The company specializes in providing solutions across Application Services and Consulting, Digital Product Engineering, Digital Workplace Services, Private Cloud Services, AI/Automation, and ServiceNow. Milestone culture is built to provide a collaborative, inclusive environment that supports employees and empowers them to reach their full potential.

Our seasoned professionals deliver services based on Milestone's best practices and service delivery framework. By leveraging our vast knowledge base to execute initiatives, we deliver both short-term and long-term value to our clients and apply continuous service improvement to deliver transformational benefits to IT. With Intelligent Automation, Milestone helps businesses further accelerate their IT transformation. The result is a sharper focus on business objectives and a dramatic improvement in employee productivity. Through our key technology partnerships and our people-first approach, Milestone continues to deliver industry-leading innovation to our clients. With more than 3,000 employees serving over 200 companies worldwide, we are following our mission of revolutionizing the way IT is deployed.

Job Overview

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 Google Cloud Platform 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

Compensation

Estimated Pay Range:

Exact compensation and offers of employment are dependent on circumstances of each case and will be determined based on job-related knowledge, skills, experience, licenses or certifications, and location.

Our Commitment to Diversity & Inclusion

At Milestone we strive to create a workplace that reflects the communities we serve and work with, where we all feel empowered to bring our full, authentic selves to work. We know creating a diverse and inclusive culture that champions equity and belonging is not only the right thing to do for our employees but is also critical to our continued success.

Milestone Technologies provides equal employment opportunity for all applicants and employees. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, gender, gender identity, marital status, age, disability, veteran status, sexual orientation, national origin, or any other category protected by applicable federal and state law, or local ordinance. Milestone also makes reasonable accommodations for disabled applicants and employees.

We welcome the unique background, culture, experiences, knowledge, innovation, self-expression and perspectives you can bring to our global community. Our recruitment team is looking forward to meeting you.