CEDS Data Warehouse Architect / ETL Lead (SLDS)

CEDS Data Warehouse Architect / ETL Lead (SLDS)

Location: New Hampshire Department of Education, Concord, NH (Onsite / Hybrid)
Type: Contract / Vendor Engagement

Role Overview

NHED is seeking an experienced CEDS Data Warehouse Architect / ETL Lead to modernize and migrate the Statewide Longitudinal Data System (SLDS) to a CEDS-aligned data warehouse. The role focuses on architecture redesign, ETL development, data model alignment, and transition support.

Key Responsibilities

• Review and redesign the SLDS data warehouse using CEDS standards

• Develop and document ETL processes for data migration

• Map the existing SLDS data dictionary to the CEDS data model (GitHub)

• Support parallel runs of legacy and CEDS models during transition

• Provide technical assistance to NHED staff for reporting and transformations

• Design future CEDS-based data marts

• Extend the CEDS model for non-aligned sources (e.g., survey data) per CEDS guidelines

Required Skills

• Data warehouse architecture & ETL development

• Strong SQL / data modeling experience

• Experience with education data systems or SLDS

• Knowledge of Common Education Data Standards (CEDS)

• Strong documentation and collaboration skills

Preferred

• Experience with State Departments of Education

• GitHub-based data models and migrations