EY-GDS Consulting-AI and DATA-DBT-Staff

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

EY GDS – Data and Analytics (D&A) – Senior DBT Engineer

We’re looking for candidates with strong technology and data understanding in data engineering space, having proven delivery capability. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.

Job Summary :

As a Senior DBT / Azure Data Engineer, you will play a pivotal role in designing, implementing, and optimizing data transformation pipelines within the Azure cloud environment or GCP Cloud environment using DBT (Data Build Tool). Your extensive experience in Azure services and data warehousing will enable you to deliver robust and scalable data solutions to meet the evolving needs of the business.

Your key responsibilities

• Design and implement scalable and reliable data models using DBT for data warehousing and business intelligence purposes within the Azure cloud environment or GCP Cloud environment.
• Collaborate with data analysts and business users to understand data requirements and translate business needs into technical specifications.
• Develop and maintain complex SQL queries and DBT models to support data transformation and aggregation.
• Optimize DBT performance by analysing query execution plans and implementing best practices for efficient data processing.
• Ensure data quality and integrity by implementing testing frameworks and data validation checks within DBT.
• Automate data pipeline workflows and integrate DBT with other data engineering tools and platforms.
• Monitor and troubleshoot DBT jobs, addressing any issues related to data discrepancies or performance bottlenecks.
• Document DBT models, data dictionaries, and other technical artifacts to ensure clarity and maintainability.
• Mentor junior DBT engineers and contribute to the development of best practices within the data engineering team.
• Stay up-to-date with the latest developments in DBT and related technologies, and advocate for their adoption where appropriate.
• Proactively research and recommend improvements to the data stack by staying current with Azure / GCP services, DBT releases, and industry trends.

To qualify for the role, you must have :

EY | Building a better working world