Data Engineer DBT (Snowflake)

Position: Data Engineer DBT (Snowflake)

Purpose of the Position: This role seeks candidate who are passionate about data transformation and motivated to support enterprise-scale data modernisation initiatives. You will play a key role in assisting client in migration legacy ETL pipeline into dbt on Snowflake by developing scalable transformation models, improving data reliability, and ensuring consistency across analytical platform. The position contributes directly to enable modern ETL architecture that support business intelligence reporting and advanced analytical use cases.

Location: Pune/ Bangalore/Chennai/ Nagpur

Key Result Areas and Activities:

• Code conversion, refinement and optimization – Convert SSIS transformations into dbt staging/intermediate/mart models, review and validate tool converted dbt transformations to ensure accuracy maintainability alignment with enterprise modelling standards.

• Data validation and reconciliation - Perform source-to-target validation, row-level and column-level reconciliation and regression testing to ensure transformation accuracy during migration cycles.

• Incremental pipeline implementation - Implement incremental loading strategies, snapshots and dependency-aware model execution to support efficient and scalable transformation workflows.

• Documentation and lineage support - Maintain transformation documentation, mapping logic, testing evidence, and lineage metadata to support governance and audit readiness.

• Collaboration & Delivery Support - Work closely with Snowflake engineers, QA team and client stakeholders to resolve transformation discrepancies and ensure timely migration delivery

• ETL/ELT Development & Integration – Build and maintain ETL/ELT workflows using Snowflake-native features or external tools (DBT, Airflow).