Overview
On Site
BASED ON EXPERIENCE
Full Time
Contract - Independent
Contract - W2
Skills
Sourcing
Provisioning
Cloud Computing
Unstructured Data
Management
Step-Functions
Optimization
Data Integration
Meta-data Management
Data Security
RBAC
Encryption
Auditing
Analytics
IT Management
Technical Writing
Systems Design
Snow Flake Schema
Query Optimization
Amazon Web Services
Data Architecture
Amazon S3
Amazon Redshift
ELT
ETL Architecture
Data Lake
Data Warehouse
Extract
Transform
Load
Orchestration
SQL
Data Modeling
Performance Tuning
Regulatory Compliance
HIPAA
System On A Chip
Communication
Collaboration
Informatica
Real-time
Streaming
DevOps
Continuous Integration
Continuous Delivery
Finance
Insurance
Health Care
Job Details
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:
Required Qualifications:
Preferred Qualifications:
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.
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.