A Multi-Tenant Student Information System for Private Education

Project Overview

Our client, a private education provider operating multiple campuses across Ontario, Canada, serves more than 400 students of all ages, from young children to adults. Their legacy application could no longer keep pace with how the organization actually runs day to day: records, scheduling, attendance, progress and family communications were scattered across spreadsheets and disconnected tools, and reporting was slow and unreliable. Leadership engaged us to replace the legacy system with a single modern platform that could run the entire operation, migrate years of history with zero loss, and provide a foundation that could scale to additional locations - and eventually to other organizations - under strict data isolation.

Domain

Technology Design & Development

Year

2026

Duration

3 Months

The Challenge

A fragile legacy system that could not model how a multi-campus, all-ages education provider actually operates.
Student records, attendance and progress tracking fragmented across spreadsheets and disconnected tools.
Years of historical data that had to be migrated with zero loss and no disruption to operations.
A need for a scalable, secure foundation that could serve multiple locations - and additional organizations - under strict data isolation.

The Solution

We designed and built a production, multi-tenant Student Information System from first principles - a modern, bilingual, mobile-first web application that runs the provider's entire operational spine, delivered end to end from data model through migration to launch.

Platform & Architecture

True multi-tenant SaaS with hard data isolation, so a single codebase can serve additional campuses and independent organizations with no cross-organization access.
An organization-scoped identity model with a clear role hierarchy - from administrators to program staff, teachers, guardians and students - that unifies the multiple roles one person may hold.
Passwordless, one-time-passcode sign-in for simple, secure access on any device.
A cloud-hosted architecture with separate web, application and database services, SSL, and environment-scoped configuration.

Core Capabilities

Student, family and teacher records with program, section and term management, and controlled student transfers between programs.
A bespoke progress-tracking engine that follows each student's advancement through a structured curriculum, with teacher-verified milestones, an append-only verification ledger, and a configurable rewards system.
Smart attendance tied to scheduled sessions, with manual override.
Bilingual (English and French) family communications - templated and broadcast messaging with scheduling, delivery and read status, and full conversation history.
Guided term-registration and re-enrolment campaigns with reminders and structured responses.

Data, Migration & Analytics

A derive-from-facts analytics layer feeding in-app dashboards and external business intelligence, covering progress velocity, attendance, retention and cohort benchmarking.
An archive-never-destroy retention model, so historical reporting is preserved even as students and records change over time.
A complete, repeatable migration from the legacy platform - including identity de-duplication and contact normalization - completed with zero historical data loss.
Hosted technical documentation, a callable API reference and an in-app help centre for long-term maintainability.

The Results

The engagement put a modern platform into production, replacing the legacy system while preserving every record.

Modern platform in production: a bilingual, mobile-first SIS now runs the provider's entire operation across every campus.
Zero data loss: years of historical records were migrated through a repeatable, audited process.
Defensible analytics: leadership gained trustworthy insight into progress, attendance and retention, built on an integrity-first data model.
A scalable foundation: a true multi-tenant architecture ready to onboard additional locations and organizations under strict isolation.
Independent operation: complete documentation, an in-app help centre and a full handover positioned the client to run and extend the platform themselves.

Conclusion

By modelling the organization's real operations from first principles - rather than forcing them into an off-the-shelf tool - we delivered a platform the client owns and can grow. The result is a defensible, analytics-driven operation and a reusable multi-tenant foundation that turns a one-time build into a long-term asset.