Dr. Jay Aguda

Strategic IT & Operations Leader K-12 Education & Enterprise Solutions

I help schools, districts, and charter networks streamline student data, optimize IT operations, and develop data-driven insights. With expertise in Google Cloud, PowerSchool, BigQuery, Apps Script, and scalable ETL pipelines, I specialize in connecting disparate education systems to deliver actionable insights in data warehouses, dashboards, and IT workflows.

How I can Help.

PowerSchool Customization & Integrations

  • Automate reporting, build custom plugins, and connect with external apps.

Data Pipelines & ETL Development

  • Extract, transform, and load (ETL) data from any system with an API (SIS, HR, finance, LMS, etc.) into a centralized data warehouse (BigQuery, Firestore, etc.).

Google Workspace Automation

  • Automate processes across Sheets, Drive, Calendar, and Groups to save time and reduce manual work.

Interoperability Across Departments & Apps

  • Seamlessly connect and sync student, HR, finance, and operations data between platforms, ensuring accurate, real-time updates.

IT Operations / ITSM

  • Oversee IT infrastructure, manage deployments, and optimize cloud-based solutions.
  • Develop and implement scalable IT support systems that improve response times and operational efficiency.

Data Analytics & Dashboard Development

  • Build interactive dashboards and reports using Google Data Studio, Looker, and Power BI to help schools track enrollment, ADA, staffing, and compliance metrics.