Senior System Architect – AWS & Snowflake Data Warehouse

Research & Development

∙

Berkeley Heights, NJ

∙

June 2, 2025
Apply for this job

We are looking for a highly experienced Senior System Architect with a proven track record of designing and implementing enterprise-grade data warehouse solutions using Snowflake on AWS. This role will drive the end-to-end architecture from sourcing data across heterogeneous systems to integration, transformation, provisioning, and secure access through modern, scalable, and performant data pipelines.

Location: Berkeley Heights, NJ

Job Type: Full-time, On-site (3-5 days per week in the office)

Contract Type: Independent Contractor

Duration: Long-term

Responsibilities

  • Lead the end-to-end architecture of cloud-native data warehouse solutions using Snowflake on AWS;
  • Design data ingestion frameworks to source structured, semi-structured, and unstructured data from diverse internal and external systems;
  • Architect and oversee efficient, resilient ELT pipelines using AWS services (e.g., S3, Glue, Lambda, Step Functions);
  • Define data modeling strategies, schema optimization, and partitioning approaches within Snowflake to support high-performance workloads;
  • Establish enterprise-wide standards for data integration, transformation, and metadata management;
  • Implement robust data security, including IAM integrations, RBAC, encryption, masking, auditing, and compliance controls;
  • Collaborate with engineering, analytics, and business teams to ensure architectural alignment and stakeholder satisfaction;
  • Provide technical leadership on best practices, architectural governance, and tool selection;
  • Develop and maintain comprehensive technical documentation, architecture diagrams, and operational models.

Requirements

  • 10+ years of experience in data architecture, systems design, and enterprise data platform development;
  • Hands-on experience with Snowflake including query optimization, virtual warehouses, data sharing, and security integrations;
  • Deep understanding of AWS services relevant to data architecture (e.g., S3, Glue, Lambda, Redshift, CloudWatch, IAM);
  • Proven expertise in ELT/ETL architecture, data lake/data warehouse design, and data pipeline orchestration;
  • Strong skills in SQL, data modeling, and performance tuning at scale;
  • Experience implementing security, compliance, and governance frameworks (e.g., HIPAA, GDPR, SOC2);
  • Excellent communication and collaboration skills with the ability to work across business and technical teams.

Bonus points for

  • SnowPro Advanced Architect or equivalent certification;
  • Experience with tools such as dbt, Airflow, Informatica, or Matillion;
  • Exposure to real-time data streaming, event-driven architectures, and DevOps/CI-CD pipelines;
  • Background in regulated industries (e.g., finance, insurance, healthcare) is a strong plus.

We offer excellent benefits, including but not limited to

  • People-oriented management without bureaucracy;
  • Opportunities for self-realization, career, and professional growth;
  • Friendly and engaging professional team.

Application form

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We use cookies
We and selected third parties use cookies or similar technologies as specified in the cookie policy. You can consent to the use of such technologies by closing this notice.
AcceptDecline
Team needs
hello@agilefuel.com
Careers
jobs@agilefuel.com
Agile Fuel HQ

650 Castro St, Suite 120-376. Mountain View, CA 94041

Privacy Policy