Apply on Employer Site

Zelis · 6 hours ago

Senior Snowflake Architect (Platform & Administration)

Middlesex County, NJ

Full-time

Hybrid

Senior Level, Lead/Staff

$139K/yr - $186K/yr

8+ years exp

Zelis is modernizing the healthcare financial experience across payers, providers, and healthcare consumers. They are seeking a Senior Snowflake Architect to design, build, and operate their Snowflake data platform, ensuring it is secure, scalable, and cost-efficient while collaborating with various teams to enable high-impact data solutions.

FinanceFinTechHealth Care

No H1B

Responsibilities

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

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

Qualification

Snowflake architectureData warehousingAdvanced SQLELT/ETL pipelinesSnowflake securityScriptingAutomationCI/CD pipelinesCloud platformsPythonSnowPro Core certificationTroubleshooting skillsCommunication skillsCollaboration skills