JobHabor
Menu

DBT+ Snowflake Developer

Artech · Oaks, PA · Onsite

Strong hiring record · median 10 days open

100100

Hiring signal

Actively hiring

Posted today · Never reposted · How we score

First seen
16 November 2026
Reposted
Not since September 2026
All reasons

In its favour

  • Posted today
  • Still listed on the employer's own board
  • Publishes a salary range

Did you apply?

DBT+ Snowflake Developer at Artech. We’ll keep it in your applied jobs, so you can see it later and be warned before applying to the same employer twice.

Job ID: 115962-1

Job Title

DBT+ Snowflake Developer

Location

Oaks, Pennsylvania- 100% ONSITE

Duration

6 months

Pay Rate

$35-$40/hr on W2/C2C

Skills

Digital

Snowflake~ORACLE SQL~Data Build Tool

Experience Required

6-8 Years

Must Have skills

Snowflake and Data Build Tool (DBT)

Strong hands-on experience with dbt (Data Build Tool), preferably dbt Core and/or dbt Cloud

Strong hands-on experience with Snowflake

Advanced SQL skills, including

Complex joins and aggregations

CTEs and nested queries

Window functions

Views and materialized transformations

Query optimization

Experience building ELT data pipelines and transformation frameworks

Strong understanding of data warehousing and dimensional modeling

Experience developing and maintaining

dbt models

Sources

Tests

Macros/Jinja

Seeds

Snapshots where applicable

Documentation and lineage

Experience with Git/version control and software development practices such as branching, pull requests, and code reviews

Understanding of CI/CD for dbt deployments

Strongly Preferred

Hands-on experience with Denodo, particularly

Base and derived views

Join and transformation logic

View dependencies

Data virtualization concepts

VQL

Analysis of downstream dependencies and lineage

Experience migrating from data virtualization to physical/cloud data warehouse models

Snowflake performance optimization including warehouse sizing, query profiling, clustering considerations, and incremental processing

Experience handling large data volumes and complex transformation dependencies

Responsibilities

 Analyze existing Denodo views, dependencies, transformation rules, joins, filters, calculations, and source-system mappings.

Identify reusable transformation logic and dependencies between Denodo views.

Assess views for migration complexity and identify potential functionality that should be redesigned rather than migrated one-to-one.

 Denodo-to-dbt Conversion

Convert Denodo view logic into modular and reusable dbt models.

Design appropriate dbt layers such as

Staging models

Intermediate/transformation models

Business/core models

Data marts

Translate Denodo-specific functionality into appropriate Snowflake SQL/dbt implementations.

Use dbt macros and Jinja appropriately to avoid duplicated transformation logic.

 Snowflake Development

Build and optimize transformation workloads on Snowflake.

Design models using suitable dbt materializations such as views, tables, incremental models, and ephemeral models based on workload requirements.

Optimize SQL and dbt models for performance, scalability, and Snowflake compute consumption.

 Data Reconciliation and Testing

Validate migrated dbt models against existing Denodo outputs.

Perform source-to-target reconciliation including

Record counts

Aggregated values

Null checks

Duplicate checks

Referential integrity

Business-rule validation

Implement automated dbt data-quality tests.

Investigate and resolve differences between Denodo and Snowflake/dbt outputs.

More jobs at Artech

All 385

Similar roles