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 specific indicators that can 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 Electronic Medical Record (EMR) deployments, and a lack of understanding of the tools and approaches needed to achieve defined targets.

Recombinant By Deloitte provides a suite of services to establish a data warehouse based on extending our Recombinant By Deloitte Data Trust Extract, Transform, and Load (ETL) programs and schema, our provider analytics roadmap (PAR) methodology, and specialist development staff that is assigned 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 programming
• Data quality monitoring
• Warehouse validation and testing

Common programming services include:

• Design of Extensible Markup Language (XML) interfaces 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

Outsourcing to "over the shoulder" consultation

Independent

We focus on tools that better meet your needs

Fast

Results in months not years for a prompt return on investment

Dedicated to healthcare

Institutional Review Board (IRB) process knowledge and Health Insurance Portability and Accountability Act (HIPAA) risk management