Snowflake Architect (Platform & Administration)

Premier Healthcare Exchange West, Inc.
Boston, United States of America
17 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 186K

Job location

Remote
Boston, United States of America

Tech stack

Artificial Intelligence
Amazon Web Services (AWS)
Data analysis
ARM
Azure
Bash
Databases
Data Architecture
Information Engineering
Data Governance
Data Infrastructure
Data Integration
ETL
Data Sharing
Data Systems
Data Warehousing
Dimensional Modeling
Disaster Recovery
Failover
Github
Python
Performance Tuning
Role-Based Access Control
Sql Optimization
Snowflake
Software Troubleshooting
Data Layers
Data Lake
Terraform

Job description

We are seeking a Senior Snowflake Architect to design, build, and operate our Snowflake data platform. This role blends hands-on architecture with platform administration, ensuring Snowflake is secure, scalable, performant, and cost-efficient.

This is a hands-on senior individual contributor role with technical ownership and matrix leadership responsibilities, partnering closely with data engineering, analytics, and cloud teams to enable reliable, high-impact data solutions.

What You'll Do Architecture & Engineering

  • Design and implement scalable Snowflake architectures supporting data warehouse, data lake, and data sharing use cases.
  • Lead Snowflake solution design, including:
  • Dimensional and analytical data models
  • Batch and near real-time ELT/ETL pipelines
  • Data integration and Snowflake Data Sharing
  • End-to-end data layers (Bronze / Silver / Gold), semantic views, and analytics-ready datasets
  • Advanced Snowflake capabilities including Cortex AI and data agents
  • Define and implement governance features such as Snowflake Horizon, masking, and encryption.
  • Collaborate with data engineers, analytics teams, and product partners to translate business requirements into scalable technical solutions.
  • Evaluate new Snowflake features and recommend adoption to improve performance, scalability, security, and cost efficiency.
  • Enable advanced analytics use cases in Snowflake, including predictive modeling and anomaly detection using Cortex AI.

Platform Administration & Operations

  • Own day-to-day administration of Snowflake environments across development, test, and production.
  • Manage Snowflake configuration including warehouses, databases, schemas, users, roles, and resource monitors.
  • Monitor and optimize platform performance, availability, and cost usage.
  • Implement and maintain Snowflake security controls, including:
  • Role-based access control (RBAC)
  • Masking and row access policies
  • Governance and monitoring features
  • Troubleshoot and resolve Snowflake performance, pipeline, and access issues.
  • Design and implement data sharing, replication, disaster recovery/failover, and backup strategies.
  • Maintain platform documentation, architecture diagrams, and operational runbooks.
  • Ensure adherence to enterprise privacy, security, and data governance standards.
  • Provide guidance and technical oversight to distributed or offshore Snowflake administration resources.

Requirements

  • 8-10+ years of experience in data engineering, data architecture, or data platform roles
  • 4-5+ years of hands-on Snowflake experience spanning architecture and administration
  • Strong expertise in:
  • Snowflake architecture, performance tuning, and cost optimization
  • Data warehousing concepts and dimensional modeling
  • Advanced SQL; Python experience preferred
  • Experience designing and operating ELT/ETL pipelines
  • Working knowledge of Snowflake security and governance features
  • Scripting and automation experience (e.g., Bash, Terraform, or similar tools)
  • Hands-on experience with CI/CD pipelines and GitHub
  • Experience working with cloud platforms such as AWS and/or Azure
  • Strong troubleshooting, communication, and collaboration skills
  • Snowflake SnowPro Core certification preferred

Benefits & conditions

We have offices in Atlanta GA, Boston MA, Morristown NJ, Plano TX, St. Louis MO, St. Petersburg FL, and Hyderabad, India. We foster a hybrid and remote friendly culture, and all our employee's work locations are based on the needs of the position and determined by the Leadership team. In-office work and activities, if applicable, vary based on the work and team objectives in accordance with Company policies.

Base Salary Range $139,000.00 - $186,000.00

At Zelis we are committed to providing fair and equitable compensation packages. The base salary range allows us to make an offer that considers multiple individualized factors, including experience, education, qualifications, as well as job-related and industry-related knowledge and skills, etc. Base pay is just one part of our Total Rewards package, which may also include discretionary bonus plans, commissions, or other incentives depending on the role.

Zelis' full-time associates are eligible for a highly competitive benefits package as well, which demonstrates our commitment to our employees' health, well-being, and financial protection. The US-based benefits include a 401k plan with employer match, flexible paid time off, holidays, parental leaves, life and disability insurance, and health benefits including medical, dental, vision, and prescription drug coverage.

About the company

Zelis is modernizing the healthcare financial experience across payers, providers, and healthcare consumers. We serve more than 750 payers, including the top five national health plans, regional health plans, TPAs and millions of healthcare providers and consumers across our platform of solutions. Zelis sees across the system to identify, optimize, and solve problems holistically with technology built by healthcare experts - driving real, measurable results for clients. A Little About You You bring a unique blend of personality and professional expertise to your work, inspiring others with your passion and dedication. Your career is a testament to your diverse experiences, community involvement, and the valuable lessons you've learned along the way. You are more than just your resume; you are a reflection of your achievements, the knowledge you've gained, and the personal interests that shape who you are., You'll play a critical role in shaping a modern, enterprise-scale data platform - working hands-on with Snowflake's latest capabilities while partnering with talented engineering and analytics teams to deliver meaningful business impact.

Apply for this position