You will design and implement scalable, secure cloud solutions and data architectures using AWS and Snowflake.
Responsibilities
- Lead end-to-end Snowflake cloud data warehouse implementations and data migrations from RDBMS.
- Design and maintain AWS infrastructure using EC2, S3, VPC, and Lambda.
- Implement infrastructure as code using AWS CloudFormation or Terraform.
- Develop Snowflake data models, complex stored procedures, and ELT processes using Snowflake SQL.
- Optimize AWS resources for cost, scalability, and performance while ensuring security via IAM and encryption.
- Provide technical guidance to cross-functional teams and maintain architectural documentation.
Required Skills
- 12+ years of total IT experience.
- 3+ years of experience as an AWS/Snowflake Data Architect.
- 8+ years of experience in Data Warehouse, ETL, and BI projects.
- Expertise in Snowflake features including data sharing, events, lake-house patterns, and Snow Pipe.
- Hands-on experience with Snow SQL and Big Data modeling using Python.
- Proficiency in RDBMS, complex SQL, and PL/SQL.
- Experience with Unix Shell Scripting and performance tuning.
- Proven ability to migrate on-premises systems to AWS.
- Strong written and communication skills.