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)
Top Skills
What We Do
Kipi.ai, a WNS company, is at the forefront of advanced analytics and AI services, specializing in AI, machine learning, and data science to drive innovation and business growth. As an Elite Snowflake Partner, kipi.ai is uniquely positioned to deliver scalable, AI-driven solutions that optimize data operations and empower organizations to fully harness the potential of their data.
Kipi.ai has earned Snowflake’s AI Data Cloud Services Americas Innovation Partner of the Year and Americas System Integrator Growth Partner of the Year, and holds 8 industry competency badges. We're dedicated to pioneering world-class data solutions for Snowflake customers, offering 250+ Accelerators, Enablers, Solutions, and Native Apps to optimize performance within the Snowflake ecosystem.
