Agile-EY-GDS Consulting-AI And DATA-DBT-Snowflake-Senior

6 - 8 years

8 - 10 Lacs

Posted:7 hours ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

The opportunity

We are seeking a highly skilled

DBT Developer

with

6 to 8 years of experience

to join our growing

Data Engineering

team. This is a full-time

role based in Bangalore

, with a

5-days-a-week from office

setup.
The ideal candidate will have strong hands-on expertise in

DBT (Data Build Tool)

, deep understanding of

data warehousing concepts

, and proven proficiency in

SQL

and

Python

. You will be responsible for building scalable

data models

and

data products

using DBT, working within a

Data Mesh architecture

, and collaborating closely with cross-functional domain teams to deliver high-quality, production-ready data solutions.

Key skills required for the role (Primary)

  • Expertise in designing and implementing a fully operational solution on Snowflake Data Warehouse using DBT Core / DBT Cloud.
  • Experience building Jinja macros, snapshots, and custom materializations.
  • Strong understanding of data warehousing concepts, including SCD Type 1 and 2.
  • Familiarity with Git for source control and branching strategies.
  • Understanding of CI/CD pipelines for data workflows.
  • Exposure to Data Mesh architecture and domain-based data ownership.
  • Experience with DBT Explorer or similar visualization/documentation tools.
  • Familiarity with orchestration tools like Airflow, Amazon MWAA.
  • Knowledge of metadata and data governance platforms e.g., dbt Docs.
  • Experience implementing Data Mesh concepts
  • Hands on exposure to ETL using Snowflake native services
  • Hands on exposure to SQL & scripting
  • Good understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies
  • Good to have experience working with AWS services like -S3, MWAA, lambda etc.
  • Work experience with banking clients is an added advantage

Your role

  • Design and implement Data Mesh-aligned Data Products using DBT.
  • Develop and maintain DBT models incremental, table, and view.
  • Create and manage DBT snapshots for historical tracking.
  • Build and manage Jinja macros to promote reusability and maintainability.
  • Implement Slowly Changing Dimensions (SCD) Type 1 and Type 2 using DBT.
  • Create and maintain custom materializations for advanced use cases.
  • Write Python scripts to support data processing, testing, automation, and integration tasks.
  • Work extensively with Snowflake for data transformation, optimization, and performance tuning.
  • Manage database objects (schemas, tables, stages) and perform performance tuning within Snowflake.
  • Use DBT Cloud for job orchestration, testing, and documentation.
  • Use

    Git

    for version control and follow CI/CD practices for safe deployment.
  • Interact and communicate with the onsite teams directly to understand the requirement and determine the optimum solutions
  • Provide product and design level functional and technical expertise along with best practices
  • Ability to think clearly, plan effectively, organize and develop action plans leading to resolving problems and achieving specific goals

Skills and attributes for success

  • Strong communication, presentation and team building skills and experience in producing high quality deliverables.

  • A Team of people with technical experience and enthusiasm to learn new things in this fast-moving environment
  • An opportunity to be a part of market-leading, multi-disciplinary team of 1400 + professionals
  • Opportunities to work with EY Advisory practices globally with leading businesses across a range of industries

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
EY logo
EY

Professional Services

London

RecommendedJobs for You