Snowflake-DBT Engineer

About Us: Narwal, with its Global Delivery Model, strategically expands its reach across North America, the United Kingdom, and an offshore development centre in India. Delivery cutting edge AI, Data and Quality Engineering solutions and consistently surpassing expectations, Narwal has achieved remarkable triple-digit growth rates year after year, earning accolades such as Inc. 5000, Best IT Services Company, Best Data Technology Company, and Partner of the Year with Tricentis.

Our Vision : To be an expert in AI, Data and Quality Engineering transformations, bold in our thinking and authentic in our relationships.

Job Title : Technical Delivery Lead- Data Engineering

Experience Level : 8-15 Yrs

Work Location : Pune ( Hybrid)

Job Summary We are looking for an experienced Data Engineer with strong expertise in Snowflake and dbt to design, develop, and maintain scalable data transformation and analytics solutions. The ideal candidate will have hands-on experience building modern cloud data platforms, developing robust ELT pipelines, and implementing data models using dbt on Snowflake.

Key Responsibilities

• Design, develop, and maintain scalable data solutions using Snowflake.
• Build and maintain data transformation pipelines using dbt (Data Build Tool).
• Develop efficient and reusable dbt models, macros, tests, snapshots, and seeds.Implement dimensional data models, including fact and dimension tables, using dbt.
• Optimize Snowflake queries, warehouses, storage, and compute utilization for performance and cost.
• Develop robust ELT/ETL pipelines to ingest and transform data from multiple sourcesImplement data quality checks, testing, documentation, and lineage using dbt.
• Manage incremental models and optimize large-volume data transformations.
• Implement dbt deployment workflows and integrate dbt with CI/CD processes.
• Collaborate with Data Analysts, BI Developers, Data Scientists, and business stakeholders to understand data requirements.
• Troubleshoot data pipeline, SQL, and transformation issues.
• Establish best practices for data modeling, version control, testing, and deployment.
• Monitor data pipelines and ensure reliability, accuracy, and availability of data.
• Participate in code reviews and contribute to engineering standards and documentation.

Primary Skills

• Snowflake Expert

• Snowflake architecture and data warehouse concepts

• Snowflake SQL

• Virtual warehouses and resource management

• Performance and cost optimization

• Time Travel, Zero-Copy Cloning, Streams and Tasks

• Data loading and unloading

• Semi-structured data such as JSON

• Dbt Expert

• dbt Core / dbt Cloud

• dbt models and project structure

• dbt tests and data quality

• Incremental models

• Snapshots

• Seeds

• Macros and Jinja

• Sources and exposures

• Documentation and lineage

• Model materializations

• CI/CD and Deployment Practices

Required Qualifications

• Bachelor s degree in Computer Science, Information Technology, Engineering, or a related field.
• 4+ years of experience in Data Engineering, Data Warehousing, or Analytics Engineering.
• Strong hands-on experience with Snowflake and dbt.
• Strong proficiency in SQL and data modeling.
• Experience developing production-grade data pipelines and transformation workflows.
• Experience with Git-based development and CI/CD practices.
• Strong problem-solving and analytical skills.

Narwal, with its Global Delivery Model, strategically expands its reach across North America, the United Kingdom, and an offshore development center in India. Delivery cutting edge AI, Data, and Quality Engineering solutions and consistently surpassing expectations. Narwal has achieved remarkable triple-digit growth rates year after year, earning accolades such as Inc. 5000, Best IT Services Company, Best Data Technology Company, and Partner of the Year with Tricentis.

Our Vision: To be an expert in AI, Data, and Quality Engineering transformations, bold in our thinking and authentic in our relationships.