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

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

Drama Kids of Manasota

Assistant Drama Teacher Job at Drama Kids of Manasota

 ...Excellent and thorough training provided.* You will enjoy the pride of being able to witness the fruits of your labor as you see ALL students perform in front of family and friends.* Great job for college student or stay-at-home mom who has availability 6-10 hours a week!

Fair Haven Community Health Care

Remote Medical Billing Coder Job at Fair Haven Community Health Care

 ...We are seeking a Remote Medical Billing Coder to join our Dynamic Team! Job purpose Responsible for...  ...clinical documentation and provide coding support to clinical staff as needed....  ...Qualifications High School diploma or GED with experience in medical billing is required.... 

Healthcare Recruitment Counselors

Physical Medicine and Rehab (PM&R) Physician Hartford, CT Job at Healthcare Recruitment Counselors

Physical Medicine and Rehab (PM&R) OR Pain Management Physician Hartford, CT We are looking for a motivated Physician to join our well-established medical group...  ...interested in outpatient non-surgical orthopedics, sports medicine, and regen medicine. We are looking for... 

HFM Realty Inc

Real Estate Agents Job at HFM Realty Inc

 ...Join HFM Realty Elevate Your Real Estate Career! Are you a motivated real estate professional ready to thrive? HFM Realty, a leading...  ...MA, RI, NH, CT, ME, and NY, is expanding its team of dynamic agents. Whether youre just starting out, a seasoned expert, or a... 

UnitedHealth Group

Medical Coder - National Remote Job at UnitedHealth Group

 ...materials (e.g., on-line sources, manuals) to identify appropriate medical codes and reference code applicability, rules and guidelines+...  ...-P, RHIT, RHIA, CCA, CCS, CCS-P etc.)+ 1+ years of coding experience+ Advanced level of proficiency with ICD-10-CM, CPT, Modifiers...