Snowflake Data Engineer

Oraapps Inc

New York, NY, United States

11 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Java (Programming Language) Airflow Amazon S3 Cloud Storage Data Validation Data Deduplication Information Engineering Extract Transform Load (ETL) Data Stores Java Database Connectivity Reference Data SQL Stored Procedures

+5 more

SQL Databases Systems Integration Workflow Management Systems Snowflake Data Pipelines

Requirements

· Snowflake Data Engineering - Hands-on experience designing and implementing data pipelines using Snowflake features including Streams, Tasks, Dynamic Tables, and Snowpipe for automated ingestion and incremental processing.

· SQL & Java Integration - Strong proficiency in complex SQL (window functions, CTEs, merge statements) and experience integrating Java-based ETL/ELT logic with Snowflake via JDBC or Snowflake connectors; familiarity with stored procedures and Snowpark is a plus.

· Data Curation & Modeling - Demonstrated experience building multi-layer lake architectures (raw * curated * consumption zones) with data quality checks, deduplication, and schema evolution handling for high-volume transactional datasets.

· Financial Domain Data - Prior exposure to financial data domains such as payment transactions, SWIFT messaging (MT/MX formats), customer inquiry records, or bank/client reference data; understanding of data sensitivity, masking, and compliance requirements.

· Datastore & Orchestration - Experience integrating Snowflake pipelines with external datastores (e.g., GCS, S3, Azure Blob, or relational DBs) and orchestration tools (e.g., Apache Airflow, dbt, or equivalent) for end-to-end pipeline scheduling