Position: Senior Snowflake/DBT Data Engineer

Experience – 7 to 10 +

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