Data Engineer- Snowflake

Oran•Herndon, VA

21h

About The Position

Oran 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. You will collaborate with senior engineers to develop ingestion frameworks, ensure data quality, and support production environments.

Requirements

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

Nice To Haves

Experience migrating legacy ETL (SAS, Informatica)
Snowflake Tasks, Streams, and Stored Procedures
AWS Glue familiarity
Exposure to CI/CD and data quality frameworks

Responsibilities

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
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