Senior DBT Developer

Project description

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

Responsibilities

• Design, develop, and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting.
• Design, develop, and maintain ETL/ELT pipelines using DBT and pulling data from Snowflake.
• Define and implement data modelling best practices, including data warehousing, ETL processes, and data transformations using DBT.
• Build complex SQL queries within DBT to build incremental models, enhancing data processing efficiency.
• Establish data governance practices and ensure data accuracy, quality, and consistency within the data transformation process.
• Collaborate with data engineers, data analysts, and other stakeholders to understand and meet data requirements for various business units.
• Identify and address performance bottlenecks in data transformation processes and optimize DBT models for faster query performance.
• Maintain thorough documentation of DBT models, transformations, and data dictionaries to ensure transparency and accessibility to team members.
• Implement data security measures to protect sensitive information and comply with data privacy regulations.
• Stay updated on industry best practices and new features in DBT, and continuously improve the data transformation processes.
• Provide training and support to other team members in using DBT effectively.
• Implement data quality checks and validation processes to ensure data accuracy and consistency.

SKILLS

Must have

• Skills Required: Data Building Tool (DBT), Snowflake & SQL
• Experience Level – 5+ years.
• Knowledge of workflow orchestration tools like Tidal.
• Experience with Python or other scripting languages is a plus.
• Familiarity with Azure cloud platforms.
• Exposure to DevOps practices and CI/CD pipelines for data engineering.

Nice to have

Hands-on experience in implementing data governance, data quality rules and validation mechanisms within Collibra is a plus.