EY GDS Consulting AI And DATA DBT- Snowflake Manager

EY-Advisory - Data and Analytics DBT/Snowflake Manager

EYs Advisory Services is a unique industry-focused business unit that provides a broad range of integrated services that leverage deep industry experience with strong functional and technical capabilities and product knowledge. EYs financial services practice provides integrated advisory services to financial institutions and other capital markets participants including commercial banks retail banks investment banks broker-dealers & asset management firms and insurance firms from leading Fortune 500 Companies. Within EYs Advisory Practice Data and Analytics team solves big complex issues and capitalize on opportunities to deliver better working outcomes that help expand and safeguard the businesses now and in the future. This way we help create a compelling business case for embedding the right analytical practice at the heart of clients decision-making.

The opportunity

We are seeking a highly skilled DBT Developer with 9 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.

What we look for

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

What working at EY offers

At EY were dedicated to helping our clients from startups to Fortune 500 companies and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus we offer:

• 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 thats right for you