Data Engineer- Snowflake jobs in United States
cer-icon
Apply on Employer Site
company-logo

Oran Inc · 9 hours ago

Data Engineer- Snowflake

positionUnited States
timeFull-time
remoteRemote
seniorityEntry Level
date1+ years exp

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, collaborating with senior engineers to develop ingestion frameworks and ensure data quality.

Cyber SecurityCloud ComputingConsultingIT Management
check
H1B Sponsor Likelynote

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

SnowflakeSQLAWS S3ETL experienceData modelingCI/CD exposureData quality frameworksSAS experienceInformatica experienceAWS Glue familiarity

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

twittertwittertwitter
company-logo
Oran Inc.
dateFounded in 2004
location
Herndon, Virginia, USA
people-size51-200 employees
web-link
https://www.oraninc.com

H1B Sponsorship

Oran Inc has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (3)
2022 (2)
2021 (2)
2020 (6)

Funding

Current Stage
Growth Stage
Company data provided by crunchbase