Overview
Skills
Job Details
Senior System Architect AWS & Snowflake (Architecture + Production Support) Location: Berkeley Heights, NJ (On-site / Hybrid) Type: 18-Month Contract / Contract-to-Hire Experience Required: 15+ Years About the Role
We are seeking a Senior System Architect with a powerful mix of Snowflake and AWS architectural expertise and hands-on production support experience. You ll play a key role in designing enterprise-scale data platforms while ensuring high system reliability, performance, and supportability in fast-paced, mission-critical environments.
What You ll Be Doing
Design end-to-end data warehouse solutions using Snowflake on AWS.
Build scalable, secure data ingestion and transformation pipelines.
Implement production-grade monitoring, alerting, and logging frameworks.
Take ownership of incident management from triage to post-mortem.
Optimize Snowflake performance (query tuning, cost control, warehouse sizing).
Set up SLA-driven support models, escalation paths, and on-call processes.
Collaborate with cross-functional teams (DevOps, security, platform) to ensure system uptime.
Create detailed documentation including architecture blueprints and runbooks.
Enforce best practices for data governance, security, and compliance.
What You Bring
15+ years of experience in data architecture, systems design, and cloud platforms.
Deep, hands-on knowledge of Snowflake in production environments.
Proficient with AWS services S3, Glue, Lambda, IAM, and CloudWatch.
Strong SQL skills with real-time production troubleshooting capabilities.
Familiarity with dbt, Airflow, Matillion, and monitoring tools (Datadog, Splunk).
Proven track record in production support, including on-call and incident resolution.
SnowPro Advanced Architect Certification Experience with real-time streaming (Kafka, Kinesis) and event-driven architecture Background in regulated industries (finance, healthcare, insurance)
Knowledge of CI/CD pipelines and Infrastructure as Code (IaC) tools like Terraform