Onshore- DBT Developer

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)