Oran Inc · 12 hours ago
Data Engineer- Snowflake
Herndon, VA
Full-time
Onsite
Entry Level
1+ years expOran Inc. is seeking a Junior 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.
Cyber SecurityCloud ComputingConsultingIT Management
No H1B
U.S. Citizen Only
Responsibilities
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
Work with Amazon S3 for data ingestion and storage
Understand IAM role basics
Support file processing (CSV, pipe-delimited, fixed-width, GZIP/ZIP)
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
Reconcile Snowflake outputs against legacy SAS datasets
Troubleshoot data discrepancies and load failures
Use Azure DevOps Git for version control
Support deployments across DEV, STG, and PROD
Follow structured branching and folder standards
Qualification
Required
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
Company
Oran Inc
Oran Inc.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase