Program Associate - Application Analyst

Position Title:Program Associate I
- Application Analyst

Location:Fisher Building, 3011 W. Grand Blvd., Detroit, MI 48202

Reports to:Assistant Director, Student Information Systems

Bargaining Unit:OSAS

Benefits Eligible:Yes

Telecommuting Eligibility:Eligible for telecommuting up to 40% (two (2) days per week).

In accordance with the Organization of School Administrators and Supervisors and the Board of Education of the School District of the City of Detroit, the following vacancy is announced.

Position Summary:

As a key member of the Student Information Services (SIS) team, the Program Associate I
- Application Analyst builds and maintains the tools that help schools and central office teams make informed decisions and support students. This hands-on technical role administers and configures Power School and related applications, develops reports, customizes application pages, and troubleshoots application and data flow issues.

Working closely with teams across the District, the Application Analyst turns operational needs and business rules into practical solutions that make student information accurate, accessible, and useful. Successful candidates bring strong technical and communication skills, curiosity, and a willingness to learn how their work supports enrollment, attendance, scheduling, and graduation readiness in a large school district. Experience administering or customizing Power School in public education is preferred;

candidates with transferable application administration and development experience are strongly encouraged to apply.

Minimum Qualifications:

• Bachelor's degree in information systems, mathematics, information science, statistics, or a related field, or equivalent technical experience.
• Exceptional communication skills to translate complex technical concepts into clear, actionable insights, fostering collaboration across teams with varying levels of technical expertise.
• Proficiency in SQL, including independently writing queries with multiple joins, aggregations, and conditional logic, and proficiency in HTML to create and maintain application pages that present query results clearly.
• Proficiency in Microsoft Excel or Power BI for data analysis and visualization, with the ability to present insights in an accessible and impactful way.
• Ability to test reports and system changes, validate data accuracy, and document technical logic and operating procedures.
• Experience administering information systems or database-driven applications, including configuration, user access, and technical troubleshooting.
• Strong analytical and problem-solving skills, including the ability to research unfamiliar systems, learn new tools, and work through ambiguity.
• Ability to manage assigned work and recurring deadlines, follow established procedures, and communicate progress, risks, and support needs promptly.
• Demonstrated ability and willingness to build relationships with school-based staff to understand and address operational challenges, ensuring solutions are practical and impactful.
• Experience with Power School or other student information systems. (preferred)
• Familiarity with public school operations, including enrollment, attendance, scheduling, grading, graduation requirements, or pupil accounting. (preferred)
• Experience supporting operational improvements and the adoption of new tools and processes. (preferred)
• Experience using APIs to retrieve, submit, or update data across applications and support system integrations. (preferred)
• Experience using version control or structured change management practices to document, review, and manage system changes. (preferred)

Essential Functions:

• Administers assigned SIS applications, configurations, user accounts, and…