Data Engineer -DBT

Profile : Data Engineer- DBT

Location : Noida

Contact : Nikhil.vats@multiversetech.com

We are looking for an experienced Data Engineer with strong expertise in DBT (Data Build Tool), SQL and modern data engineering practices. The ideal candidate should have hands-on experience in building, developing and maintaining scalable data transformation pipelines, data models and data warehouse solutions.

Key Responsibilities

• Design, develop and maintain scalable data transformation workflows using DBT.
• Build and optimize complex SQL queries for data transformation and modelling.
• Develop and maintain DBT models, macros, snapshots, tests and documentation.
• Work on ETL/ELT pipelines and integrate data from multiple sources.
• Implement data quality checks, testing frameworks and data validation processes.
• Collaborate with data analysts, data scientists and engineering teams.
• Optimize data models and warehouse performance for better efficiency.
• Manage DBT deployments, version control and CI/CD workflows.
• Troubleshoot data pipeline issues and ensure data accuracy and reliability.
• Work with cloud-based data platforms and modern data stack technologies.

Required Technical Skills

• Strong hands-on experience with DBT (DBT Core / DBT Cloud).
• Excellent SQL skills, including complex queries, joins, CTEs and window functions.
• Strong understanding of data modelling concepts (Star Schema, Snowflake Schema).
• Experience with ETL/ELT processes and data pipeline development.
• Hands-on experience with any cloud data warehouse:
  
• Snowflake
• Google BigQuery
• Amazon Redshift
• Databricks
• Programming knowledge in Python.
• Experience with Git, GitHub/GitLab and version control.
• Understanding of data warehousing and data integration concepts.

Good-to-Have Skills

• Experience with Apache Airflow or other orchestration tools.
• Knowledge of AWS, Azure or GCP.
• Experience with CI/CD pipelines.
• Familiarity with Apache Spark and Databricks.
• Knowledge of data governance and data quality frameworks.