Data Warehouse Architect to diagram and enumerate SHYFT environment (Phase 1)

Project Description

We are an acquisitive Pharma company (no R&D) and as such we acquire companies that often have disparate data platforms. We are trying to build two sovereign data platforms (one for Commercial Sales Division and Corporate and the other platform for Consumer Sales and Lab). We would also like to create an MDM structure which bridges the two with ETL processes on either side to protect data flow. In the short term, we need to fully understand the architecture and design of our current analytics platform for our Commercial Sales/Corporate world.

Phase 1 requires that we fully understand the architecture and design of our Shyft environment as it relates to Commercial Analytics, contracts, reimbursement, etc.  It was designed and built by prior personnel and no Design Docs were issued.  The role will fully enumerate, document and present on the architecture of the Shyft environment, working with the Commercial Analytics team SME's.  

The role will then, in tandem work with the Commercial Analytics team SME's, present a proposal on a design that meets the current and future needs of the business including, but not limited to: Commercial contract reimbursement, reporting, Tableau connectivity and related functions.

This outcome will allow us to create a new process structure for contract and reimbursement data flow into the Shyft environment to be used to provide a single source of truth for this data.