Enterprise Applications & Data Platform - SIS, LMS, Data Warehouse & Data Quality
Howard County Public School System (HCPSS)
Howard County Public School System (HCPSS) - Enterprise Applications & Data Platform - SIS, LMS, Data Warehouse & Data Quality
The Challenge
Multi-system data platform governance with Snowflake warehousing, MSDE state reporting, and FERPA-aligned access controls maps directly to U.S. Department of Education, state SIS modernization, and federal data-quality / master-data-management evaluation criteria. Demonstrates single-source-of-truth delivery across SIS, LMS, ERP, and analytics layers.
The Solution
Synergy SIS (Edupoint) | Canvas LMS (Instructure) | Snowflake | Workday ERP | MS SQL Server | OneRoster / SIF Rostering | Power BI | Cloud ELT | Active Directory SSO / MFA
Implementation
Antony Jayaraj (Director, Data Engineering)
Results
Unified four interdependent platforms - Synergy SIS, Canvas LMS, Snowflake data warehouse, and data quality - under one governance umbrella as a single source of truth
SIS-to-LMS rostering integration (OneRoster / SIF) auto-provisioning Canvas courses and users from authoritative Synergy records
Enterprise Data Warehouse on Snowflake consolidating student, staff, course, attendance, assessment, and finance data into conformed dimensional models
Cross-cutting data quality layer profiling, validating, and reconciling records at every system handoff before anomalies propagate downstream
MSDE state-compliance reporting datasets produced from curated, FERPA-aligned extracts
Role-based access aligned to Active Directory groups with row/column-level controls on sensitive student data
“Unified four interdependent platforms - Synergy SIS, Canvas LMS, Snowflake data warehouse, and data quality - under one governance umbrella as a single source of truth”