Описание вакансии от работодателя
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.