Technical Architect - DBT (Data Build Tool)

should be able to play a critical role in designing, developing, and maintaining data transformation processes using DBT (Data Build Tool)

Expected to work closely with data engineers, data analysts, and other stakeholders to ensure that data pipelines and models are efficient, scalable, and aligned with business goals

This role involves both technical expertise and the ability to understand and address the data requirements of various teams within the organization

Key Responsibilities

DBT Development Design, develop, and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting


Data Modeling Define and implement data modeling best practices, including data warehousing, ETL processes, and data transformations using DBT


Data Governance Establish data governance practices and ensure data accuracy, quality, and consistency within the data transformation process


Collaboration Collaborate with data engineers, data analysts, and other stakeholders to understand and meet data requirements for various business units


Performance Optimization Identify and address performance bottlenecks in data transformation processes and optimize DBT models for faster query performance


Documentation Maintain thorough documentation of DBT models, transformations, and data dictionaries to ensure transparency and accessibility to team members


Security Implement data security measures to protect sensitive information and comply with data privacy regulations


Continuous Improvement Stay updated on industry best practices and new features in DBT, and continuously improve the data transformation processes


Training and Support Provide training and support to other team members in using DBT effectively


POC Must be able to plan and execute POCs relevant to DBT

Solution Design

Emerging Technologies

Architecture tools and frameworks

Architecture Concepts and Principles

Technology/Product Knowledge

Application Design

Estimation and Resource Planning