Analyst II, Computer Systems - 250 Days

Prince William County Public Schools; Virginia; On-site; USD 101,000 - 163,000; Full time

Job summary

Prince William County Public Schools is seeking a systems analyst to design, test, and implement computer-based solutions across HR, SIS, finance, and payroll.

The role involves leading projects, coordinating with staff, and ensuring feasibility and compatibility of new systems, with a strong emphasis on testing and documentation.

Applicants should have a degree in information systems or computer science and several years of relevant experience.

Qualifications

• Deep knowledge of analysis, design, and documentation of software systems.
• Extensive testing knowledge including test cases and validation.
• Strong database management system knowledge.
• Experience with system installation, maintenance, and troubleshooting.
• Familiarity with SQL, Oracle, JavaScript, HTML, C#, Visual Basic, .NET, Crystal Reports.
• Awareness of AI tools and concepts.
• Ability to define requirements by engaging stakeholders and analyzing processes.
• Ability to document complex systems clearly, including manuals and job aids.
• Capable of leading and mentoring junior team members.

Responsibilities

• Analyzes HR, SIS, finance, and payroll software to develop specs and end-user docs.
• Plans, designs, installs, and tests integrated database solutions.
• Recommends improvements to applications and procedures.
• Develops data security, backup, and recovery procedures.
• Helps users identify needs and plan system requirements.
• Functions as a project leader.
• Adheres to department schedules and policies.
• Participates in ongoing professional development.
• May be assigned to IT or Finance department.

Skills

Software analysis

System testing

Database knowledge

Programming languages

AI familiarity

Leadership

Documentation

Time management

Mentoring

Help desk support

Education

Bachelor’s degree in information systems or computer science

Associate degree + 7 years experience

Tools

SQL

Oracle

JavaScript

HTML

C#

Visual Basic

.NET

Crystal Reports

CGI HR Advantage

Job description

This position is primarily concerned with the analysis of subject matter processes or problems and the design, testing, and implementation of systems to accomplish work through application of computer technology. This position is responsible for independently carrying out the work and coordinating with staff and other school officials. Completed work is reviewed from an overall standpoint of feasibility, compatibility with other work of the organization.

Salary Range: $100,853 - $163,483 annually, plus a comprehensive benefits package.

Essential Responsibilities - specific to this job

• Analyzes Human Resource, SIS, finance, and/or payroll software systems and reporting requirements to develop detailed specifications, test case scenarios, and end-user procedures and documentation.
• Plans, designs, installs, and tests integrated database solutions.
• Recommends improvements to existing applications and procedures.
• Develops procedures for protecting and monitoring the security of data and databases, including procedures for recovery and backup.
• Helps users to identify needs and plan for system requirements.
• Functions as a project leader.
• Adheres to schedules, procedures, policies, and performance requirements of the assigned department.
• Participates in professional development to keep up to date on job knowledge and technical advances.
• This position may be assigned to the Department of Information Technology or Department of Finance

Knowledge, Skills, Abilities and Behaviors

• Thorough knowledge of the principles, practices, processes and techniques involved in the analysis, design, and documentation of computer software systems.
• Thorough knowledge of functional and non-functional testing processes and procedures.
• Thorough knowledge of database management systems.
• Thorough knowledge of systems installation, maintenance, and troubleshooting.
• Thorough knowledge of computer capabilities, processes, and programming languages, and programs such as SQL, Oracle, Java Script, HTML, C#, and Visual Basic, .NET and Crystal Reports.
• Familiarity with Artificial Intelligence (AI) tools and concepts.
• Ability to identify and define application problems or needs by conferring with stakeholders, analyzing technical and functional subject matter, and evaluating processes and procedures.
• Ability to develop specifications and solutions based on the analysis of the system as well as related documentation, regulations, laws, and other state, local and federal requirements.
• Ability to define a testing strategy, and then lead, guide, monitor, and execute the testing processes including the creation of structured test cases and validation of results.
• Ability to prepare clear and concise documentation of complex computer systems, write instructional guides, reference manuals, tip sheets, and job aids for computer software and hardware-must have an excellent command of grammar and punctuation.
• Ability to maintain technical interfaces between various applications and databases.
• Ability to support functional departments through the application of software components and their execution.
• Must be able to learn and clearly describe complex processes such as installation, setup, and software functions.
• Ability to provide leadership and mentoring to junior team members and plan work for others.
• Ability to provide support to help desk, testing, and training personnel.
• Must have excellent logical and critical thinking skills, excellent attention to detail and time management skills, and the ability to learn at a fast pace.

Education or Equivalency Requirements

Bachelor’s degree with major course work in information systems or computer science, plus five (5) years of relevant experience preferred.

Minimum of an associate degree plus seven (7) years relevant experience

Work Experience Requirements

Minimum of five (5) years of systems analysis and design, systems testing, systems documentation and systems development; or any combination of experience and/or training that would provide knowledge, abilities, and skills for this position.

Some portion of human resources and payroll systems preferred for finance assignments.

Some knowledge of CGI HR Advantage preferred for finance assignments.