Get in touch

Let’s discuss your ideas or contact us to get a free consultation

I want to receive updates and marketing information from Divectors via e-mail.

By submitting a form, I give my consent for Divectors to process my personal data that I have given in the form above in order to answer my inquiry or conduct any further correspondence related to my question.

© 2019 Divectors, All rights reserved

Data warehouse platform

A centralized place for all the integrated data sources for a pharmaceutical company


Our client is a leading technology-enabled life science services company that simplifies how patients get on and stay on drug therapies.

The company works with biopharmaceutical manufacturers to help commercialize and maximize the benefits of branded and specialty medications. They leverage industry-leading, tech-enabled services to accelerate speed to therapy throughout the medication journey. The unparalleled patient and provider network and advanced analytics power our ability to improve medication adherence and access.


After the acquisition, the company faced challenges with integrating data from various data sources. Due to the diversity of data, data analysis became difficult and time-consuming. As the company operates with personal, sensitive data, they faced the need to introduce a centralized repository of all business information that is needed for internal and external purposes.


As a solution to the problem, we proposed to design and implement Data Warehouse aimed to serve as a central repository for all integrated data sources. Since customer required to gather data from diverse data sources like flat files and different databases, we had to define the approach for data integration.

We have implemented data extract, validation and integration in the staging area (database), hosted in the customer colocated environment. Sensitive data de-identification was implemented to meet customer data security requirements. As the next step, we have identified data sources load priority and designed the rules for rewriting data into the enterprise data warehouse (EDW).

We have introduced audit functionality that ensures capturing matrix of data load status changes (Quantity, load duration, etc ). We’ve also introduced a unique identifier for each load which ensures that data is connected to some identifier. This allows to clean data in case of load issues or failures caused by incorrect source data received or reload of data with updated data set.

We’ve chosen AWS Redshift as the main storage. And loaded data via s3 bucket by using delete-insert flow. Not to affect users, all of the synchronizations are done during the nightly performance window.


Medical insurance


Business intelligence

Technology stack


We’ve implemented integrated star schema storage that contains structured data from diverse sources and provided an option of effortless data analysis in it. EDW Star schema allows the use of ad hoc reporting. And kept sensitive data in co-located Stage with the corresponding mapping to hashed data in EDW. This allows analyzing data while keeping all metrics available.

Outcomes of Project & Success Metrics:

  • Structured and up-to-date key data co-location in cloud EDW

  • Separate cloud DB to load and store low value or inconsistent data for further review and analysis

  • Ability to review data load progress and track the process

  • PHI sensitive data de-identified

Why choose Divectors

A team of professionals with over 11 years of experience that will serve the growing need of your business

We apply standard Project Management processes and procedures that are customized according to client needs and business requirements.

We use the best Design Thinking practices to get to the bottom of the problem

An agile team of software developers, experience designers, project managers and business analysts that apply the best Agile / Scrum practices

Case Studies

We’ve put our experience into helping our customers achieve their business goals. Take a look at some of the projects Divectors successfully worked on:

Centralized data repositories

Building centralized data repositories to drive valuable insights from data


Data exchange


Tackling manual processing for the financial services provider


Data warehouse platform

Creating a centralized place for all the integrated data sources for a pharmaceutical company