Job Summary :

We are looking for an experienced DBT Technical Lead with 6+ years of experience in data engineering and modern data transformation.

The ideal candidate should have strong expertise in dbt (Data Build Tool), SQL, cloud data platforms, and data warehouse architecture.

This role involves leading the design, development, and optimization of scalable data transformation pipelines, mentoring team members, and collaborating with cross-functional stakeholders to deliver high-quality analytics solutions.

Key Responsibilities :

- Lead the design, development, and implementation of data transformation solutions using dbt (Data Build Tool).

- Develop, maintain, and optimize dbt models, macros, tests, snapshots, and documentation.

- Build scalable and efficient ELT pipelines following data engineering best practices.

- Design and implement data models for analytics and business intelligence requirements.

- Collaborate with business stakeholders, data engineers, and analysts to gather and translate requirements into technical solutions.

- Perform code reviews, enforce coding standards, and mentor junior team members.

- Optimize SQL queries and dbt models to improve data pipeline performance and reliability.

- Implement data quality checks, testing frameworks, and monitoring processes within dbt.

- Integrate dbt with cloud data warehouses such as Snowflake, Databricks, BigQuery, or Redshift.

- Manage CI/CD pipelines, version control using Git, and deployment processes for dbt projects.

- Troubleshoot production issues, perform root cause analysis, and implement long-term solutions.

- Create and maintain technical documentation, architecture diagrams, and development standards.

Required Skills :

- 6+ years of experience in Data Engineering or Data Warehouse development.

- Strong hands-on experience with dbt (Data Build Tool).

- Advanced proficiency in SQL and data modeling techniques.

- Experience with cloud data warehouses such as Snowflake, Databricks, BigQuery, or Amazon Redshift.

- Strong understanding of ELT/ETL concepts, dimensional modeling, and data warehousing.

- Experience with Git, CI/CD pipelines, and Agile development methodologies.

- Knowledge of Python is an added advantage.

- Familiarity with orchestration tools such as Airflow, Azure Data Factory, or similar platforms.

- Excellent analytical, problem-solving, and troubleshooting skills.

- Strong leadership, mentoring, and stakeholder management abilities.

Preferred Qualifications :

- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

- dbt, Snowflake, Databricks, or cloud platform certifications are preferred.

- Experience with modern data stack technologies and enterprise-scale data platforms.

- Exposure to DevOps practices and data governance frameworks is an added advantage.