Data Warehouse Design & Development

Establishing a foundation to improve

Building an effective clinical data warehouse is the first stage in creating the infrastructure needed to create scalable support for physicians, nurses, administrators, and researchers to learn from the wealth of information available in transactional systems. By establishing a warehouse organizations can finally measure the key indicators that will ultimately be used to improve the care that patients receive. Unfortunately very few organizations have invested in building a clinical data warehouse to date because of both a lack of clear financial benefit, alternative priorities like EMR deployments, and a lack of understanding of the tools and approaches needed to succeed.

Recombinant provides a full suite of services to establish a data warehouse based on extending our Recombinant Data Trust ETL programs and schema, our PAR provider analytics roadmap methodology, and expert development staff that is custom fit to your organization's needs and capabilities.

Available services include:

• Data security and governance planning and design

• Project management

• Data model extension and datamart design

• Source to target mapping

• ETL (extract transform and load) programming

• Data quality monitoring

• Warehouse validation and testing

Common programming services include:

• Design of XML interfaces like HL7 message handling or scripts to poll applications

• Creation of extraction utilities to pull data from multiple source systems

• Design of production mirrors of application databases through disk or log shipping mechanisms

• Ontology mapping / translations

• System versioning and incremental load process design

• Creation of data quality tools for cleansing and validation

• Ongoing bug/fix and extension of established routines to handle changes in source systems

What Makes Us Different

Flexible approach
Complete outsourcing to "over the shoulder" consultation

Independent
We focus on tools that best meet your needs

Fast
Results in months not years for a rapid return on investment

Dedicated to healthcare
IRB process expertise and HIPAA risk management