DATA ENGINEER ROLE

Job Description – Senior Data Engineer (Snowflake | Azure | dbt)

Position Details

Job Title: Senior Data Engineer
Experience: 7+ Years
Location: Noida / Bangalore / Hyderabad / Pune / Chennai / Coimbatore (Any)

Role Overview

We are looking for an experienced Senior Data Engineer to join our team and support the modernization of enterprise data platforms. The ideal candidate will have strong expertise in Snowflake, Azure Data Factory, dbt, SQL Server, and Azure DevOps, with hands-on experience in migrating legacy SQL Server workloads to modern cloud-based data platforms.

This is a hands-on engineering role focused on designing and developing scalable data pipelines, transforming legacy stored procedures into reusable data models, and building governed data layers using modern data engineering practices.

Key Responsibilities

• Analyze complex SQL Server stored procedures and identify embedded business logic.
• Migrate and refactor legacy SQL logic into reusable Snowflake and dbt models.
• Develop Bronze, Silver, and Gold data transformation layers.
• Design and build Kimball-style dimensional models, including facts, dimensions, and star schemas.
• Implement Slowly Changing Dimensions (SCD Type 1 & Type 2).
• Build incremental, batch, and CDC (Change Data Capture) processing pipelines.
• Develop and manage Azure Data Factory pipelines for data ingestion and orchestration.
• Create dbt models, macros, snapshots, tests, documentation, and YAML configurations.
• Perform source-to-target mapping, data reconciliation, and validation.
• Implement data quality checks and governance standards.
• Manage source code using Git and Azure DevOps with CI/CD deployment practices.
• Prepare and maintain technical documentation, including data lineage, transformation logic, deployment processes, and handover documentation.
• Collaborate closely with technical leads and project teams to deliver high-quality data engineering solutions.

Required Skills

• Strong hands-on experience with Snowflake
• Experience with dbt Cloud or dbt Core
• Expertise in Azure Data Factory (ADF)
• Strong knowledge of SQL Server and T-SQL
• Experience with Azure DevOps , Git , and CI/CD practices
• Strong understanding of Kimball Dimensional Modeling
• Experience building:
  • Fact and Dimension tables
  • Star Schema models
  • SCD Type 1 & Type 2
  • Incremental data models
  • Batch and CDC pipelines
• Experience with data quality validation and reconciliation
• Strong problem-solving and analytical skills

Mandatory Requirements

• Hands-on experience with Snowflake , Azure Data Factory , dbt , SQL Server/T-SQL , and Azure DevOps .
• Experience in at least one data platform migration or modernization project .
• Proven experience migrating or refactoring legacy SQL Server stored procedures into modern cloud data platforms such as Snowflake, Databricks, Microsoft Fabric, or Azure/AWS-native platforms.
• Ability to convert complex legacy business logic into clean, reusable, and governed data models.
• Strong experience in ETL/ELT development, data transformation, and cloud data engineering.

Preferred Skills

• Experience with modern cloud data warehouse architectures.
• Exposure to data governance and best engineering practices.
• Familiarity with Agile development methodologies.
• Excellent communication and collaboration skills.