Back to search

DBT+ Snowflake Developer

Lead the conversion of Denodo views to dbt models and develop Snowflake-based data pipelines.

  • Oaks, Pennsylvania, United States
  • Contract
  • On-site
  • $35–$40 per hour
  • Posted Nov 16, 2026
INDUSTRYSoftware & InternetSaaS & Enterprise Software

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
  • Convert Denodo view logic into modular and reusable dbt models
  • Design appropriate dbt layers such as staging, intermediate, business/core models, and data marts
  • Translate Denodo-specific functionality into Snowflake SQL/dbt implementations
  • Build and optimize transformation workloads on Snowflake
  • Design models using suitable dbt materializations such
  • Optimize SQL and dbt models for performance, scalability, and Snowflake compute consumption
  • 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

Requirements

Nice to have: Denodo, Denodo Base and derived views, Denodo join and transformation logic, Denodo view dependencies, Denodo data virtualization concepts, VQL, Denodo performance optimization, Denodo migration to cloud data warehouse, Snowflake performance optimization, warehouse sizing, query profiling, clustering, incremental processing, large data volumes, complex transformation dependencies

Skills

SnowflakeData Build Tool (dbt)SQLCTEsnested querieswindow functionsviewsmaterialized transformationsquery optimizationELT data pipelinesdata warehousingdimensional modelingGitversion controlCI/CDdbt modelsdbt macrosJinjadbt testsdbt snapshotsdbt documentationdbt lineageSnowflakedbtSQLGitCI/CD

More jobs nearby

Full description

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.

DBT+ Snowflake Developer at Artech LLC | Referso Jobs