Snowflake Data Engineer

Job Title – Snowflake Data Engineer

Contract – 12+ Months

Location – NYC

Onsite - Monday to Friday 

Note - This is a W-2 position, and we welcome candidates requiring H-1B transfer sponsorship to apply. No third-party vendors.

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