Senior Consultant – AI & Data – DBT, Snowflake
EY
full-time
Posted on:
Location Type: Office
Location: Bengaluru • India
Visit company websiteExplore more
Job Level
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
- Write Python scripts to support data processing, testing, automation, and integration tasks
- Manage database objects (schemas, tables, stages) and perform performance tuning within Snowflake
- Interact and communicate with the onsite teams directly to understand the requirement
Requirements
- 6 to 8 years of experience as DBT Developer
- Strong hands-on expertise in DBT (Data Build Tool)
- Deep understanding of data warehousing concepts
- Proven proficiency in SQL and Python
- Familiarity with Git for source control
- Understanding of CI/CD pipelines for data workflows
- Exposure to Data Mesh architecture
- Experience with DBT Explorer or similar visualization tools
- Familiarity with orchestration tools like Airflow
- Knowledge of metadata and data governance platforms
- Hands on exposure to ETL using Snowflake native services
- 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
DBTPythonSQLdata warehousingETLperformance tuningdata processingdata integrationdata governancemetadata
Soft skills
communicationinterpersonal