Tender for Datawarehouse Implementation Services

UCL has purchased IBM Datastage and IBM CDD to act broadly as the technology underpinning applications integration and data warehousing across the IT estate. It operates a number of applications, including Oracle E-Business Suite for Financials and soon to be HR, SITS for Student Management, Research and Estates applications. UCL would like to contract an organisation to partner with for the development of the central data-warehouse and potentially the implementation of an Operational Data Store (ODS) for the HR implementation project. Data for the central data-warehouse will be transferred from and to multiple database types, including other data-warehouses and datamarts. The transfers may require complex data transformations. They will capture data in both real-time and batch modes. The success of this project will critically depend on a partner with exceptional data modelling skills and experience of developing data-warehouses, especially within the HE sector. Based on their experience and skill, the bidder will be expected to develop data-models for the data-warehouses that meet current needs but also accommodate future needs where these can be reasonably foreseen or expected. Thus the data models developed need to be durable and flexible. The bidder will be required to develop appropriate documentation and configuration activities and deployment plans to help infrastructure architects and operational teams to understand the deliverable. The documentation should enable those not familiar with the installation to i) reapply the solution in a new clean environment with the same configuration as that provided by the bidder and ii) development staff to understand the configuration and development that has been undertaken.