Data Warehouse Data Mapping Services

The Vendor is required to provide to map its assessment and finance SLDS (State Longitudinal Data System) data warehouse tables to our new CEDS (Common Educational Data Standards) data warehouse model as well as create the necessary ETL (Extract, Transform, Load) code to extract the data from the old databases to the new CEDS data model.
- Provides support for the identification, collection, management, and analysis of educational data to ensure that information is accurate, accessible, and supports department and stakeholder goals.
- Must have five years of prior experience with:
•    Mapping state SLDS warehouses to CEDS data warehouse model and extending the CEDS data model for state specific data.
•    Creating data mart domains.
•    CEDS Upgrades.
•    Creating step-by-step training documentation
- If an element from our SLDS data warehouse does not align with the CEDS data model, the vendor will extend the CEDS data model to incorporate it.
- Develop workflows and processes to Extract, Transform, and Load (ETL) data from the old databases to the new CEDS data model.
- Create 19 data mart domains (e.g., Attendance, membership, graduation & cohort, demographics, assessment, accountability, educators, financial, etc....) from CEDS that closely resemble agency existing data marts.
- Delivery of staff training sessions.
- Work with staff to initially run the old and new data models in parallel until the transition is completed and verified.
- Document all system changes to support end-user knowledge.
- Document all the routines and processes used to generate reports and/or data tables and datasets.