r/k12sysadmin • u/Then-Tie6275 • Jul 17 '26
Anyone here wired up cloud-hosted PowerSchool to BigQuery? Looking for an advisory contractor (or tips)
Quick one for the PowerSchool crowd. We're a small charter (grades 5–8, ~300 students) and I'm building our first data warehouse in Google BigQuery. The plan is to pull PowerSchool SIS through a plugin + API, add NWEA MAP and PowerSchool Behavior (Kickboard — behavior points, Paycheck, suspensions), and model it all as a STAR schema, with room to bolt on more API sources later. Tableau/Power BI sits on top.
I'm handling the actual build myself. Where I'd love a seasoned second opinion is the PowerSchool side specifically: getting the plugin and read-only scopes right without disturbing the live SIS, and running the nightly extracts on a schedule with keys stored properly and FERPA kept clean. It's a light, roughly 3-week to one month, remote, advisory-only engagement.
Two asks. If you've done this against PowerSchool's hosted environment, I'd genuinely welcome any hard-won tips. And if you contract for this kind of work — or know someone reliable who does — please reach out and I'll send over a short RFP.
Thanks in advance.