Technical Lead - DBT

Job description

Responsibility of / Expectations from the Role 1 Design and develop well-structured data models (star/snowflake schemas) using DBT. 2 Write clear and maintainable SQL-based transformation models in DBT to create clean, business-friendly datasets. 3 Implement DBT best practices including model versioning, modular development, testing, and documentation. 4 Build and maintain efficient and reliable data pipelines using DBT, integrated with data warehouses like Snowflake, BigQuery, or Redshift. 5 Monitor and optimize pipeline performance, troubleshoot data quality issues, and identify root causes. 6 Implement data testing, documentation, and lineage tracking using DBT features such as tests, docs, and sources. 7 Promote data governance practices by maintaining metadata and documentation. 8 Collaborate with data engineers and analysts to transform raw data into well-structured datasets supporting business insights. 9 Optimize and refactor DBT models for better performance and scalability. 10 Follow best practices for version control (Git), CI/CD, and data governance to ensure quality and reliability. 11 Work closely with stakeholders to understand reporting requirements and ensure data accuracy and availability.