AWS Snowflake Architect (Enterprise Architect) || Dayton, OH

Job Title: AWS Snowflake Architect (Enterprise Architect)

Location: Dayton, OH – Onsite

Duration: 6+ Months

Total IT exp.: 15+ Years

Relevant experience Required: 10+ Years

 

Role Summary

We are seeking a highly experienced AWS Snowflake Architect to lead cloud data platform modernization, data lake, data warehouse, and analytics initiatives.

The ideal candidate should possess strong expertise in:

• AWS Cloud Architecture
• Snowflake Data Warehousing
• Data Migration
• ETL/ELT Frameworks
• Infrastructure Automation
• Cloud-Native Data Engineering Solutions

 

The role involves designing scalable, secure, and high-performance data platforms, driving cloud transformation programs, mentoring technical teams, and collaborating with business stakeholders to deliver enterprise-wide data solutions.

The ideal profile aligns with large-scale Healthcare, Financial Services, and Enterprise Data Modernization initiatives.

 

Key Responsibilities

Cloud Data Platform Architecture

• Architect and implement enterprise-scale Data Lakes and Cloud Data Warehouse solutions on AWS and Snowflake.
• Design scalable, secure, and high-performance cloud data platforms.
• Drive enterprise cloud transformation initiatives.

ETL / ELT Development

• Design and build scalable ELT/ETL frameworks using:
• Snowflake
• AWS Glue
• AWS Lambda
• AWS Step Functions

Cloud Migration

• Lead cloud migration initiatives from on-premises databases and applications to AWS.
• Develop enterprise data migration strategies.

Modern Data Platform Design

• Implement Medallion Architecture:
• Bronze Layer
• Silver Layer
• Gold Layer
• Design CDC-based data integration solutions using:
• AWS DMS
• Snowpipe
• Streams
• Tasks

Security & Governance

• Establish data governance frameworks.
• Implement security controls.
• Configure Role-Based Access Control (RBAC).
• Ensure compliance with enterprise security standards.

Infrastructure Automation

• Develop Infrastructure as Code (IaC) using:
• Terraform
• AWS CloudFormation
• Automate infrastructure deployment.

DevOps

• Implement CI/CD pipelines for data platform deployments.
• Automate deployment processes.

Snowflake Optimization

• Optimize:
• Performance
• Storage
• Compute utilization
• Cloud infrastructure costs

Leadership

• Mentor onshore and offshore technical teams.
• Provide architecture guidance and technical leadership.

 

Required Technical Skills

AWS Cloud Services

• Amazon S3
• EC2
• Lambda
• Redshift
• RDS
• DynamoDB
• DMS
• SCT
• VPC
• IAM
• KMS
• Step Functions
• ECS
• ECR
• Fargate
• EventBridge
• SNS
• Lake Formation
• Amazon AppFlow

 

Snowflake

• Snowflake Data Warehouse Architecture
• Snowpipe
• Streams & Tasks
• Stored Procedures
• RBAC Security
• Virtual Warehouses
• Multi-Cluster Warehouses
• Resource Monitoring
• Zero-Copy Cloning
• Data Sharing
• Performance Tuning
• Cost Optimization

 

Data Engineering & Analytics

• Data Lake Architecture
• Data Warehouse Design
• ELT/ETL Frameworks
• CDC Implementation
• Medallion Architecture
• Metadata Management
• Data Modeling
• Data Governance
• Data Migration Strategy
• Parquet Processing
• JSON Processing

 

Infrastructure as Code (IaC)

• Terraform
• AWS CloudFormation
• AWS Service Catalog
• Infrastructure Automation

 

DevOps & Automation

• AWS CodeCommit
• AWS CodePipeline
• GitHub
• CI/CD Pipelines
• Agile/Scrum
• Jira

 

Programming & Scripting

• Python
• SQL
• PL/SQL
• Shell Scripting (Bash)
• PySpark

 

Preferred Domain Experience

• Healthcare
• Health Insurance
• PBM (Pharmacy Benefit Management)
• Life Sciences
• Enterprise Data Modernization
• Large-Scale Data Migration Projects
• Financial Services

 

Leadership Responsibilities

• Lead architecture reviews and technology strategy discussions.
• Define cloud adoption and modernization roadmaps.
• Collaborate with business stakeholders, product owners, and delivery teams.
• Establish governance, security, and operational best practices.
• Mentor engineers, architects, and data platform teams.
• Drive solution design, performance optimization, and technical excellence.

 

Preferred Certifications

• AWS Certified Solutions Architect – Associate
• AWS Certified Solutions Architect – Professional
• AWS Certified Database Specialty
• SnowPro Core Certification
• Cloud Data Engineering Certifications

 

Education

• Bachelor's Degree in Computer Science
• Master's Degree in Computer Science
• Information Technology
• Engineering
• Related Technical Field

 

Preferred Candidate Profile

• 15+ years of overall IT experience.
• Deep expertise in AWS Cloud Architecture.
• Strong hands-on experience implementing Snowflake-based Enterprise Data Warehouse solutions.
• Proven experience leading cloud data transformation and migration projects.
• Ability to work with executive stakeholders.
• Strong technical leadership across enterprise programs.

 

Role Description

We are seeking a highly experienced AWS Snowflake Architect to lead cloud data platform modernization, data lake, data warehouse, and analytics initiatives.

The ideal candidate will possess strong expertise in AWS cloud architecture, Snowflake data warehousing, data migration, ETL/ELT frameworks, infrastructure automation, and cloud-native data engineering solutions.

The role involves:

• Designing scalable, secure, and high-performance data platforms.
• Driving cloud transformation programs.
• Mentoring technical teams.
• Collaborating with business stakeholders.
• Delivering enterprise-wide data solutions.

Key responsibilities include:

• Architecting enterprise-scale Data Lakes and Cloud Data Warehouses.
• Building ELT/ETL frameworks using Snowflake, AWS Glue, Lambda, and Step Functions.
• Leading on-premises to AWS cloud migration.
• Implementing Medallion Architecture.
• Designing CDC-based integration using AWS DMS, Snowpipe, Streams, and Tasks.
• Implementing governance, RBAC, and compliance.
• Developing IaC using Terraform and CloudFormation.
• Implementing CI/CD pipelines.
• Optimizing Snowflake performance and cloud infrastructure.
• Mentoring technical teams.

 

Essential Skills

• AWS Cloud Architecture
• Snowflake
• Data Lake Architecture
• Data Warehouse Design
• ETL/ELT Frameworks
• AWS Glue
• AWS Lambda
• AWS Step Functions
• AWS DMS
• Snowpipe
• Streams & Tasks
• Medallion Architecture
• CDC
• Terraform
• AWS CloudFormation
• CI/CD Pipelines
• Data Governance
• RBAC
• Performance Optimization
• Cloud Migration
• Technical Leadership

 

Desirable Skills

• Not Specified

 

Primary Skills

• Digital: Cloud DevOps
• Digital: Python
• Digital: Amazon Web Service (AWS) Cloud Computing
• Digital: Snowflake
• Digital: Terraform
• Amazon Web Services Data & Analytics

 

 

Thank You!

Vineet Kumar Sharma

Senior Recruitment Consultant

Email ID: vineet.kumar@pacerstaffing.com