Data Analyst - Oracle Processing Team

Overview

POSITION TITLE (Oracle title)

DATA ANALYST

 

WORKING TITLE

Data Analyst-Oracle Processing Team (OPT)

 

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:

Manages and analyzes data related to any employment status changes in the Wake County Public School System’s (WCPSS) Oracle database.  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.

 

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 Teacher licensure system, online State salary system, North Carolina Identity Management (NCID) System, eBenefits, and Automated Educational Substitute Operator (AESOP).

 

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 Processors 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:  2/2024

 

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.