Description

Architect and implement enterprise-scale data lakes and cloud data warehouse solutions on AWS and Snowflake.

This role is remote.

Responsibilities

• Design scalable ELT/ETL frameworks using Snowflake, AWS Glue, Lambda, and Step Functions.
• Lead cloud migration initiatives from on-premises databases to AWS.
• Define and implement Medallion Architecture and CDC-based data integration using AWS DMS, Snowpipe, Streams, and Tasks.
• Develop Infrastructure as Code solutions using Terraform and CloudFormation.
• Optimize Snowflake performance, storage, compute utilization, and cloud infrastructure costs.

Required Skills

• 15+ years of overall IT experience with deep expertise in AWS cloud and data platform architecture.
• Strong hands-on experience implementing Snowflake-based enterprise data warehouse solutions.
• Proficiency in AWS services: S3, EC2, Lambda, Redshift, RDS, DynamoDB, DMS, VPC, IAM, KMS, Step Functions, ECS, ECR, Fargate, EventBridge, SNS, Lake Formation, AppFlow.
• Snowflake expertise: 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: Data Lake Architecture, Data Warehouse Design, ELT/ETL Frameworks, CDC Implementation, Medallion Architecture, Metadata Management, Data Modeling, Data Governance, Data Migration Strategy, Parquet & JSON Processing.
• Infrastructure as Code: Terraform, AWS CloudFormation, AWS Service Catalog.
• DevOps & Automation: AWS CodeCommit, AWS CodePipeline, GitHub CI/CD Pipelines.
• Programming & Scripting: Python, SQL, PL/SQL, Shell Scripting (Bash), PySpark.

Preferred Skills

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

Key Skills

Education

Bachelor's or Master's degrees