Overview
On Site
$60 - $70
Contract - Independent
100% Travel
Skills
Data Architeture
ETL
Snowflake
Job Details
Job Title: Senior System Architect AWS & Snowflake Data Warehouse
Location: Berkeley Heights, NJ
Location: Berkeley Heights, NJ
Experience Required: 15+ Years
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.