
DBT+ Snowflake Developer
Artech · Oaks, PA · Onsite
Strong hiring record · median 10 days open
- 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
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.
Skills
More jobs at Artech
All 385- Application Architect IIIArtech · Jersey City, NJtoday
- Salesforce Developer Contractor: 6-9 years (Advanced)Artech · Dallas, TXtoday
- Information Security Analyst SeniorArtech · McLean, VAtoday
- Hardware Test Engineer - XR CalibrationArtech · San Diego, CAtoday
- Hiring Senior Database & Application Support Engineer in Toronto, ONArtech · Toronto, ONtoday
Similar roles
- Snowflake Lead DeveloperArtech · Milpitas, CA14d ago
- Snowflake Lead DeveloperDiverse Lynx · Milpitas, CA · USD 50–55/hr11d ago
- Snowflake DeveloperPyramid Consulting · Columbus, OH · USD 9–69/hr21d ago
- Snowflake DeveloperBright Vision Technologies · Frisco / North Dallas, TX · USD 115,000–165,000/yr10d ago
- Full Stack Developer (React + Angular + .NET + Snowflake)PeopleNTech · Santa Clara, CA · USD 60–65/hr24d ago
- Business Intelligence (BI) Analyst / DeveloperDairy Farmers of America · Kansas City, KS, United States2d ago