Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Engineer - Snowflake & DBT

$96.3k - $154.4k

Kapitus

Data Engineer Kapitus is building a next-generation enterprise data and AI capability for our financial services organization. This is a multi-year modernization program that replaces hundreds of legacy analytics workflows with governed, reusable business data products on a modern cloud data platform, stands up an AI/ML platform, and moves the organization from producing reports to producing decisions. We are hiring Data Engineers to build that platform and the products on it. The core stack is Snowflake and dbt, organized around a layered medallion architecture bronze/silver/gold-style layers extended with governed conformed entities, certified semantic definitions, and reusable serving structures. You will build ingestion and transformation pipelines, model data across layers, migrate legacy workflows onto the platform, and ship data products through evidence-based acceptance gates. You report to the Director of Data Engineering, who owns the platform architecture and engineering standards. This is a delivery role on a program that runs to tight timelines and real acceptance criteria: your work is done when it is validated, evidenced, and accepted code complete is not product complete. You will work alongside internal engineers and consulting-partner teams across onshore and offshore locations, all held to the same engineering bar. Senior Data Engineers additionally own complex workstreams or product slices, lead technical design within the approved architecture, review other engineers' work, mentor team members, and drive difficult migrations or production issues to closure. What you will do: Develop ELT pipelines on Snowflake and dbt: source ingestion, layered transformations through the medallion zones, and governed serving structures for BI, API, ML, and AI consumption. Model data within the platform's layered architecture — staging, conformed core entities, dimensional and product-level models — following approved modeling standards for grain, keys, and naming. Implement approved data contracts, conformed entity definitions, keys, relationships, and certified semantic definitions consistently across models; do not create local definitions when a governed one exists. Migrate legacy analytics workflows (e.g., Alteryx) onto the modern stack: analyze the existing logic, implement it correctly in dbt and Snowflake, prove parity where required, and support retirement of the legacy asset. Implement data quality as code: dbt tests, source freshness checks, reconciliation and validation queries, and pipeline observability — quality controls ship with the pipeline, not after it. Build for reuse: contribute to shared ingestion frameworks, certified transformation patterns, and common serving structures rather than one-off solutions. Engineer Work software-engineering style: Git-based workflows, peer code review, CI/CD, environment promotion, and documentation that lets someone else operate what you built. Follow and help improve the platform's engineering standards — repository structure, dbt project conventions, testing requirements, and performance and cost discipline (warehouse sizing, query efficiency, clustering choices). Tune what you ship: profile query performance, manage Snowflake compute cost consciously, and treat efficiency as part of correctness. Support what you ship in production: use observability to diagnose failures, participate in incident and root-cause analysis, implement durable corrective actions, and prevent recurring defects rather than repeatedly patching symptoms. Surface risks and ambiguity early — resolving a problem before build is cheaper than discovering it during validation or production. Deliver Deliver against the program's acceptance gates: build to approved designs and acceptance criteria, produce developer verification evidence for your work, and support independent acceptance validation — engineers test their own work thoroughly but do not independently approve it for acceptance. Work from design specifications and data contracts; when a specification is ambiguous or wrong, raise it and get it resolved rather than improvising silently. Collaborate across a distributed team — internal and partner engineers, onshore and offshore — with clean handoffs, clear written communication, and deliberate use of overlap hours. Estimate your work honestly, flag variance early, and close defects from validation findings promptly and with root cause understood. What we're looking for: 5+ years of hands-on data engineering experience building production data pipelines and warehouse models. Senior-level candidates (8+ years) are considered for Senior Data Engineer and should demonstrate workstream-level technical leadership, design ownership, code-review responsibility, and mentoring — not simply additional years of experience. Strong hands-on Snowflake experience including warehouse and database objects, performance and cost-aware SQL, role-based access concepts, tasks/streams or equivalent patterns, and loading/unloading at production scale. Production dbt experience building and maintaining real dbt projects: layered model organization, incremental models, tests and documentation, macros, and working in a shared multi-developer project with CI. Expert SQL skills complex transformations, window functions, performance tuning, and the judgment to know when SQL is the wrong tool. Solid Python experience for data engineering ingestion utilities, API integrations, automation, and orchestration code. Layered/medallion architecture experience. You have built in a bronze/silver/gold or equivalent layered warehouse and understand why layer discipline, grain, and conformed entities matter; experience with governed variants incorporating conformed/core entity models, certified metrics, semantic definitions, or data contracts is a strong plus. Engineering fundamentals Git, code review, CI/CD, environment promotion, and automated testing as normal practice, not aspiration. Data quality and verification mindset you are someone who thoroughly tests and reconciles your own work and produces complete verification evidence that a pipeline is correct; formal acceptance validation is performed independently. Clear written communication for design notes, pull request descriptions, and documentation that hold up across time zones. Additional Qualifications: Experience migrating legacy analytics workloads (Alteryx, SSIS, SAS, stored-procedure estates, or similar) to a modern cloud stack, including parity testing against the legacy output. Experience in financial services, lending, banking, fintech, or another regulated environment including working with sensitive data classifications and audit expectations. Consulting or client-facing delivery experience. You have built under tight timelines and contractual acceptance criteria, and are comfortable with milestone-driven delivery. Orchestration experience (Airflow, Dagster, or similar), CDC/ingestion tooling, and streaming or near-real-time patterns. Exposure to data catalogs and lineage tooling, semantic/BI layers (e.g., Tableau, Sigma, or similar), and ML/AI data needs — feature pipelines, training datasets, retrieval foundations. SnowPro or dbt certifications — valued as evidence of rigor, not as a substitute for demonstrated delivery experience. Kapitus Total Rewards Package Includes: Competitive Base Salary Range of $96,300-$154,400. Kapitus is providing this as a good faith salary range to comply with applicable law. The applicant's final salary will depend on a number of factors including the applicant's geographic location, skills, and experience. Annual Incentive Compensation Eligibility – Up to 10% annually Health Insurance: Comprehensive medical, dental, and employer-paid vision plans through UnitedHealthcare (UHC), with various coverage levels available to meet the needs of our employees and their families. Additional perks through UHC include: Sweat Equity, free subscription to the Calm App, UHC rewards, Real Appeal, and Quit For Life. Flexible Spending Account: Set aside pre-tax dollars from your paycheck to pay for qualified out-of-pocket medical, dental, vision, pharmacy or dependent care expenses. Lifestyle Spending Account: Employer sponsored post-tax benefits that allow reimbursement for expenses related to physical, mental and financial well-being. 100% Company Paid Insurances: Kapitus fully covers the cost of basic short-term and long-term disability insurance, as well as vision insurance, ensuring our employees have comprehensive protection without any personal expense. Voluntary Insurance: Supplemental life insurance as well as enhanced short- and long-term disability coverage are available through Mutual of Omaha, providing additional security for our employees. Additionally, Colonial Accident and Hospitalization insurances are also available, offering further protection against unforeseen events. Paid Maternity and Parental Leave: Beyond state-mandated leave policies, Kapitus provides company-paid maternity and parental leave, supporting our employees during important family milestones. Commuter Benefits: We offer pre-tax benefits on parking and commuter expenses to cover travel to and from work. LifeBalance Program: Enhance your lifestyle with our LifeBalance Kapitus

Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Data Engineer - Snowflake & DBT in New York, NY vacancy
  • Tektend LLC is seeking a Senior Data Platform Engineer to design, scale, and optimize our modern enterprise data platform based in New York...  ...pipelines, evolving our analytical data models using Snowflake and dbt, and driving engineering excellence across the organization... 
    Suggested
    Contract work
    Work at office

    Tektend LLC

    New York, NY
    16 days ago
  •  ...Job-ID: 21585Category: Data ManagementLocation: New York, United StatesWorkplace: HybridPosted...  ...026-11-05Experience (In Years): 0-3Data Engineer – Modern Data PlatformRole OverviewWe...  ...with strong expertise in Fivetran, dbt, Snowflake, and modern cloud data engineering... 
    Suggested

    EXL Service

    New York, NY
    2 days ago
  • $150k - $200k

     ...I’m working on a Data Engineering opportunity at a global macro hedge fund in NYC, where you’ll...  ...countries. The big focus? Python, SQL & Snowflake. You’ll work with vendor feeds,...  ...areas: Python & SQL Snowflake dbt Data pipelines & automation... 
    Suggested
    Full time
    Work at office
    Remote work

    Saragossa

    New York, NY
    3 days ago
  • Data Engineer II - Snowflake The ideal candidate is a strong hands-on engineer who can independently diagnose issues, identify root causes, and support...  ..., version control, and CI/CD practices. Experience with dbt for data transformation and pipeline development.... 
    Suggested
    Remote work
    Day shift

    Apex Systems

    New York, NY
    3 days ago
  • Snowflake Data Platform Manager This is a remote role that may only be hired in the following...  ...role will help drive modernization and engineering acceleration through the application of...  ...dashboards, data pipelines integrated with AWS, DBT, observability tools through CICD... 
    Suggested
    Remote job

    Arizona Staffing

    New York, NY
    1 day ago
  • $129.6k - $213.8k

    Travelers Data Engineer Opportunity Taking care of our customers, our communities and each other...  ...ETL pipelines using tools such as AWS, dbt or any other ETL tool Understanding of...  ...Experience with data modeling techniques (star/snowflake schema) and data warehouse design... 
    Local area

    Travelers

    New York, NY
    1 day ago
  • $52 - $60 per hour

    Data Engineer (Snowflake, Python, AI/ML Data Pipelines) Dallas, Texas 100% Remote Contract $52/hr - $60/hr A leading wealth management technology...  ...to build modern data solutions leveraging Snowflake, Python, dbt, Airflow, and AI/ML technologies that support enterprise-... 
    Full time
    Contract work
    Temporary work
    Remote work
    Relocation
    Flexible hours

    Motion Recruitment

    New York, NY
    3 days ago
  • Data Engineering & Operations Specialist We have a fast-growing team of dedicated consultants with...  .... Additionally, expertise in Snowflake is required to ensure efficient and scalable...  ...experience in Snowflake, and expertise in DBT. Proficiency in Qlik Replicate, Compose... 

    Alpha Fmc

    New York, NY
    3 days ago
  • Senior Data Engineer We are seeking a seasoned Senior Data Engineer to lead the integration of Snowflake with Salesforce Health Cloud enabling scalable, real-time data exchange and analytics...  ..., Excelys, and Amisys structures Leverage DBT for transformation workflows and... 

    Argyle Infotech

    New York, NY
    3 days ago
  • $130k - $135k

     ...Immediate need for a talented Snowflake Data Engineer. This is a Fulltime opportunity with long-term potential and is located in New York City, NY(Onsite). Please review the job description below and contact me ASAP if you are interested. Job ID: 26-35391... 
    Full time
    Local area
    Immediate start

    Pyramid Consulting, Inc

    New York, NY
    9 days ago
  • Lead Alteryx Snowflake Data Engineer Top Skills' Details need Senior experience with Alteryx and Snowflake data engineering as this is a Fortune 100 customer we are evaluating and rebuilding 10 Alteryx flows for Snowflake. Donato Technologies Inc

    Donato Technologies Inc

    New York, NY
    2 days ago
  • Senior Lead Data Engineer We are seeking a senior Lead Data Engineer for a fully onsite contract engagement in New York, NY with a global...  ..., and delivery of production-grade data platforms in Snowflake, from ingestion through transformation, modeling, and consumption... 
    Contract work

    Elios Talent

    New York, NY
    3 days ago
  • Data Engineer Remote Until Covid 12 Months Job Description Experience in crafting re-useable data model for various Business Intelligence...  ...for the calculated columns and measures using SQL queries on Snowflake (AWS) and python. Experience in working with AWS, MS Azure or... 
    Local area
    Remote work
    Flexible hours

    Samprasoft

    New York, NY
    3 days ago
  • Data Engineer (ADF & Snowflake) Location: Remote Duration: Long term Required Skills & Qualifications Strong hands-on experience with Azure Data Factory (ADF). Strong experience working with Snowflake (data modeling, performance tuning, clustering, tasks, streams). Advanced... 
    Local area
    Remote work

    E-Solutions

    New York, NY
    3 days ago
  • Sr. Snowflake Data Engineer 100% Remote $60/Hr C2C 2 virtual rounds of interview Job Description The Senior Snowflake Data Engineer is responsible for implementing scalable data transformation logic, curated datasets, semantic-supporting structures, and production-ready... 
    Remote work

    Anveta

    New York, NY
    3 days ago
  • Application Developer - SLDS Data Engineer The Data Engineer is responsible for realizing the vision of the Data Architect through the technical implementation of data pipelines using Snowflake and Informatica. Data Engineers are technical coding experts focused on moving... 

    Mavensoft Technologies

    New York, NY
    1 day ago
  • Sr Data Engineer With Databricks & Dbt Design, develop, and maintain data pipelines using Azure Databricks and implement data transformations using dbt (data build tool). Collaborate with data engineers, analysts, and stakeholders to deliver clean, reliable, and well-documented... 

    United IT

    New York, NY
    3 days ago
  •  ...Technical Recruiter at STI Org. I am reaching out to you on an exciting job opportunity with one of our clients. Position SNOWFLAKE/AWS DATA ENGINEER Contract C Requirements Snowflake implementation experience Snowpipe experience Python or Scala SQL AWS (look for Glue,... 
    Remote job
    Contract work

    Software Technology Inc

    New York, NY
    3 days ago
  •  ...institution is seeking a hands-on Lead Data Engineer to design and deliver scalable enterprise...  ...initiative. The engineer will work with Snowflake and Databricks, build production data...  ...platform migrations and modernization. dbt or semantic modeling. Medallion... 
    Full time

    Madison-Davis, LLC

    New York, NY
    2 days ago
  •  ...The Role To build the data foundation that powers Stuut's intelligence...  ...closely with our product and engineering teams to transform raw...  ...warehouses; experience with Snowflake or BigQuery is a plus Have...  ...workflows at scale using tools like dbt, Airflow, or similar — and... 
    Full time
    Flexible hours

    Stuut

    New York, NY
    4 days ago
  •  ...Job Description Job Description Title: Snowflake Data Engineer – Platform Optimization Location: New York, NY Work Arrangement: Remote...  ...strategies across databases, warehouses, pipelines, and dbt workloads Review platform incidents and workload failures... 
    Contract work
    Local area
    Remote work

    Expert In Recruitment Solutions

    New York, NY
    26 days ago
  •  ...Role Overview The Senior Data Engineer is responsible for overseeing enterprise data platform...  ...managing cloud data warehouses such as Snowflake, Redshift, or similar at scale. ~...  ...frameworks including Fivetran, HVR, Matillion, dbt, Apache Coalesce, and Postman. ~... 
    Full time

    The Phoenix Group

    New York, NY
    2 days ago
  •  ...Semarchy Engineer Location: New York, NY Work Model: Hybrid – 3 days onsite per...  ...Semarchy Engineer to join our Client Master Data team. This person will serve as the...  ...modern data technologies such as Snowflake, Azure, ADF, dbt, Fivetran, Python, APIs, or comparable... 
    Full time
    Work at office
    3 days per week

    Tiger Advisory

    New York, NY
    4 days ago
  • $175k - $240k

     ...investment management firm seeking a Senior Data Engineer to help modernize and transform its...  ...engineering role for someone with deep Snowflake, Python, and SQL experience who has built...  ...ExperienceStrong Microsoft SQL Server backgroundStrong dbt experienceExperience with Azure, Azure... 
    Remote work

    Solomon Page

    New York, NY
    1 day ago
  •  ...we co-create custom software, data, AI, and cloud solutions with...  ....Our Data Architecture & Engineering team sees data as the foundation...  ...Platform (GCP), Databricks, and Snowflake, along with the technologies...  ...Spark, Kafka, Airflow, dbt, Dagster, Azure Data Factory,... 
    Temporary work
    Work at office
    Local area

    Slalom

    New York, NY
    1 day ago
  • Job Title: Data Engineer Location: NYC, NY Job Description We are seeking an experienced professional with strong expertise in Snowflake, Python, Oracle PL/SQL, and reporting/BI tools to deliver...  ...Technical: Snowflake, Oracle Pl/SQL, DBT, Python, any BI reporting tool... 
    Work at office
    3 days per week

    Apptad

    New York, NY
    3 days ago
  • $108.8k - $136k

    Data Engineer II Join our mission to transform pharmacy benefits and healthcare navigation as a Data Engineer II (Analytics Engineer). You will build and maintain reliable data models within Snowflake with dbt, and improve data quality and observability. Partner with analysts... 
    Local area
    Flexible hours

    Judi Health

    New York, NY
    3 days ago
  • $135k - $175k

     ...design and implementation of scalable data infrastructure, pipelines and...  ...code quality, reliability, and engineering best practices across the data stack...  ...including cloud data warehouses (Snowflake, BigQuery), transformation frameworks (dbt), orchestration platforms (... 
    Remote work

    Rhino

    New York, NY
    3 days ago
  • $180k - $200k

    Position Summary We are seeking a highly experienced, hands-on Data Engineering Lead to design, develop, and own end-to-end enterprise data...  ...expertise in modern data engineering, particularly Snowflake, dbt, Python, SQL, and orchestration frameworks, along with the... 
    Work at office

    Carlyle

    New York, NY
    3 days ago
  • $200k - $250k

     ...across the United States to help them hire. Data Engineer Location - New York, NY (On-site) - On-...  ...customer datasets Work with Snowflake and cloud-based lakehouse infrastructure...  ...pipelines using tools such as Dagster and dbt Design reliable data workflows that maintain... 
    Work at office
    Remote work
    Visa sponsorship

    Recruiting from Scratch

    New York, NY
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Engineer - Snowflake & DBT. Be the first to apply!