Data Engineer- Snowflake

Herndon, VA - USA

Monthly Salary: Not Disclosed

Posted on: 4 days ago

Vacancies: 1 Vacancy

Job Summary

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

Key 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

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

Required Qualifications

13 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

Required Experience:

OverviewOran 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 q...