EY

Senior Consultant – AI and Data, DBT, Snowflake

EY

full-time

Posted on:

Location Type: Office

Location: Bengaluru • India

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

CloudPythonSQL

About the 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
  • Implement Slowly Changing Dimensions (SCD) Type 1 and Type 2 using DBT
  • Write Python scripts to support data processing
  • Manage database objects (schemas, tables, stages)
  • Use DBT Cloud for job orchestration, testing, and documentation

Requirements

  • 6 to 8 years of experience as a DBT Developer
  • Strong hands-on expertise in DBT (Data Build Tool)
  • Deep understanding of data warehousing concepts
  • Proven proficiency in SQL and Python
  • Ability to build scalable data models and data products using DBT
  • Experience with Data Mesh architecture
  • Familiarity with Git for source control
  • Understanding of CI/CD pipelines for data workflows
  • Good understanding of Snowflake Internals
Benefits
  • Support, coaching and feedback from some of the most engaging colleagues around
  • Opportunities to develop new skills and progress your career
  • The freedom and flexibility to handle your role in a way that’s right for you

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
DBTSQLPythonData MeshSlowly Changing Dimensionsdata warehousingdata modelingJinjaGitCI/CD