The vendor is required to provide that data infrastructure enhancement and reporting system upgrade at in five schools: faculty of arts and sciences, school of education and human development, school of social work, school of nursing, school of business and school of graduate studies, as well as professional studies and continuing education and summer sessions.
-To collaborate with us on our data infrastructure enhancement/decision support system project.
-The primary goals of:
•Complete all fall reporting using the new data warehouse structure.
•Develop integration to enable our new reporting database to deliver both live and static data.
•Implement and configure an on-prem data gateway cluster (2 nodes) to facilitate the transfer of data from on-premises systems to the cloud/azure server.
•Deploy an azure cloud/reporting server.
-Vendors need to meet the following requirements:
•Experience and expertise:
oProven experience in implementing and managing data warehouse solutions, particularly with server
oDemonstrated ability to handle data integration using
•Technical capabilities:
oProficiency in setting up and configuring data warehouse structures and reporting databases.
oAbility to build and deploy jobs for data migration from people soft to the new reporting database.
oCompetence in setting up on-prem data gateway clusters and azure cloud/reporting servers.
•Project management:
oExperience managing similar data infrastructure projects, including timelines, deliverables, and milestones.
oCapability to work collaboratively with island college and other partners to meet project goals and deadlines
•Data governance and quality:
oKnowledge in implementing data governance practices to ensure data accuracy, completeness, and compliance with reporting standards.
oAbility to improve data quality and capture processes.
•Training and support:
oProvision of training for key users on new systems and tools, particularly microsoft power bi
oProvide all of the documentation related to the project so that staff members can provide the on-going support.
•Reporting and analytics:
oSkills in developing advanced reporting capabilities and interactive dashboards using power bi.
oExperience in designing systems that enhance data-driven decision-making through improved reporting functionalities
•Compliance and security:
oUnderstanding of data security and compliance requirements relevant to educational institutions and state reporting.