Senior System Architect

Job Description

Senior System Architect Berkeley Heights, NJ Apply for this job Job Title: Senior System Architect Location: Berkley Heights, NJ (candidate Must be from Berkley Heights) Work Mode- onsite 5 Days Experience Level:15+ years Please reply with below required information Total Exp- Exp in data architecture, systems design, and enterprise data platform development - Exp in Snowflake- Exp in query optimization, virtual warehouses, data sharing, and security integrations- Exp in AWS - Exp in ELT/ETL architecture- Current CTC/Hourly rate: Expected CTC/ Hourly rate: Notice Period/ Earliest possible start date: Current Location: Ok with WFO - Work Permit/Visa Status/Citizenship- Work Permit Validity (Please mention Start & End Date) - Please apply with details on recruiting@incubit.com Role Overview: 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. Key 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. Required Qualifications: Minimum 15 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 Preferred Qualifications: 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. Apply for this job