Basic Information

Reference Number

0000223862

Issuing Organization

Simon Fraser University

Owner Organization

Simon Fraser University

Solicitation Type

RFP - Request for Proposal (Formal)

Solicitation Number

2022-PD-315

Title

DATA WAREHOUSE SOLUTION

Source ID

PU.AC.BC.836081.C83134

Agreement Types

Canada-European Union Comprehensive Economic and Trade Agreement(CETA)

Canadian Free Trade Agreement (CFTA)

New West Partnership Trade Agreement (NWPTA)

Details

Location

Canada, British Columbia

Delivery Point

Canada, British Columbia, Lower Mainland-Southwest

Description

This Request for Proposals (“RFP”) is an invitation by Simon Fraser University (“SFU”) on behalf of Education Planner BC (EPBC) to prospective proponents to submit proposals to build a data warehouse solution as further described in Part 2 – The Deliverables (the “Deliverables”).

2.1 Description of Deliverables
Education Planner BC (EPBC) delivers several services supporting students and post-secondary institutions (PSI) in the province of British Columbia (BC). They are the following:

Application Service – allows prospective students to register for an EPBC account and complete their admission application form online, which is then sent to the selected PSI.
Student Data Exchange Service – allows the different PSI’s and other interested parties the ability to exchange student data between organizations in a secure environment. An example of student data would be electronic transcripts for high school and post-secondary education.

Every year several hundred thousand applications are created and submitted to the PSI’s, and several hundred thousand transcripts are exchanged within BC. These events generate a large volume of data that EPBC and the PSI’s would like to be able to report on, and analyze, across several dimensions. To support this, EPBC is seeking a vendor to build a data warehouse solution, working with EPBC to capture the relevant data, and provide a rich set of tools, allowing users to query the assembled data and turn it into meaningful insight.
The chosen vendor should provide and facilitate the detailed design, development, and implementation of the data warehouse solution that includes:

Planning, analysis, and detailed technical design;
Development and testing of data reporting platform, including data store and client reporting tools;
Work with EPBC project team to implement data reporting platform
Process, end user and technical documentation;
Technical development, and train-the-trainer training;
Project management;
Post implementation support, for a finite period of time;

Excluded from the deliverables is any extract, transform, and load (ETL) processes, as those will be completed by EPBC staff; however, the vendor will be required to align their work, both in timing and technical design with the work being completed by EPBC.
EPBC uses Agile methodology to manage the software development process; the successful vendor will be expected to follow the same methodology.
EPBC will maintain architectural oversight over the entire project to ensure that the solution delivered aligns with EPBC’s longer term goals and technical vision.

Dates

Publication

2022/05/12 03:28:58 PM PDT

Bid Intent

Not Available

Question Acceptance Deadline

2022/06/07 11:59:00 PM PDT

Questions are submitted online

Yes

Closing Date

2022/06/21 02:00:00 PM PDT

Contact Information

Paul Dhaliwal

7787826840

paul_dhaliwal@sfu.ca

A - Previous Amendment

Bid Submission Process

Bid Submission Type

Electronic Bid Submission

Pricing

In attached document

Bid Documents List

Item Name	Description	Mandatory	Limited to 1 file
APPENDIX B	SUBMISSION FORM	Yes	No
APPENDIX C	RATE BID FORM	Yes	No
APPENDIX D	RFP PARTICULARS - QUESTIONS	Yes	No
APPENDIX E	RISK ASSESSMENT CONTROLLABLE RISKS	Yes	No
APPENDIX F	RISK ASSESSMENT (NON CONTROLLABLE RISKS	Yes	No
APPENDIX G	VALUE- ADDED OPTIONS	Yes	No
No entries

Additional Bidding Instructions

Please submit all Appendices listed above.

© MERX - All rights reserved. No part of the information on this Web Site may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording or otherwise without the prior permission of MERX and the Minister of the participating government department (if applicable). MERX, the Minister nor the Contracting Authority will assume responsibility or liability for the accuracy of the information contained in the publication.