{"schemaVersion":"jobsearcher.job.v1","id":"613dbc2a2f0943bbfb0b5985","url":"https://jobsearcher.com/jobs/613dbc2a2f0943bbfb0b5985","canonicalUrl":"https://jobsearcher.com/jobs/613dbc2a2f0943bbfb0b5985","title":"Snowflake Data Engineer","description":"Snowflake Data EngineerLocation: NYC, NYRole type: FulltimeRole Overview: Build and scale cloud data products on Snowflake supporting institutional trading, risk, and regulatory reporting. This is a hands-on build role — you will own pipelines end-to-end from ingestion through curated, governed consumption layers used by front-office, risk, and control functions.Key ResponsibilitiesDesign, develop, and optimize Snowflake data models (staging ? integration ? semantic/consumption layers) for institutional trade, position, reference, and market ingestion pipelines using Snowpipe / Snowpipe Streaming, Streams & Tasks, Dynamic Tables, and external stages against S3.Develop transformation logic in SQL and dbt with version control, CI/CD, and automated testing.Tune performance and cost: warehouse right-sizing, clustering keys, micro-partition pruning, query profiling, result caching, resource monitors, and credit-consumption reporting.Implement data security and entitlements: RBAC hierarchy, dynamic data masking, row access policies, secure views, and secure data sharing across LOBs.Migrate legacy Oracle / Teradata / Sybase / Hadoop workloads to Snowflake, including reconciliation and parallel-run with data governance on lineage, cataloging, data quality rules, and audit/regulatory evidence.Support production: incident triage, root-cause analysis, SLA adherence, and on-call rotation for critical batch cycles.Work in Agile squads with Client, QA, and platform engineering; participate in design reviews and code reviews.Required Qualifications7+ years in data engineering; 4+ years hands-on Snowflake in a production environment.Expert SQL — window functions, CTEs, complex joins, query optimization, execution plan analysis.dbt (Core or Cloud) — models, macros, snapshots, tests, exposures.Orchestration: Airflow, Control-M, or Autosys.AWS: S3, IAM, Glue, Lambda, Secrets Manager.CI/CD and IaC: Git, Jenkins/GitHub Actions, Terraform or Schema change for Snowflake object deployment.Dimensional and Data Vault modeling; slowly changing dimensions; late-arriving data handling.Demonstrated Snowflake cost-governance ownership (not just development).Preferred / Differentiators:SnowPro Core / Advanced Data Engineer tier-1 investment bank or large financial-services experience.","company":"Reuben Cooley","rawCompany":"reuben cooley","city":"Brooklyn","state":"NY","isRemote":false,"isActive":true,"createdAt":"2026-09-11T07:29:45.284Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Snowflake Data Engineer","description":"Snowflake Data EngineerLocation: NYC, NYRole type: FulltimeRole Overview: Build and scale cloud data products on Snowflake supporting institutional trading, risk, and regulatory reporting. This is a hands-on build role — you will own pipelines end-to-end from ingestion through curated, governed consumption layers used by front-office, risk, and control functions.Key ResponsibilitiesDesign, develop, and optimize Snowflake data models (staging ? integration ? semantic/consumption layers) for institutional trade, position, reference, and market ingestion pipelines using Snowpipe / Snowpipe Streaming, Streams & Tasks, Dynamic Tables, and external stages against S3.Develop transformation logic in SQL and dbt with version control, CI/CD, and automated testing.Tune performance and cost: warehouse right-sizing, clustering keys, micro-partition pruning, query profiling, result caching, resource monitors, and credit-consumption reporting.Implement data security and entitlements: RBAC hierarchy, dynamic data masking, row access policies, secure views, and secure data sharing across LOBs.Migrate legacy Oracle / Teradata / Sybase / Hadoop workloads to Snowflake, including reconciliation and parallel-run with data governance on lineage, cataloging, data quality rules, and audit/regulatory evidence.Support production: incident triage, root-cause analysis, SLA adherence, and on-call rotation for critical batch cycles.Work in Agile squads with Client, QA, and platform engineering; participate in design reviews and code reviews.Required Qualifications7+ years in data engineering; 4+ years hands-on Snowflake in a production environment.Expert SQL — window functions, CTEs, complex joins, query optimization, execution plan analysis.dbt (Core or Cloud) — models, macros, snapshots, tests, exposures.Orchestration: Airflow, Control-M, or Autosys.AWS: S3, IAM, Glue, Lambda, Secrets Manager.CI/CD and IaC: Git, Jenkins/GitHub Actions, Terraform or Schema change for Snowflake object deployment.Dimensional and Data Vault modeling; slowly changing dimensions; late-arriving data handling.Demonstrated Snowflake cost-governance ownership (not just development).Preferred / Differentiators:SnowPro Core / Advanced Data Engineer tier-1 investment bank or large financial-services experience.","datePosted":"2026-09-11T07:29:45.284Z","dateModified":"2026-09-11T07:29:45.284Z","hiringOrganization":{"@type":"Organization","name":"Reuben Cooley","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Brooklyn","addressRegion":"NY","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"613dbc2a2f0943bbfb0b5985"},"url":"https://jobsearcher.com/jobs/613dbc2a2f0943bbfb0b5985"}}