Title: Snowflake DBT Consultant
Location: Remote
Contract: 3+ Months
Exp Level: 8+ Years
We are looking for a skilled DBT (Data Build Tool) Data Engineer to design, build, and optimize modern data transformation pipelines. The ideal candidate has strong SQL skills, hands-on experience with cloud data warehouses, and a solid understanding of data modeling and ELT best practices. You will work closely with analytics, data science, and business teams to deliver clean, reliable, and well-documented data models.
Key Responsibilities
Data Modeling & DBT Development
Develop and maintain DBT models (staging, intermediate, mart layers) following modular design and best practices.
Implement dbt tests, documentation, sources, macros, and packages
Build reusable and scalable data transformation frameworks.
Data Pipeline Engineering
Design and optimize ELT workflows using DBT integrated with orchestrators (Airflow, Dagster, Prefect, etc.).
Work with cloud data environments such as Snowflake, BigQuery, Redshift, Databricks.
Ensure high performance of SQL transformations and warehouse queries.
Data Quality & Governance
Implement and maintain data quality tests within DBT (unique, not null, referential integrity).
Contribute to version control, CI/CD, documentation standards, and best practices.
Collaboration & Stakeholder Support
Work with analysts and business teams to understand requirements and convert them into scalable data models.
Support data consumers with well_structured data and documentation (dbt docs).
Participate in code reviews and provide engineering guidance.
Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner.
Datavail | Data, Cloud & AI—Built for Real Business Outcomes
Datavail is a data, cloud, and AI consultancy that helps organizations turn complex technology environments into clear, measurable business outcomes.
We partner with data, technology, and IT leaders to make enterprise data more usable, systems more adaptable, and decisions more informed. Our work sits at the intersection of data management, cloud modernization, enterprise applications, and AI—bringing these disciplines together so they support the business, not slow it down.
In a landscape full of tools, platforms, and transformation promises, Datavail focuses on what actually drives progress:
• Trusted, well-managed data that teams can rely on
• Cloud environments without unnecessary cost or complexity
• Enterprise applications that evolve with the business
• Practical, responsible AI that delivers value—not experiments
We help organizations:
• Improve data quality, accessibility, and governance
• Turn analytics and AI into everyday decision-making tools
• Modernize and optimize cloud and application environments
• Reduce operational risk while increasing agility and performance
Our Core Capabilities:
• Data Management & AI: Data foundations, analytics, AI and machine learning that support real-world decisions
• Cloud Services: Cloud modernization, optimization, SRE services, and license optimization
• Enterprise Applications: Managed services, upgrades & integrations, digital transformation, and implementation services
At Datavail, we believe data only creates value when it’s well managed, well understood, and actively used. Our role is to help organizations move from complexity to clarity—and from data to action.
