Systems Programmer Analyst

Job Title

Systems Programmer Analyst

Grade 124 (12-Month Contract 260 Days)

Exempt

Technology Services

Manager, Business Applications and/or Director, Technology Services

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.

• 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.

• 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., Rapid Identity, 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…