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
More jobs nearby
Full description
Artech LLC
Company details are for members
Sign up for a free job alert to see Artech LLC's profile, website and LinkedIn, and the same for every employer on Referso Jobs.