Senior Snowflake Platform Administrator

Zelis • Boston, MA

13d • $139,000 - $176,700 • Hybrid

About The Position

The Senior Snowflake Platform Administrator is the senior hands-on owner of the Snowflake platform that underpins the Zelis Data & AI Cloud (ZDC). As Zelis moves to an AI-Native model, our data fabrics, dashboards, and AI workloads all run on this Snowflake foundation — this role keeps it secure, governed, performant, and cost-efficient.

Requirements

• 8+ years in data platform / data engineering roles, including 5+ years hands-on Snowflake administration in production.
• Deep RBAC / security design and data-governance experience (masking, access policies).
• Strong warehouse tuning, performance, and cost-optimization skills.
• Infrastructure-as-code, scripting, and CI/CD for Snowflake (Terraform, Bash/Python, schemachange, dbt, GitHub, or equivalent).
• Advanced SQL (Python preferred) and strong data-warehousing / dimensional-modeling fundamentals.
• Experience running Snowflake on AWS (S3 external stages, storage integrations) and familiarity with core AWS services.

Nice To Haves

• SnowPro Core certification (SnowPro Advanced: Administrator a plus).
• Healthcare data experience; working knowledge of HIPAA / PHI controls and DLP.
• Experience protecting sensitive data at scale (tokenization, dynamic data masking).
• Familiarity with Sigma, dbt, OpenFlow ingestion, and the medallion architecture.
• Exposure to Snowflake Cortex / AI workloads and their governance implications.

Responsibilities

• Manage Snowflake accounts, databases, schemas, warehouses, users, roles, and resource monitors.
• Design and maintain a clean RBAC model and least-privilege access.
• Integrate identity via SSO / SCIM (Okta / Entra ID).
• Implement and maintain network policies, tag-based masking, row-/column-level access policies, tokenization, and encryption.
• Leverage Snowflake Horizon for governance and monitoring.
• Own PHI/DLP guardrails and support audit and compliance (HIPAA).
• Size, tune, and optimize virtual warehouses (auto-suspend/resume, query tagging).
• Manage resource monitors.
• Drive cost management with chargeback/showback and unit-economics KPIs.
• Own dev/test/prod environments and cloning.
• Design and operate Snowflake Data Sharing, external stages on AWS S3, Apache Iceberg tables, replication, Time Travel / Fail-safe, disaster-recovery / failover, and backup strategies.
• Query performance tuning, workload isolation, and capacity planning.
• Diagnose and resolve Snowflake performance, pipeline, and access issues.
• Partner with Data Operations on run-state issues.
• Manage Snowflake objects as code (schemachange / dbt / Terraform).
• Build automation with Snowpipe, Streams, Tasks, and Dynamic Tables.
• Support deployment pipelines and release discipline.
• Maintain platform documentation, architecture diagrams, and operational runbooks.
• Document platform standards and guardrails.
• Enable engineering and business-unit teams to build safely on the platform.
• Partner with Data Platforms & Tooling on Snowflake architecture and solution design.
• Provide guidance and technical oversight to distributed / offshore Snowflake administration resources.

Benefits

• 401k plan with employer match
• flexible paid time off
• holidays
• parental leaves
• life and disability insurance
• health benefits including medical, dental, vision, and prescription drug coverage

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed