Senior Snowflake/DBT Data Engineer

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

Position Overview:

We are seeking an experienced Senior Snowflake/dbt Data Engineer to support a large-scale enterprise data modernization initiative. The role involves migrating legacy SAP BODS, SQL, and Informatica IICS workloads into a modern Snowflake and dbt architecture. The engineer will work closely with onshore technical leads to develop scalable, high-performance data pipelines while adhering to enterprise architecture standards. This is an immediate position requiring strong hands-on expertise in Snowflake, dbt, and advanced SQL, with a focus on ELT architecture, data transformation best practices, and migration validation.

Key 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

Required Skills:

• 7+ years of Data Engineering experience
• 3+ years of Snowflake experience
• Strong dbt development experience
• Advanced SQL
• Data Warehouse concepts
• Performance tuning
• Git
• CI/CD
• Agile methodology

Preferred (Bonus) Skills:

• SAP BODS migration experience
• Informatica IICS
• Insurance domain knowledge
• Guidewire data model
• Python
• Azure
• AWS

Note: Linkedin and personal contact details required