Senior Snowflake/DBT Data Engineer

Senior Snowflake/DBT Data Engineer
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

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.