Senior System Architect 100
- Sun-it solutions onc
15 Days Ago
60-65 per Hourly
NA
Berkeley Heights-NJ
15-43 Years
Required Skills: data architecture, systems design, enterprise data platform development, Snowflake, query optimization, virtual warehouses, data sharing, security integrations, AWS services, ELT/ETL architecture, data lake, data warehouse design, data pipeline orchestration, SQL, data modeling, performance tuning at scale, implementing security, compliance, governance frameworks
Job Description
Job Title: Senior System Architect – AWS & Snowflake Data Warehouse
Location: Berkeley Heights, NJ
Experience Required: 15+ Years
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.
