Systems Analyst - Oracle Payroll

Wake County Public School System•Cary, NC

4d•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

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