Cloud Data Architect (SAS-to-Snowflake Migration) Job at Oran Inc, Remote

YWlFVXdGWFJOcGZpeWFWYnozeWlQR1k2RlE9PQ==
  • Oran Inc
  • Remote

Job Description

Job Description: Cloud Data Architect (SAS-to-Snowflake Migration)
Position Title: Cloud Data Architect Position Overview
The Cloud Data Architect will lead the design and implementation of a modern cloud-based data architecture as part of the transition from legacy SAS-based ETL processes to Snowflake. The role involves defining the technical roadmap, data modeling standards, integration strategies, and cloud-native patterns that support performance, scalability, and security across the data pipeline. Key Responsibilities
  • Architect end-to-end migration strategy from SAS ETL solutions to Snowflake in AWS.
  • Design scalable and secure Snowflake data architectures , including schemas, roles, data access, and performance strategies.
  • Define and guide the  data modeling process (e.g., star schema, normalization, de-normalization) for analytical and operational use cases.
  • Collaborate with ETL developers to translate existing SAS logic into optimized Snowflake-based workflows.
  • Configure and advise on  AWS services (e.g., S3, Lambda, Glue, IAM) that integrate with Snowflake.
  • Establish  cloud governance frameworks including cost control, monitoring, and logging.
  • Support the development of  CI/CD pipelines for Snowflake deployment (e.g., dbt, GitHub Actions).
  • Implement  data security and compliance controls aligned with FedRAMP/NIST standards.
  • Lead architectural reviews and provide technical oversight throughout the migration lifecycle.
Required Qualifications
  • 7+ years of experience in  data architecture , with at least 3 years in  cloud-native environments (AWS preferred).
  • Proven experience designing and implementing  Snowflake-based data platforms .
  • Strong background in  data modeling and SQL performance tuning.
  • Familiarity with  legacy SAS systems and understanding of SAS dataset structure/logic.
  • Hands-on experience with  cloud services (AWS, Snowflake) and  data integration frameworks (e.g., dbt, Glue, Matillion).
  • Strong understanding of  IAM, encryption, RBAC , and other data security practices.
Preferred Qualifications
  • AWS Solutions Architect certification
  • Snowflake SnowPro certification
  • Experience in government or highly regulated industries (e.g., USDA, HHS, DoD)
  • Familiarity with Agile delivery and DevOps practices

Job Tags

Similar Jobs

MillerKnoll

Intern Job at MillerKnoll

 ...participate in one-on-one meetings with mentors, a summer-long project, learning sessions with senior leaders, and much more. Showroom Intern HOLLY HUNT Enterprises, Inc. Reports to: General Manager POSITION PROFILE This position is an internship in the HOLLY... 

Professional Performance Development Group, Inc

Audiology Technician Job at Professional Performance Development Group, Inc

 ...training to clinic staff members. Provide training and/or clinical direction as applicable to supporting government employees (e.g., hospital corpsmen, students, etc.). Attend and participate in various meetings as directed. Perform timely, accurate, and concise... 

Center for Family and Child Enrichment

Part-Time HIV Community Health/Outreach Worker Job at Center for Family and Child Enrichment

 ...live a better life and build a stronger community. The Center for Family and Child Enrichment...  ...CFCE expanded in early 2012to include a health care center, The Pediatric &Family...  ...and adults. As a Community Health Worker, you are a frontline public health worker... 

Hyman Brothers Auto Group

Automotive Finance Manager Job at Hyman Brothers Auto Group

Hyman Bros. Nissan Kia is seeking an experienced Automotive Finance Manager. Candidate should be familiar with the auto finance industry and have a strong relationship with lenders both prime and subprime. MUST BE ABLE TO USE MENU AND SELL PRODUCT. E-contracting is mandatory... 

Connexa Search Group

Payroll Career Opportunities Job at Connexa Search Group

 ...details are available for most openings. We focus on matching top payroll talent with companies that value compliance, accuracy, process improvement, and technology integration. All inquiries are handled with strict confidentiality. Please reach out to Brandon Clark...