(1) Vendor needs to provide generate software implementation service to the government authority located in Concord, NH. – Agency is seeking a qualified consultant to help existing staff complete its implementation of the Generate software, an application based upon Common Education Data Standards (CEDS) for all EDFacts files. • CEDS Data Warehouse Architecture Review & Redesign:– Deliver a comprehensive advisory report on the CEDS data warehouse architecture for agency.– Recommend streamlined process workflows showing elimination of redundancies.• ETL Development and Documentation Package:– Development and oversight of ETL processes for approximately 82 EDFacts files into Generate.– A complete set of process and procedure documentation, including step–by–step training guides for agency staff.• ETL Processes for Migration of the CEDS Data Warehouse:– Develop workflows and processes to Extract, Transform, and Load (ETL) tables and views to the new CEDS data warehouse.– Develop implementation plans for extending the CEDS data model in the event that the NHED Statewide Longitudinal Data System (SLDS) data warehouse does not align with the CEDS data model.• Extract all data from the CEDS data model that is needed for Generate and the ETL from the existing Access database used for Edfacts reporting into the Generate Database.• Provide technical assistance to agency staff with any transformations needed to transition the new CEDS data model to be the new primary SLDS Reporting to streamline operations.• Develop future data marts using CEDS as the source.(2) All the questions must be submitted no later than January 19, 2026.(3) The contract period will be for three years.