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
Never miss an opportunity! Create an alert based on the job you applied for.
