A company focused on advancing a deep pipeline of precision therapies for patients with a broad range of gnomically defined cancers and rare diseases needed to implement Snowflake, as well as a user security model in order to utilize third party and internal data of clinical trials.
Assessed ETL and Data Catalog tools
Proposed our preferred options (Fivetran and data.world)
Initialized the analytics tools (Snowflake and Fivetran) and implemented complex data integrations to BPM's staging environment.
The customer’s primary challenge was that they had already purchased Snowflake but needed support when creating the initial setup and security model. The customer had internal workstreams aimed at prioritizing analytics use cases, however, those initiatives weren’t integrated with the third party data.
Archetype’s implementation helped the company build automated processes to load complex third-party data into the company’s snowflake environment, which positions them to integrate with internal data in the future. Ultimately, this will help them make strides in the healthcare industry, better understanding how to help their cancer patients.