This project is for the design, and implementation of a Data Warehouse built using MS SQL 2005. The project requires a solid understanding and experience in developing star schemas for ecommerce retail transaction data as well as page and session level data warehouse design. We currently have a well normalized OLTP SQL 2000 database which has detailed transaction data from our eccommerce system as well as detailed records for page views and sessions. The developer who will be best candidate for this project must show some sample schemas and will be questioned via Private message on their expertise. Knowledge and experience with ETL features of SQL 2005, reporting services and SQL Server OLAP/MDX will be a big plus for this project and for ongoing development and reporting work throughout the year.
*** All candidates for this project must contact by Private Message their experience directly in this areas AND a sample eccommerce transaction star schema, AND a sample page and session star schema, AND a few examples of useful non trivial queries and what they return as an example of your domain knowledge in this area***