Senior Snowflake Data Engineer: ELT & dbt Architect

VettedBench; United States; Remote; USD 130,000 - 170,000; Full time

Job summary

VettedBench seeks an experienced Senior Snowflake/dbt Data Engineer to modernize an enterprise data platform. You will migrate legacy SAP BODS, SQL, and Informatica workloads into Snowflake and dbt, building scalable ELT pipelines and adhering to enterprise standards.

You will design modular dbt models, optimize warehouse performance, and drive migration validation with onshore leads, contributing to architecture alignment and robust data lineage.

Qualifications

• 7+ years of data engineering experience.
• 3+ years of Snowflake experience.
• Strong dbt development experience.
• Advanced SQL and data warehouse concepts.
• Experience with Git, CI/CD, and Agile methodologies.

Responsibilities

• Develop dbt models for staging, intermediate, ODS, and consumption layers.
• Convert legacy SQL, SAP BODS, and IICS transformation logic into dbt models.
• Design modular and reusable dbt macros and transformation frameworks.
• Optimize Snowflake SQL performance and warehouse utilization.
• Implement data transformation best practices using ELT architecture.
• Create technical documentation, lineage, and source-to-target mappings.
• Participate in code reviews and deployment activities.
• Support migration validation and reconciliation.
• Work closely with onshore technical leads to ensure alignment with enterprise architecture standards.

Skills

Data Engineering

Snowflake

dbt

SQL

Data Warehouse

Performance Tuning

Git

CI/CD

Agile

Tools

Azure

AWS

Python

Snowflake

dbt

Job description

VettedBench seeks an experienced Senior Snowflake/dbt Data Engineer to modernize an enterprise data platform. You will migrate legacy SAP BODS, SQL, and Informatica workloads into Snowflake and dbt, building scalable ELT pipelines and adhering to enterprise standards.

You will design modular dbt models, optimize warehouse performance, and drive migration validation with onshore leads, contributing to architecture alignment and robust data lineage.