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

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

Get It - Real Estate

Mortgage Loan Originator - Remote | WFH Job at Get It - Real Estate

As a Mortgage Loan Originator, you will play a key role in helping home buyers, current...  ...evaluating loan applications, conducting underwriting assessments, and providing expert...  .... Ability to work independently and remotely, with a focus on achieving results.... 

American Bridge Company

Proposal Coordinator Job at American Bridge Company

 ...Proposal Coordinator Description We are seeking a Proposal Coordinator to join our Preconstruction Department to work with Business Development, Estimating, and Business Line Management to drive successful proposal and pursuit activities across North America. In... 

Kamloops Integrated Wellness

Locum position Job at Kamloops Integrated Wellness

1 year maternity leave opportunity available in a multidisciplinary clinic in downtown Kamloops starting in January 2026. All room furniture, full secretary, Jane app billing/booking, laundry, office supplies and marketing materials included. You will be fully booked and get...

Telus International AI

インターネット広告の品質評価 - Work from Home (Part-Time) Job at Telus International AI

 ...on to start your application process for the project. Working on this project will require you to go through a standar...  ...n book assessment). This is a long-term project and your work will occasionally be subject to quality assurance checks... 

Vitalité Health Network

Health Records Clerk (1016) Job at Vitalité Health Network

 ...DEPARTMENT: Health Records BARGAINING UNIT: CUPE JOB TYPE: Casual LANGUAGE REQUIREMENTS: Bilingual essential NOTE: Applicants...  ...programs currently used within the Network; Ability to work independently and as part of a team; Physical ability to perform...