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