Data Analyst - OPT (Personnel Data)

Data Analyst

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.

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.

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.

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

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.

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

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.