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

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

Molina Healthcare

Director, Applications (AI/Azure Databricks) - REMOTE Job at Molina Healthcare

...which underpin essential business functions such as HEDIS reporting, Risk Adjustment (RA), and Health Plan Reporting.**+ **_Azure Databricks._**+ **_Python._**+ **_Spark._**+ **_QNXT._****Preferred License, Certification, Association**Microsoft Technology, Mobility...

corbion

Application Consultant IT Job at corbion

...and our planet. The Applications Consultant at Corbion supports and standardizes global... ..., national origin, marital status, political affiliation, age, sex, sexual orientation... .... No placement fees will be paid to any firm unless such a request has been made by the...

MMS Manufacturing

Concrete Quality Inspector Job at MMS Manufacturing

...This role involves performing concrete testing, monitoring curing conditions, and verifying compliance with specifications. Responsibilities... ...nonconforming products for engineering review. Verify that repairs on red-tagged items meet engineering specifications before...

Worldwide Holdings Group

Event Assistant Job at Worldwide Holdings Group

Attend to assist a one-time offline event hosted in Shenzhen in person, needs to provide documents for pre-event evaluation, and must show up on time to assist the event.

Hire it People, Inc

Business Systems Analyst Job at Hire it People, Inc

Job Seekers, Please send resumes to ****@*****.*** Job Duties: Design, configure, & maintain IAM tools, managing AEM, enterprise service platforms, GWT, SailPoint IIQ, Java/J2EE, XML/XHTML, JSF, SOAP, SQL/Oracle, REST APIs. Troubleshoot IAM issues, optimize...