Data Analyst-OPT (Personnel Data)

Wake County Public School System; Cary (NC); Hybrid; USD 52,000 - 74,000; Full time

Job summary

Wake County Public School System is seeking a DATA ANALYST to join the Oracle Processing Team (OPT) in Cary, NC. The role focuses on analyzing employment status changes in the Oracle system and supporting Human Resources queries, with a hybrid telework schedule.

The incumbent will enter and verify personnel data, prepare reports for Board of Education, and collaborate with Budget and Compensation to ensure payroll accuracy and timely processing.

Qualifications

• Associates degree from a regionally accredited college or university.
• Two years of experience in Business, Human Resources, or a related field.
• Experience in analyzing and researching data based on policies and procedures.

Responsibilities

• Analyzes Oracle position data and recommendations for employment and evaluates results to provide solutions.
• Enters personnel information into the Oracle database relating to hires, status changes, salary, licensure, contract information, and more.
• Prepares information for Board of Education reports on new hire and rehire status.
• Collaborates with Budget, Compensation Services to ensure accurate setup and compensation.
• Maintains workflow records of Oracle data and processing.
• Develops knowledge of salary schedules, pay cycles, and employee calendars for accurate data entry.
• Maintains understanding of employee benefits and eligibility as it pertains to contracts.
• Maintains relationships with HR Administrators to transition applicants to employee status in Oracle.
• Communicates employment status changes with Payroll to facilitate accurate processing.
• Ensures monthly payroll cycle deadlines are met.
• Performs other related duties as assigned.

Skills

Excel

Word

PowerPoint

Google Apps

HR data analysis

Communication

Detail oriented

Teamwork

Independent work

Education

Associates degree from a regionally accredited college or university

Tools

Oracle

Job description

Overview

POSITION TITLE (Oracle title)

DATA ANALYST

WORKING TITLE

Data Analyst-OPT (Personnel Data)

SCHOOL/DEPARTMENT

Human Resources-Salary and Information Systems

LOCATION

Crossroads III, Cary, NC

PAY GRADE

Noncertified Grade 26

FLSA STATUS

Nonexempt

ELIGIBILITY FOR EMPLOYMENT CONTRACT

No

WORK WEEK SCHEDULE

Monday-Friday (occasional evenings and weekends) Position is available for a Hybrid Telework workweek

POSITION PURPOSE:

As a member of the Oracle Processing Team (OPT), this position manages and analyzes data related to any employment status changes in the Wake County Public School System’s (WCPSS) Oracle database and assists in responding to questions received in Human Resources, as needed.

MINIMUM QUALIFICATIONS:

KNOWLEDGE, SKILLS, AND ABILITIES (KSAs)

• Considerable knowledge of Microsoft Office, specifically Microsoft Word, Excel (analyzing data and performing calculations using databases and spreadsheets), Power Point; Google Apps;
• Considerable knowledge of interrelated functions between human resources, payroll, and benefit processes;
• Excellent customer service and organizational skills;
• 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 gather and analyze pertinent facts, arrive at conclusions or recommendations, and present information in an easily understood and reportable format;
• Ability to complete complex tasks and minimize errors with attention to detail;
• Ability to work in a team environment;
• Ability to work independently and complete tasks in the absence of clear direction;
• Ability to establish and maintain effective working relationships with school system staff, staff members of external funding agencies, and the community.

EDUCATION, TRAINING, AND EXPERIENCE

• Associates degree from a regionally accredited college or university;
• Two years of experience in Business, Human Resources, or a related field;
• Experience in analyzing and researching data based on policies and procedures.

An equivalent combination of education and relevant experience sufficient to successfully perform the essential duties of the job may be considered.

CERTIFICATION AND LICENSE REQUIREMENTS

None

PREFERRED QUALIFICATIONS:

• Experience with Oracle (in reference to Human Resource functions);
• Experience in a public school setting working in a Human Resources or Payroll department;
• Experience using the online state Licensure and Salary System, North Carolina Identity Management (NCID) System, and the NC Retirement System (ORBIT).

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Analyzes and researches Oracle position data and recommendations for employment (e.g., split positions, end dating positions, researching position history to ensure accuracy, etc.) and evaluates results in order to provide solutions and/or recommendations based on research.
• Enters personnel information, from multiple sources, into the Oracle database application relating to new hires, rehires, status changes, transfers, resignations, salary, licensure, contract information, longevity, and other relevant employment data.
• Prepares appropriate information to be included in Board of Education reports as it relates to the new hire and rehire status.
• Collaborates with other Central Services departments (e.g., Budget, Compensation Services, etc.) to ensure employees are set up and compensated accurately.
• Maintains workflow records of Oracle data and processing.
• Develops a thorough knowledge of salary schedules, pay cycles, and employee calendars to ensure accurate and timely entry of time sensitive personnel data.
• Develops a solid understanding of WCPSS employee benefits and eligibility as it pertains to employment contracts.
• Maintains effective working relationships with Human Resources Administrators and Specialists to transition applicants to employee status in Oracle.
• Communicates employment status and assignment changes with WCPSS’ Compensation Services (Payroll) to facilitate accurate processing.
• Processes employment verification, state service years of service, and the transfer of leave balances.
• Responsible for ensuring that monthly payroll cycle deadlines are met.
• Performs other related duties, as assigned.

WORK ENVIRONMENT/PHYSICAL REQUIREMENTS

This job operates in a professional office environment and has a noise level of mostly low to moderate. 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, staff members of external funding agencies, and the community. Work is considered light physical work, requiring the exertion of up to ten pounds of force.

EFFECTIVE DATE:

10/2025

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.