Ora Apps Inc.
Snowflake Data Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Snowflake Data Engineer in NYC (Hybrid) with a contract length of "unknown." The pay rate is "unknown." Key skills include Snowflake data engineering, SQL, Java integration, data curation, and financial domain experience.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
August 11, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Hybrid
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
New York City Metropolitan Area
-
🧠 - Skills detailed
#SnowPipe #Java #SQL (Structured Query Language) #dbt (data build tool) #Snowpark #"ETL (Extract #Transform #Load)" #Datasets #Data Engineering #S3 (Amazon Simple Storage Service) #Compliance #JDBC (Java Database Connectivity) #Data Quality #Snowflake #Data Pipeline #Apache Airflow #Airflow #Azure
Role description
Job Title: Snowflake Data Engineer
Location: NYC, New York -Hybrid
Note - This is a W-2 position, and we welcome candidates requiring H-1B transfer sponsorship to apply. No third-party vendors.
W2 Benefits - Health Insurance (Medical, Dental, Vision), Employee 401 k Contributions, HSA and other Benefits.
Requirement
· 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
Job Title: Snowflake Data Engineer
Location: NYC, New York -Hybrid
Note - This is a W-2 position, and we welcome candidates requiring H-1B transfer sponsorship to apply. No third-party vendors.
W2 Benefits - Health Insurance (Medical, Dental, Vision), Employee 401 k Contributions, HSA and other Benefits.
Requirement
· 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
