Senior System Architect – AWS & Snowflake Data Warehouse

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.