Systems Programmer Analyst

Job Title:

Systems Programmer Analyst

Grade Level/Terms of Employment:

Grade 124 (12-Month Contract 260 Days)

FLSA Status:

Exempt

Work Location:

Technology Services

Immediate Supervisor:

Manager, of Business Applications

General Description:

The Systems Programmer Analyst performs professional, technical, and analytical duties in the development, implementation, integration, support, and continuous improvement of information systems, data pipelines, and reporting solutions that support district operations and instructional programs. Work involves a combination of independent technical work and collaborative project work across multiple functional areas. The role requires the ability to think critically, analyze complex systems, troubleshoot effectively, and manage detailed technical documentation.

Essential Duties and Responsibilities:

Develops, writes, maintains, tests, and implements application code, SQL queries, reports, ETL pipelines, and system integrations to support district operations and instructional programs.

Maintains technical knowledge of core systems, including Student Information, Financial, and Human Resource Management platforms.

Analyzes user needs and business requirements to design effective and efficient technical solutions aligned with district goals.

Designs, develops, and maintains APIs, data pipelines, reports, scripts, and tools to support data interoperability, workflow automation, and operational reporting.

Designs, develops, and maintains complex SQL queries, stored procedures, and database objects to support enterprise data needs.

Develops and deploys ETL processes and packages to support data integration between internal and external systems.

Develops and maintains reports and dashboards using SSRS or equivalent platforms to support district reporting needs.

Leads and executes comprehensive testing of systems, integrations, and reports, including unit, regression, and user acceptance testing.

Monitors and ensures the performance, availability, and security of critical systems, data integrations, and reporting solutions.

Provides technical support, troubleshooting, and resolution for production issues related to supported systems, databases, and reports.

Maintains and updates technical documentation, system architecture diagrams, and database build procedures.

Assists with ensuring data privacy, data governance, and cybersecurity compliance across all systems and applications.

Collaborates with cross-functional teams including Instruction, HR, Finance, IT Infrastructure, and Data & Analytics to support district priorities.

Partners with external vendors and technology partners to manage system upgrades, patches, and service-level agreements.

Supports user training efforts by developing technical resources, documentation, and providing end-user guidance where needed.

Provides training and mentoring to team members to ensure consistency in development standards and application architecture.

Participates in change management activities to support successful adoption of new systems, processes, and reporting solutions.

Continuously explores emerging technologies and recommends improvements to support district innovation, data-driven decision making, and operational efficiency.

Note: Individual System Programmer Analysts may specialize in one or more core areas (e.g., SQL development, data integration/ETL, application development, or reporting) based on district needs and team structure.

Performs other related duties as assigned. Qualifications:

Bachelor's degree in Computer Science, Information Systems, or a related field.

Minimum of five (5) years of progressive experience in application development, systems analysis, database development, and systems integration, preferably in a K-12 public education environment.

Strong programming skills with experience in modern languages such as Python, JavaScript, C#, Java, or equivalent.

Advanced proficiency in relational database technologies and SQL development, including Transact-SQL (T-SQL), stored procedures, functions, views, triggers, indexes, query tuning, and performance optimization.

Experience with ETL tools and techniques, including Microsoft SSIS, flat file processing, large data partitioning, and bulk operations.

Proficiency in developing and maintaining reports using Microsoft SSRS and/or similar reporting platforms.

Experience with cloud platforms (AWS, Google Cloud, Microsoft Azure) and modern SaaS-based systems, including Student Information Systems (SIS), ERP, HR, and Financial platforms.

Familiarity with identity management, data integration, APIs, and middleware tools (e.g., RapidIdentity, Power Automate, Google Admin Console, cloud identity solutions).

Strong understanding of data governance, data privacy regulations, and cybersecurity best practices applicable to K-12 education (e.g., FERPA, CIPA).

Proven experience in database architecture, data modeling, and data pipeline design.

Familiarity with data interoperability standards (e.g., Ed-Fi, OneRoster, Clever) and modern data architecture principles.

Experience with Agile methodologies, iterative development, and modern project management practices.

Excellent analytical, troubleshooting, and problem-solving abilities.

Proven ability to design, document, and maintain secure and efficient application workflows and data architectures.

Experience with large-scale student information systems and data reporting in a public school district preferred.

Strong communication and collaboration skills, with the ability to work effectively across cross-functional teams and with external vendors.

Experience developing and delivering training programs for technical and instructional staff to ensure consistency in development processes and adherence to best practices.

Self-starter with the ability to manage multiple priorities independently in a fast-paced, dynamic technology environment.

Demonstrated adaptability, continuous learning mindset, and ability to thrive in an evolving technology landscape.

General Conditions of Work: Work is primarily performed in an office environment with flexibility for remote or hybrid work arrangements where applicable. The position requires the ability to sit or stand for extended periods, perform light lifting of office items (up to 10 pounds), and engage in repetitive motions such as keyboarding. Vocal and auditory communication is required for collaborative work, virtual meetings, and vendor interactions; visual acuity is necessary for preparing and analyzing written and digital data, working with computer systems, and reviewing technical documentation. The role requires a high degree of accuracy, attention to detail, and adaptability to changing priorities in a fast-paced technology environment. Occasional evening or weekend work may be required to support system upgrades, maintenance windows, or project deadlines.

HOW TO APPLY: All applicants (including RPS employees) must submit an online application. Please access website at:

Please upload the following information with your application: a current resume, transcript and license if applicable. Three references names and contact information will be required if you progress to the interview step of the selection process. Richmond Public Schools will conduct a background investigation, fingerprinting, and tuberculosis screening as a condition of employment. EOE.