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

Ernst & Young Advisory Services Sdn Bhd; Ernakulam; On-site; INR 7,00,000 - 10,00,000; Full time

Job summary

A leading consulting firm in Ernakulam is seeking a Senior DBT Engineer responsible for designing and optimizing data transformation pipelines in Azure or GCP environments. Ideal candidates will have 1-3 years of experience in data engineering, strong SQL skills, and a solid understanding of DBT. The role requires collaboration with business users and data analysts and demands a proactive approach to problem resolution. A great opportunity to advance in a recognized firm focused on building a better working world.

Qualifications

• 1-3 years of industry experience in data engineering.
• Hands-on experience implementing DBT in Azure/GCP.
• Strong analytical skills and problem-solving ability.

Responsibilities

• Design data models using DBT for data warehousing.
• Collaborate with analysts to define data requirements.
• Optimize DBT performance and ensure data quality.

Skills

DBT

SQL

Azure

GCP

DevOps

Agile methodology

Education

Computer Science Graduate

Job description

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:

• Be a computer science graduate or equivalent with 1-3 years of industry experience.
• Extensive hands-on experience implementing DBT for data warehousing and business intelligence purposes within the Azure cloud environment or GCP Cloud environment.
• Well versed in DevOps and CI/CD deployments.
• Must have hands on experience in SQL and procedural SQL languages.
• Strong analytical skills and enjoys solving complex technical problems.
• Have working experience in an Agile base delivery methodology (Preferable)
• Flexible and proactive/self-motivated working style with strong personal ownership of problem resolution.
• Experience in Enterprise grade solution implementations & in converting business problems/challenges to technical solutions considering security, performance, scalability etc.
• Excellent communicator (written and verbal formal and informal).
• Participate in all aspects of solution delivery life cycle including analysis, design, development, testing, production deployment, and support.

EY | Building a better working world

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.