**********USC or GC due to Federal and Clearance requirement
Overview
Oran Inc. is seeking a Senior Snowflake Data Engineer to support a federal data modernization initiative. This role focuses on migrating legacy SAS ETL processes into a Snowflake ELT architecture on AWS. You will collaborate with senior engineers to develop ingestion frameworks, ensure data quality, and support production environments.
Snowflake Development
Develop and maintain tables (RAW, TARGET), views, stored procedures, tasks, and streams
Implement COPY INTO for file ingestion
Support incremental and historical data loads
Assist with schema validation and evolution
AWS & Data Integration
Work with Amazon S3 for data ingestion and storage
Understand IAM role basics
Support file processing (CSV, pipe-delimited, fixed-width, GZIP/ZIP)
Data Engineering & ELT
Load and transform data across Bronze (RAW), Silver, and Gold layers
Perform data validation (row counts, duplicates, schema checks)
Support metadata tracking and run documentation
Data Quality & Support
Reconcile Snowflake outputs against legacy SAS datasets
Troubleshoot data discrepancies and load failures
DevOps & Deployment
Use Azure DevOps Git for version control
Support deployments across DEV, STG, and PROD
Follow structured branching and folder standards
1–3 years of data engineering or ETL experience
Strong SQL skills (joins, aggregations, window functions)
Experience with Snowflake or similar cloud data warehouse
Experience with AWS S3
Understanding of incremental load concepts and relational modeling
Preferred
Experience migrating legacy ETL (SAS, Informatica)
Snowflake Tasks, Streams, and Stored Procedures
AWS Glue familiarity
Exposure to CI/CD and data quality frameworks