Senior Full-Stack & Data Architect — School Finance

GuruSchools LLP; Concord (NH); On-site; USD 120,000 - 160,000; Full time

Job summary

GuruSchools LLP is seeking a Senior Full Stack Software Developer / Data Systems Architect to design, develop, implement, and maintain a statewide School Finance Data System for the Department of Education. You will build a secure, scalable platform that collects, validates, stores, analyzes, reports, and shares financial data from roughly 200 districts and charter schools.

The role involves creating ETL processes, dashboards, public analytics, and integration with student information systems,

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, Data Science, or a related field.
• 8+ years of experience in software development, systems architecture, or enterprise application development.
• Experience designing and developing enterprise-level web applications.

Responsibilities

• Design and develop a scalable web-based School Finance Data System.
• Design the overall application architecture, database architecture, APIs, and system integrations.
• Develop secure data collection and submission capabilities supporting manual entry and batch file uploads.
• Build functionality to support CSV, Excel, and PDF data submissions.
• Develop data validation rules, including file validations, account code validations, business rules, accounting rules, and anomaly detection.
• Design and implement a flexible COA to UCOA cross-walking solution.
• Develop data workflows supporting validation, certification, approval, error correction, comments, alerts, and notifications.
• Build and maintain APIs to provide secure, direct access to system data.
• Design and implement ETL processes for importing, transforming, exporting, and integrating financial data.
• Migrate and archive historical financial data from Excel and SQL-based systems.
• Develop audit trails, change logs, submission history, and data status monitoring.
• Build reporting and analytics capabilities at the school, district, and statewide levels.
• Develop dashboards that allow users to query, filter, compare, aggregate, suppress, export, and analyze financial data.
• Support calculations and reporting for cost-per-pupil and other school finance metrics.
• Develop public-facing dashboards and data visualization tools.
• Integrate the solution with state-owned databases and external systems.
• Support integration with Student Information Systems and other education-related systems.
• Develop secure role-based access control and permissions.
• Ensure the solution supports development, testing, training, and production environments.
• Optimize system performance for large-scale data queries and reporting.
• Ensure compliance with applicable data privacy, accessibility, and security requirements.
• Participate in system testing, deployment, pilot implementation, statewide rollout, and ongoing maintenance.
• Collaborate with project managers, business analysts, school finance subject matter experts, data analysts, and State stakeholders.
• Prepare technical documentation, architecture diagrams, API documentation, and system design documentation.

Skills

Java

C#

Python

JavaScript

TypeScript

RESTful APIs

Git/GitHub

Cloud platforms

Data modeling

SQL databases

ETL

CI/CD

Data warehousing

Security

Education

Bachelor's degree in Computer Science, Information Technology, Software Engineering, Data Science, or related field

Tools

GitHub

SQL Server

PostgreSQL

Oracle

ETL tools

BI dashboards tools

CI/CD tools

Job description

GuruSchools LLP is seeking a Senior Full Stack Software Developer / Data Systems Architect to design, develop, implement, and maintain a statewide School Finance Data System for the Department of Education. You will build a secure, scalable platform that collects, validates, stores, analyzes, reports, and shares financial data from roughly 200 districts and charter schools.

The role involves creating ETL processes, dashboards, public analytics, and integration with student information systems,