Migrating Pharmacy and Oncology Business Units to the Cloud with Snowflake & Matillion

Our client, a top 5 global pharmaceutical organization, had been running a data platform for many years that was starting to reach its limit in terms of data volume, compute capacity, and cost-effective scaling. The organization wanted to expand into patient-level analytics, but faced roadblocks due to these capacity and cost issues.

 

MAJOR MILESTONES: 

  • Creation and implementation of a data ingestion framework that allows for a single, flexible, metadata-driven process to automatically ingest, transform, and standardize data from a variety of sources
  • Migration of legacy code to user-friendly transformation workflows and orchestration of end-to-end pipelines integrated with audit and data quality frameworks
  • Development and implementation of robust change management practices and an extensive data governance framework

 

CHALLENGES: 

  • Capacity and cost issues due to an outdated data platform
  • Migrating multiple business units across the enterprise into the cloud

 

MAIN BENEFITS: 

  • A 30x improvement of the overall refersh performance of the data warehouse
  • Enormous gains in speed and performance of high-level analysis of patient claim data
  • A significant reduction in the time needed for brand-specific market share analysis 

 

Fill out the form below to access the full success story: