Program Associate I, Application Analyst

About the Role

The Program Associate I - Application Analyst is a hands-on technical role within the Student Information Services (SIS) team. This position builds and maintains tools to support informed decision-making and student support across schools and central office teams.

Key Responsibilities

• Administer and configure PowerSchool and related applications.
• Develop reports and customize application pages.
• Troubleshoot application and data flow issues.
• Translate operational needs and business rules into practical solutions for accurate, accessible, and useful student information.
• Administer assigned SIS applications, configurations, user accounts, and permissions.
• Execute and document recurring system procedures and support annual school-year transitions and time-sensitive District operations.
• Investigate and resolve tier 2 and tier 3 application issues, coordinating with IT, vendors, and internal teams.
• Monitor and troubleshoot inbound and outbound data flows, validate successful processing, and configure or develop new integrations.
• Develop, maintain, and improve SQL queries and reports applying complex business rules.
• Create and maintain HTML page customizations and reporting tools.
• Investigate data structures and existing code, research technical approaches, and develop solutions.
• Maintain accurate reports, letters, report cards, transcripts, and other system-generated outputs.
• Communicate complex system processes and solutions clearly, tailoring messages to diverse audiences.
• Build and maintain strong relationships with school and central office staff.
• Collaborate with cross-functional teams on student data initiatives.
• Clarify operational needs, document requirements and business rules, and validate proposed solutions.
• Communicate progress, dependencies, risks, and decisions needed.
• Design and implement processes for high-quality data practices.
• Encourage knowledge-sharing and support organizational improvement through documentation.
• Test reports, configurations, and system enhancements.
• Identify opportunities for operational efficiency and implement scalable improvements.
• Synthesize business rules and priorities into actionable system enhancements.
• Perform other duties as assigned.

Requirements & Tech Stack

• PowerSchool administration or customization in public education (preferred).
• SQL proficiency, including writing queries with multiple joins, aggregations, and conditional logic.
• HTML proficiency for creating and maintaining application pages.
• Microsoft Excel or Power BI for data analysis and visualization.
• Experience administering information systems or database-driven applications.
• Strong analytical and problem-solving skills.
• Ability to manage assigned work and recurring deadlines.
• Ability to build relationships with school-based staff.
• Familiarity with public school operations such as enrollment, attendance, scheduling, grading, graduation requirements, or pupil accounting (preferred).
• Experience supporting operational improvements and adoption of new tools/processes (preferred).
• JavaScript, jQuery, or CSS experience for application customization (preferred).
• Experience using APIs for data retrieval, submission, or updates (preferred).
• Experience using version control or structured change management practices (preferred).

Qualifications

• Bachelor's degree in information systems, mathematics, information science, statistics, or a related field, or equivalent technical experience.
• Exceptional communication skills.
• Ability to test reports and system changes, validate data accuracy, and document technical logic and operating procedures.
• Strong analytical and problem-solving skills, including researching unfamiliar systems, learning new tools, and working through ambiguity.
• Demonstrated ability and willingness to build relationships.
• Experience with PowerSchool or other student information systems (preferred).