Senior Data Engineer - Snowflake/Data Build Tool

Position Overview :

We are seeking an experienced Snowflake/dbt Data Engineer to support a large-scale enterprise data modernization initiative involving migration of 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.

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.

Required Skills & Experience :

- 8 years of Data Engineering experience

- 5+ years of Snowflake

- Strong dbt development experience

- Advanced SQL

- Data Warehouse concepts

- Performance tuning

- Git

- CI/CD

- Agile

Mandatory Skills :

- SAP BODS migration experience

- Informatica IICS

- Insurance domain

- Guidewire data model

- Python

- Azure/AWS