Senior Full Stack Software Developer / Data Systems Architect

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

Senior Full Stack Software Developer / Data Systems Architect Job Description

We are seeking an experienced Senior Full Stack Software Developer / Data Systems Architect to support the design, development, implementation, and maintenance of a statewide School Finance Data System for a State Department of Education.

The selected candidate will play a key technical role in developing a secure, scalable, and user-friendly system for collecting, validating, storing, analyzing, reporting, and sharing financial data from approximately 200 public school districts and charter schools.

The solution will support the implementation of a Uniform Chart of Accounts (UCOA), financial data cross-walking, historical data migration, data validation, workflow management, reporting, dashboards, system integrations, and public-facing analytics.

Key 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 Chart of Accounts (COA) to Uniform Chart of Accounts (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.

Required 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.
• Strong experience designing and developing enterprise-level web applications.
• Experience with modern front-end and back-end development technologies.
• Strong experience with relational databases and SQL.
• Experience designing and developing RESTful APIs and system integrations.
• Experience with ETL processes, data migration, and data warehousing.
• Experience handling large and complex datasets.
• Strong understanding of data modeling, data architecture, and database design.
• Experience developing data validation and business rule engines.
• Experience with role-based access control and application security.
• Experience working in cloud-hosted or enterprise hosting environments.
• Experience with software development lifecycle methodologies, testing, deployment, and production support.
• Experience with version control and source code management tools, including Git/GitHub.
• Strong problem-solving, analytical, and communication skills.

Preferred Qualifications

• Experience developing financial, accounting, government, education, or public-sector data systems.
• Experience with school finance, government financial reporting, or accounting data.
• Knowledge of Chart of Accounts structures and financial data reporting.
• Experience building data dashboards and analytics platforms.
• Experience integrating multiple enterprise applications and databases.
• Experience working with student information systems or education data systems.
• Knowledge of data standards and education data frameworks.
• Experience with historical data migration from Excel and legacy SQL systems.
• Experience developing public-facing data portals.
• Knowledge of FERPA, data privacy, accessibility, and government security requirements.
• Experience working on State or Federal government technology projects.

Desired Technical Skills

Candidates should have experience with several of the following technologies:

• Java, C#, Python, JavaScript, TypeScript, or similar programming languages
• .NET, Java/Spring, Node.js, Django, or similar back-end frameworks
• React, Angular, Vue.js, or similar front-end frameworks
• SQL Server, PostgreSQL, Oracle, or similar relational databases
• REST APIs and web services
• ETL and data integration tools
• Data warehousing and data modeling
• Git and GitHub
• Cloud platforms and enterprise hosting environments
• Business intelligence and dashboard tools
• Automated testing and CI/CD pipelines

Key Deliverables

The selected candidate will contribute to the delivery of:

• School Finance Data Collection System
• Financial Data Warehouse
• UCOA Cross-Walking Tool
• Data Validation and Business Rules Engine
• Secure Data Submission Portal
• Workflow and Approval System
• Historical Data Migration Solution
• APIs and System Integrations
• Financial Reporting and Analytics Tools
• Public-Facing Data Dashboards
• Role-Based Security and Access Controls
• Audit Trails and Change History
• Technical Documentation and System Architecture Documentation
• Testing, Pilot Implementation, Deployment, and Production Support

Project Environment

This role supports a phased implementation that includes:

1. Project planning and technical design.
2. Development of the data collection and warehousing system.
3. Testing using sample and test data.
4. Migration of historical financial data.
5. Development of public dashboards and analytical tools.
6. Pilot implementation with selected school districts.
7. Statewide implementation and ongoing maintenance.