Kipi.ai
DBT Developer -Onshore Remote Opportunity
Key Responsibilities
Develop, maintain, and optimize DBT models, ensuring alignment with business and technical requirements.
Configure and manage sources & sources.yml files to maintain data lineage and integrity.
Utilize ref macros, custom macros, and materializations to develop reusable and modular pipelines.
Implement pre-hooks and post-hooks for advanced transformations, auditing, and automated checks.
Manage DBT Seeds for static data storage and integration into models.
Work closely with Azure Data Factory (ADF) teams to integrate DBT workflows into data pipelines.
Implement best practices for version control using Git & Azure DevOps, including branching strategies, pull requests, and CI/CD integration.
Collaborate with data engineers, BI teams, and business stakeholders for data requirement gathering and solution delivery.
Ensure data quality, scalability, and maintainability of all DBT models and artifacts.
Work within Azure Cloud environment, ensuring understanding of RBAC roles & access controls.
Required Skills & Experience
Strong knowledge of DBT basics, models, sources, and ref usage.
Experience with DBT advanced concepts such as Macros, Materializations, Hooks.
Hands‑on experience with Azure Data Factory (ADF) or similar ETL/ELT orchestration tools.
Familiarity with Git version control, Azure DevOps workflows, and CI/CD processes.
Understanding of Azure Cloud fundamentals & RBAC for secure data access.
Proficiency in SQL and data modeling concepts.
Website-
www.kipi.ai
Location- Boston, MA (Hybrid – at least 2 days onsite per week)
#J-18808-Ljbffr
Develop, maintain, and optimize DBT models, ensuring alignment with business and technical requirements.
Configure and manage sources & sources.yml files to maintain data lineage and integrity.
Utilize ref macros, custom macros, and materializations to develop reusable and modular pipelines.
Implement pre-hooks and post-hooks for advanced transformations, auditing, and automated checks.
Manage DBT Seeds for static data storage and integration into models.
Work closely with Azure Data Factory (ADF) teams to integrate DBT workflows into data pipelines.
Implement best practices for version control using Git & Azure DevOps, including branching strategies, pull requests, and CI/CD integration.
Collaborate with data engineers, BI teams, and business stakeholders for data requirement gathering and solution delivery.
Ensure data quality, scalability, and maintainability of all DBT models and artifacts.
Work within Azure Cloud environment, ensuring understanding of RBAC roles & access controls.
Required Skills & Experience
Strong knowledge of DBT basics, models, sources, and ref usage.
Experience with DBT advanced concepts such as Macros, Materializations, Hooks.
Hands‑on experience with Azure Data Factory (ADF) or similar ETL/ELT orchestration tools.
Familiarity with Git version control, Azure DevOps workflows, and CI/CD processes.
Understanding of Azure Cloud fundamentals & RBAC for secure data access.
Proficiency in SQL and data modeling concepts.
Website-
www.kipi.ai
Location- Boston, MA (Hybrid – at least 2 days onsite per week)
#J-18808-Ljbffr