PitchMeAI
VAYUZ Technologies

DBT Data Engineer

VAYUZ Technologies · Gurugram, Haryana, India

This listing has closed — view similar roles below.

  • On site
  • Full-time
  • $100,000 / year
  • Gurugram, Haryana, India

Job highlights

  • Design and maintain DBT data pipelines in Azure.
  • Collaborate with teams for data requirements.
  • Automate processes with Control-M and scripting.
  • Ensure data quality and governance.
  • Improve data engineering practices.

About the role

Company Overview

VAYUZ Technologies is a leading provider of cutting-edge data solutions, specializing in helping businesses unlock the power of their data through advanced analytics and cloud-based technologies. We operate across diverse industries, empowering organizations to make data-driven decisions and gain a competitive edge. Our expertise lies in building robust data pipelines, implementing sophisticated data models, and delivering actionable insights.

Role Overview

As a DBT Data Engineer at VAYUZ Technologies, you will be instrumental in designing, developing, and maintaining our data transformation pipelines using Data Build Tool (DBT) within an Azure cloud environment. You will collaborate closely with data scientists, data analysts, and other engineers to ensure the delivery of high-quality, reliable data for critical business initiatives. Your work will directly impact the efficiency and accuracy of our data-driven decision-making processes, enabling us to better serve our clients and drive business growth.

Key Responsibilities

  • Develop and maintain data transformation models using DBT, ensuring data quality and consistency for downstream analytics.
  • Design and implement efficient data pipelines within the Azure cloud environment, optimizing for performance and scalability.
  • Collaborate with data scientists and analysts to understand data requirements and translate them into robust DBT models.
  • Automate data pipeline processes using Control-M and Shell Scripting, reducing manual effort and improving operational efficiency.
  • Monitor and troubleshoot data pipeline issues, ensuring timely resolution and minimal disruption to data availability.
  • Contribute to the development of data governance standards and best practices, promoting data quality and compliance.
  • Participate in code reviews and contribute to the continuous improvement of our data engineering practices.

Required Skillset

  • Demonstrated ability to design and implement data transformation pipelines using Data Build Tool (DBT).
  • Proven expertise in working with Azure cloud services, including Azure Data Factory, Azure Databricks, and Azure SQL Database.
  • Strong proficiency in SQL, particularly with PostgreSQL, for data querying and manipulation.
  • Experience with scripting languages such as Python and Shell Scripting for automating data pipeline tasks.
  • Solid understanding of data warehousing concepts and data modeling techniques.
  • Familiarity with version control systems like Git and Linux environments.
  • Excellent communication and collaboration skills, with the ability to work effectively in a team environment.

Good To Have

  • Exposure to Flyway or Artifactory
  • Experience in handling large-scale data pipelines

Key skills/competency

DBT Data Engineer, Data Transformation, Data Pipelines, Azure Cloud, Data Modeling, SQL, Python, Shell Scripting, Data Warehousing, Git

Skills & topics

  • DBT
  • Data Engineer
  • Data Transformation
  • Azure
  • SQL
  • Python
  • Shell Scripting
  • Data Pipelines
  • Data Warehousing
  • Cloud

How to get hired

  • Tailor your resume: Highlight your experience with DBT, Azure, SQL, Python, and Shell Scripting.
  • Showcase your projects: Demonstrate your ability to build and maintain data transformation pipelines.
  • Prepare for technical questions: Brush up on data warehousing concepts, SQL, and Azure services.
  • Emphasize collaboration: Be ready to discuss how you work with cross-functional teams.

Technical preparation

Master DBT concepts and syntax.,Practice Azure Data Factory and Databricks.,Write complex SQL queries in PostgreSQL.,Develop Python scripts for automation.

Behavioral questions

Describe a complex data pipeline challenge.,How do you ensure data quality?,Explain collaboration with analysts/scientists.,How do you approach code reviews?

Frequently asked questions

What specific DBT experience is VAYUZ Technologies looking for in a DBT Data Engineer?
VAYUZ Technologies is seeking demonstrated ability in designing and implementing data transformation pipelines using Data Build Tool (DBT). This includes experience in maintaining these models for data quality and consistency.
How important is Azure cloud experience for the DBT Data Engineer role at VAYUZ Technologies?
Azure cloud experience is crucial. The role requires proven expertise with Azure services like Azure Data Factory, Azure Databricks, and Azure SQL Database for designing and implementing data pipelines.
What SQL skills are required for this DBT Data Engineer position?
Strong proficiency in SQL is required, with a particular emphasis on PostgreSQL for data querying and manipulation. This is essential for working with the data transformation models.
Does VAYUZ Technologies expect experience with automation tools for the DBT Data Engineer role?
Yes, experience with automating data pipeline processes using Control-M and Shell Scripting is a key responsibility to improve operational efficiency and reduce manual effort.
What are the 'Good To Have' skills for the DBT Data Engineer role at VAYUZ Technologies?
Good to have skills include exposure to Flyway or Artifactory, and prior experience in handling large-scale data pipelines. These can further enhance your application.
How does VAYUZ Technologies approach data governance in this role?
As a DBT Data Engineer, you will contribute to the development of data governance standards and best practices, promoting data quality and compliance within the organization.
What kind of collaboration can I expect as a DBT Data Engineer at VAYUZ Technologies?
You will collaborate closely with data scientists, data analysts, and other engineers to understand data requirements and ensure the delivery of high-quality data for business initiatives.
What is the primary technology stack for data transformation at VAYUZ Technologies?
The primary technology for data transformation is Data Build Tool (DBT), integrated within the Azure cloud environment. SQL and scripting languages like Python and Shell are also key.