CBG: Data Automation to deliver seamless pharmacy experience

What were the underlying reasons for the need of data? Describe the business and technical challenges the company was facing and how data integrations can help.

Our primary reason and business need to automate data was to support data ingress/egress integrations for a new healthcare startup. Our startup vision is to: “build and support myriad healthcare entities through acclaimed clinical, operational and digital expertise and solutions to accelerate proven outcomes.” Our mission is: “to partner with forward-thinking entities who strive for excellence in delivering the pharmacy experience and provide a pathway to PBM ownership.” To do that, we had to go live with our startup on 5/1/2020.

Our primary challenge was our timeline. We were not able to start working on data integration until 1/1/2020, so we only had 4 months to go-live. Our secondary challenges were numerous:

  • Budget constraints required very lean technologist team
  • Connect multiple cloud providers and SaaS tools
  • PHI/PII requires absolute attention to security
  • Everything must be CI/CD friendly
  • Multiple service teams across multiple vendors to integrate
  • 10+ vendors / partners with mission critical data
  • 30+ inbound & outbound data interfaces
  • Varying data formats, transport mechanisms, and schedules
  • Configuration-driven automation

Working through these challenges, we propelled our startup forward, and innovated our business by using data.

Who was and how were they involved in building out the solution? (Please include the # of FTEs, any partners or SnapLogic professional services who were involved on the implementation)

We had four key people involved in the building out of our solution. Bethe Price (FTE) was our COO and primary business analyst for getting requirements refined. Davis Hansen (FTE) was our single data engineer for building and architecting the data integration solution. Roger Sramkoski (SnapLogic) was our key support contact from SnapLogic that helped us through our onboarding, training, and implementation of the SnapLogic platform & technologies. Last, our cloud architect helped us work through architecture complexities.

What were the business results after achieving this data strategy? Describe how your company, departments, and/or employees/customers benefit from the data, and include any measurable metrics.

Our business results were vast. Most importantly, we were able to open our doors to our client as expected on 5/1/2020. In addition, we ended up with some stunning metrics that highlight the volume, resiliency, and flexibility of the data integrations we built:

  • 90+ pipelines in production and 30+ integrations with partners & vendors
  • 99% successful pipeline executions for ETL/ELT, APIs, and Bots
  • More than 2 TB of data & ~575K objects have flowed through SnapLogic in production
  • 99.99% CloudPlex platform uptime for core data pipelines & services
  • 1000+ ETL, API, and Bot pipeline executions per day with ~3secs round trips
  • All pipelines ready by 4/15/2020 with 2 weeks for additional testing
  • Data & integration engineer cycle times are ~2days on average

CBG is a testament to what a small but mighty team can do when they leverage the power of low-code and automation.