Systems Analyst - Oracle Payroll

Overview

POSITION TITLE (Oracle title)

PAYROLL SYSTEMS ANALYST

WORKING TITLE

Oracle Payroll Systems Analyst

SCHOOL/DEPARTMENT

Compensation Services

LOCATION

Crossroads II, Cary, NC

PAY GRADE

Technology Grade 17

FLSA STATUS

Nonexempt

ELIGIBILITY FOR EMPLOYMENT CONTRACT

No

WORK WEEK SCHEDULE

Monday-Friday (occasional evenings and weekends) Position is eligible for hybrid telework workweek

POSITION PURPOSE:

Assists Compensation Services through technical support, database report writing, and payroll processing. Manages data exchange processes and ensures data integrity between Wake County Public Schools (WCPSS) and service providers. Serves as a liaison between Compensation Services and Technology Services, processing support requests and assisting with project management.

MINIMUM QUALIFICATIONS:

KNOWLEDGE, SKILLS, AND ABILITIES (KSAs)

• Considerable knowledge of Microsoft Office, specifically, Microsoft Word, Excel, Power Point; Google Apps; including proficiency with Excel formulas and pivot tables;
• Considerable knowledge of Oracle Enterprise Software as it applies to Payroll and Benefits processing and Business Intelligence reporting tools;
• Considerable knowledge of Structured Query Language (SQL);
• Considerable knowledge of database systems with the ability to analyze and organize data within large, complex databases;
• Considerable knowledge of electronic project management tools;
• Effective time management skills;
• Critical thinking and problem-solving skills;
• Ability to complete complex tasks and minimize errors with attention to detail;
• Ability to work independently and complete tasks in the absence of clear direction;
• Ability to communicate clearly and concisely both in oral and written form using a variety of communication techniques and tools to ensure the appropriate flow of information, collaborative efforts, and feedback;
• Ability to establish and maintain effective working relationships with school system staff, external agencies, and vendors.

EDUCATION, TRAINING, AND EXPERIENCE

• Bachelor's degree from a regionally accredited college or university in computer science, engineering, business, math, or related field;
• Three to five years of related experience;
• Evidence of successful project management experience with reportable outcomes;
• Other combinations of applicable education, training, and experience which provide the knowledge, skills, and abilities necessary to perform effectively in the position may be considered.

CERTIFICATION AND LICENSE REQUIREMENTS

None

PREFERRED QUALIFICATIONS:

• Experience using SQL programming and working with Oracle business applications within accounting or payroll systems;
• Experience using Splash BI reporting tools to manipulate data sets and generate reports;
• Knowledge of large school district business operations.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• 1. Serves as the primary backup to the Systems Administrator by providing operational support for enterprise payroll and compensation systems, assisting with system administration functions, maintaining business continuity, and supporting critical system processes during absences or peak operational periods.
  2. Maintains comprehensive knowledge of Compensation Services business processes, Oracle functionality, payroll systems, and data integration to support efficient operations and continuous process improvement.
  3. Manages multiple projects while supporting Compensation Services operations; supports existing applications by acting as a liaison for problem and operational issue resolution.
  4. Stays abreast of Help Desk issues that relate to assigned business processes and assist in their resolution.
  5. Performs software testing for all updates and enhancements of payroll systems applications for quality assurance.
  6. Works with Compensations Services staff to evaluate their technical needs and gathers requirements for data integration or enhancements to applications.
  7. Develops reports and reporting tools to assist Compensation Services Specialists with payroll processing and auditing.
  8. Oversees data exchange and file transfer processes to ensure they are completed timely and accurately.
  9. Assists the Systems Administrator team leader in planning and scheduling resources, as needed.
  10. Stays abreast of project progress and ensure that deadlines are met or revised, as appropriate.
  11. Ensures acceptable level of customer satisfaction and uses feedback to help improve relationships and work processes.
  12. Performs other related duties, as assigned.

WORK ENVIRONMENT/PHYSICAL REQUIREMENTS

This role routinely uses standard office equipment such as computers, scanners, and copiers. The position, at times, must be able to come into direct contact with school system staff, students, and the community. Work at times requires the ability to lift, carry, push, pull, or exert up to 10 pounds. Physical requirements are consistent with those for light work.

EFFECTIVE DATE:9/2026

DISCLAIMER: The above statements are intended to describe the general purpose and responsibilities assigned to this position. They are not intended to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and skills required by the employees assigned to this position. This description may be revised by HR and approved at any time.