1. CEDS Data Warehouse Architecture Review & Redesign • Deliver a comprehensive advisory report on the CEDS data warehouse architecture for NHED. • Recommend streamlined process workflows showing elimination of redundancies. • Diagram and document future state data warehouse processes. 2. 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 NHED staff. • Delivery of staff training sessions and provide ongoing support to NHED staff related to ETL operations. • Troubleshoot data migration issues within Generate. • Troubleshoot data validation checks. 3. 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. The mapping should be guided by the Common Education Data Standards found at https://ceds.ed.gov/.
