OPEN ROLE — VIA SYMPHONI HR

Senior DBT Data Engineer.

PuneHybrid6–9 yearsPosted 2026-11-17

This mandate is run by SYMPHONI HR, a Mumbai-based executive search firm, est. 2003. Applications are email-verified and reach the search team running the role — confidentially, always.

About the organisation.

SYMPHONI HR is partnering with a leading global technology and analytics services provider in the computer software space. The client is a large, fast-scaling organisation that delivers data-driven solutions to enterprises across multiple industries. Its culture emphasises engineering excellence, continuous learning and collaborative delivery.

About the role.

We are looking for a Senior DBT Data Engineer to design and build scalable ELT pipelines and analytics-ready data models on modern cloud data platforms. You will own transformation layers, data quality testing and semantic models that power reporting and analytics for business stakeholders. The role is hybrid and suits an experienced engineer who enjoys shaping best practices in a collaborative, Agile environment.

What you will do.

  • Design and develop ELT pipelines using DBT, building reusable, scalable and maintainable transformation models.
  • Develop staging, intermediate and mart layers following DBT best practices, including modular SQL transformations and macros.
  • Create and maintain source-to-target mappings and design dimensional models, fact tables and star schemas.
  • Build business-friendly semantic layers and support enterprise data warehouse initiatives.
  • Implement DBT tests for uniqueness, referential integrity, null validation and custom business rules, and perform root cause analysis for data issues.
  • Work with cloud data platforms such as Snowflake, Databricks, BigQuery, Azure Synapse and Redshift, optimising query performance and compute costs.
  • Integrate DBT projects with Git and CI/CD pipelines, automating deployments across Development, QA and Production environments.
  • Maintain documentation and lineage using DBT documentation features.
  • Collaborate with Data Architects, Analysts and business teams, and participate in Agile ceremonies and sprint planning.

What you bring.

  • 6-9 years of data engineering experience, including at least 2 years of hands-on DBT development.
  • Strong proficiency in DBT, Advanced SQL, data warehousing concepts, data modelling and ETL/ELT development.
  • Hands-on experience with cloud platforms such as Snowflake, Databricks, Google BigQuery, Azure Synapse Analytics or AWS Redshift.
  • Proficiency in Python and SQL, with shell scripting preferred.
  • Experience with Airflow, Azure Data Factory, Databricks Workflows and GitHub/GitLab.
  • Understanding of data lineage, data catalogues, data validation frameworks and metadata management.
  • Experience building DBT models on Snowflake or BigQuery and implementing automated data validation through DBT.
  • Bachelor's degree in Computer Science, Engineering, Information Technology or a related field.
Apply for this role →