Case Study: PetIQ Accelerates Data Transformation with Coalesce

PetIQ Reimagines What’s Paw-sible with Better Data

PetIQ, a leading pet medication and wellness company, needed a faster, more scalable way to manage data after rapid growth and acquisitions left it with multiple ERPs, several reporting tools, and siloed data across the business. Its legacy data automation platform was cumbersome and too slow to keep pace with the company’s needs, even after adding Snowflake and Fivetran to the stack.

PetIQ adopted Coalesce as its data transformation and modeling solution, using it to tie together data from multiple source systems and migrate existing models from the legacy platform. The team completed a proof of concept in just 20 minutes and migrated nearly all models in 6 to 8 weeks, with around 90% done in the first 6 weeks. With Coalesce, PetIQ improved version control, column-level lineage, and visualization, making it easier to track changes, clean up its Data Vault, and help other teams understand the data.

PetIQ

Blake Davidson

Senior Manager