Title: Snowflake DBT Consultant
Location: Remote
Contract: 3+ Months
Exp Level: 8+ Years
Role Overview
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.
- 3+ years’ experience in Data Engineering / ELT development.
- Strong SQL proficiency, with experience writing optimized queries.
- Hands_on experience with DBT Core or DBT Cloud.
- Experience with any cloud data warehouse:
- Snowflake / BigQuery / Redshift / Azure Synapse.
- Familiarity with Git, CI/CD pipelines, and modern data stack principles.
- Understanding of data modeling techniques (Kimball, Data Vault, Star/Snowflake
- Experience integrating DBT with orchestrators (Airflow, Dagster, Prefect, etc.).
Top Skills
What We Do
A premiere data services company serving clients in North America, Datavail has 1,000 data professionals, data engineers, developers, project managers, consultants, and business experts, supported by industry-leading automation and intellectual property. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes. At Datavail, we look for more than smarts, experience and proficiency. On top of those requirements, we seek people who mesh with our corporate values. We seek brilliance without bravado and know-how without a know-it-all attitude. We hold low ego in high regard, embrace problem-solving as a passion and welcome every day as a new opportunity to learn. We’re flexible and hard working. We’re committed to our clients and colleagues. We help our people grow so they can help our clients grow. That makes us grow so we can help even more customers leverage organizational data for business value. Our Core Values: 1. We desire to serve. 2. We embody flexibility for availability 3. We exemplify low ego. 4. We work hard. 5. We strive for continuous improvement. 6. We are growth-oriented.
