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

TUZVeCtob3V4U1lMTE82OHZaSUxyRUNuTnc9PQ==
  • 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

Capital One

Principal Coordinator, Support Specialist Job at Capital One

 ...support At least 1 year of experience with Windows 10 At least 1 year of experience with ticketing and traffic reporting tools (Zendesk, HPSM, ServiceNow) Preferred Qualifications: ~ Bachelors Degree in Business, Information Systems, Computer Science,... 

Endeavors

Wellness Coach Job at Endeavors

 ...Description JOB PURPOSE: The CBP Workforce Wellness Program (WWP) is seeking a Wellness Coach to provide holistic well-being support, stress management...  ...The Wellness Coach will collaborate closely with the Health Coach and Fitness Coach to ensure a comprehensive and... 

Royal Caribbean Cruises, Inc.

Housekeeping Director Job at Royal Caribbean Cruises, Inc.

Housekeeping DirectorIn charge of overseeing the Housekeeping Department onboard the ship, Housekeeping Director ensures our guests enjoy the highest standards of cleanliness and customer service. To be successful as part of the housekeeping management team, candidates... 

Gulfstream Strategic Placements, LLC

HVAC Controls Sales Job at Gulfstream Strategic Placements, LLC

HVAC Controls Sales - SacramentoWe are a large growing HVAC contractor in Florin that work on many of Californias biggest and best HVAC projects. This is a full-time position with great benefits. We are planning to hire Californias best and brightest HVAC Controls Sales... 

Mayo Clinic

Nephrologist Job at Mayo Clinic

 ...retirement package to secure your future. Responsibilities Mayo Clinic in Jacksonville, Florida is seeking to add an academic nephrologist to our growing and productive team. Candidates must be certified or eligible for certification in Nephrology by the American...