About this role
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.
-
Other
-
Languages
-
English: C1 Advanced
-
Seniority
-
Senior
-
DWH Development
-
Cross Industry Solutions
-
Note: The following fields were part of the original listing but are not required for the job description itself:
-
Remote location details, application form fields, privacy notices, consent language, and marketing communications preferences.