Senior System Architect AWS & Snowflake

Role: Senior System Architect AWS & Snowflake
Location: Berkeley Heights, NJ
Type: Contract

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