Systems Analyst - Oracle Payroll

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:

• 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.
• Maintains comprehensive knowledge of Compensation Services business processes, Oracle functionality, payroll systems, and data integration to support efficient operations and continuous process improvement.
• Manages multiple projects while supporting Compensation Services operations; supports existing applications by acting as a liaison for problem and operational issue resolution.
• Stays abreast of Help Desk issues that relate to assigned business processes and assist in their resolution.
• Performs software testing for all updates and enhancements of payroll systems applications for quality assurance.
• Works with Compensations Services staff to evaluate…