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.