Oran Inc

Support migration of legacy ETL processes to Snowflake on AWS, develop ingestion frameworks, and ensure data quality. | Requires 1-3 years of data engineering experience, strong SQL skills, and familiarity with Snowflake and AWS S3. | 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 • 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 • **must be an USC Preferred • Experience migrating legacy ETL (SAS, Informatica) • Snowflake Tasks, Streams, and Stored Procedures • AWS Glue familiarity • Exposure to CI/CD and data quality frameworks