From scheduled queries to robust dbt transformations

How wholesomeco director of analytics partnered with systematik to augment their staff and migrate to dbt.

“I would definitely recommend systematik. Our goal was to consult with experts on how to implement dbt, and build a robust, modern data architecture, and they do that really well.”

Mitchell moody Director of analytics at wholesomeCo

The problems

Lack of scalability

Based on BigQuery scheduled views, the existing data pipeline was not built to scale, limiting wholesomeco’s ability to adapt to increasing data demands.

Poor maintenance and error-prone

The lack of version control introduced inconsistencies and errors, complicating maintenance efforts.

Inefficient costs

Rising costs were becoming a concern, as the existing pipeline was not optimized for the scale of data being processed.

Absence of standard definitions

Without standard definitions for metrics, departments faced inconsistencies and misunderstandings in interpreting data.

Poor documentation and data quality monitoring

The initial system had limited documentation and lacked data quality monitoring features, leading to poor data quality and redundancies.

The solutions

Fast deployment through staff augmentation

One of the key reasons wholesomeco partnered with Systematik was to speed up the deployment process. systematik augmented wholesomeco’s team with their data engineers, achieving a swift transition to the new dbt-based pipeline.

Transitioning to dbt

Systematik’s dbt consulting helped wholesomeco transition smoothly, creating a scalable, robust pipeline.

Data quality monitoring

The team implemented data tests and quality monitoring within dbt, ensuring reliable, high-quality data.


By streamlining queries and reducing redundancies, the new system reduced operational costs.

Comprehensive documentation and standard definitions

Systematik also helped create a detailed documentation framework and standard definitions for each metric, ensuring consistency across the organization.

The results

By leveraging systematik’s dbt expertise and staff augmentation services, wholesomeco was able to achieve a rapid and efficient transition to a dbt-based data pipeline. This new system not only met but surpassed the goals set by their director of analytics, mitchell moody. The benefits were manifold: faster deployment, greater scalability, fewer errors, cost savings, and improved data quality. Furthermore, the introduction of comprehensive documentation and standard definitions have ensured operational consistency across the organization.

All in all, the partnership with systematik marked a pivotal advancement in wholesomeco’s data management capabilities. If you’d like to hear more, watch mitchell moody’s video testimonial. He shares his own experience on the project’s success.

Share this case study

Our latest case studies

This step-by-step guidel will teach you how to calculate the remaining days in a month, the total days, and the days that have already passed.
How we helped Spaceful Technologies identify where leads were being lost and monitor performance.
Spaceful is a new tech-enabled logistics company from Montreal that takes the hassle out of self-storage. They offer eCommerce Fulfillment, Subscription Box Fulfillment, FBA Prep Services, B2B Fulfillment, and Last-Mile Delivery Solutions (Same Day, Next Day, Scheduled).
How we helped this digital marketing agency automate their monthly reporting for all of their clients.
Recognizing the growing inefficiencies in their existing data pipeline, WholesomeCo sought to transform their approach to data management. Mitchell Moody, their Director of Analytics, reached out to Systematik, for their expertise as dbt partners and staff augmentation to expedite the deployment process.