System Architect-Snowflake+Aws
Content + Source + Freshness • 11 Dec 2025 • 95% confidence
Offer value
This offer provides strong value due to the critical technical expertise required and the high demand for skilled architects in the data space.
- Leading role in designing advanced data solutions with Snowflake.
- Strong job market demand for senior architects.
- Requires deep technical experience (15+ years) and on-call support.
- Critical influence on operational reliability and performance.
Pros
- Significant input in designing data architecture solutions.
- High demand for skills in Snowflake and AWS.
- Opportunity to lead production support and optimization initiatives.
Cons
- Requires substantial experience (15+ years) in data architecture.
- Potentially high stress due to production environment responsibilities.
- Limited flexibility in work arrangements due to on-call requirements.
Who it's for
Senior / Expert • On-site; potential remote during non-critical hours.
Good fit
- Experienced data architects specializing in cloud-based solutions.
- Professionals looking to solidify their expertise in production environments.
- Individuals who thrive in high-pressure technical challenges.
Not recommended for
- Inexperienced candidates or those without extensive data background.
- Individuals preferring less critical roles.
- Candidates seeking remote-only positions.
Motivation fit
Key skills
About the job
Job Description
We are looking for a seasoned Senior System Architect with a strong foundation in Snowflake and AWS architecture, who also brings hands-on expertise in production support and operational reliability. This role will be responsible for designing robust, scalable data warehouse solutions while ensuring high availability, performance, and supportability of production environments.
The ideal candidate combines strategic architectural vision with the technical depth needed to troubleshoot, optimize, and maintain complex data systems in real-time
Key Responsibilities:
- Lead end-to-end solution design for data warehouse platforms using Snowflake on AWS.
- Architect and oversee data ingestion, transformation, and provisioning pipelines that are performant, secure, and maintainable.
- Design and implement monitoring, alerting, and logging frameworks for production data environments.
- Provide hands-on production support, including issue triaging, root cause analysis, resolution, and post-mortem reporting.
- Establish and manage SLA-driven support models, escalation paths, and on-call processes.
- Optimize Snowflake performance, warehouse sizing, and cost management strategies for production use.
- Collaborate with DevOps, platform, and engineering teams to maintain high system uptime and reliability.
- Ensure security, governance, and compliance standards are enforced across the entire lifecycle.
- Document architecture, production support runbooks, and incident resolution procedures.
Required Qualifications:
- Minimum 15 years of experience in data architecture, enterprise systems design, and cloud data platforms.
- In-depth experience with Snowflake, including query optimization, virtual warehouse tuning, and monitoring in production environments.
- Strong hands-on expertise with AWS services, especially S3, Glue, Lambda, CloudWatch, and IAM.
- Experience setting up and managing production support processes, on-call rotations, and incident response in large-scale environments.
- Strong SQL skills, with ability to troubleshoot and optimize long-running or failed queries in production.
- Familiarity with tools like dbt, Airflow, Matillion, and monitoring tools such as Datadog, Splunk, or CloudWatch Logs.
- Demonstrated ability to work under pressure in fast-paced environments and maintain system reliability.
Preferred Qualifications:
- SnowPro Advanced Architect certification or equivalent.
- Experience with automated testing, CI/CD pipelines, and infrastructure as code (IaC).
- Exposure to real-time data streaming (e.g., Kinesis, Kafka) and event-driven designs.
- Background in production support for regulated industries (e.g., finance, healthcare, insurance) is a plus.
