Systems Analyst - Oracle Payroll

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., *

• 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 their technical needs and gathers requirements for data integration or enhancements to applications.
• Develops reports and reporting tools to assist Compensation Services Specialists with payroll processing and auditing.
• Oversees data exchange and file transfer processes to ensure they are completed timely and accurately.
• Assists the Systems Administrator team leader in planning and scheduling resources, as needed.
• Stays abreast of project progress and ensure that deadlines are met or revised, as appropriate.
• Ensures acceptable level of customer satisfaction and uses feedback to help improve relationships and work processes.
• Performs other related duties, as assigned.

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., * 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., * 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.