PeopleSoft Time & Labor Analyst

PeopleSoft Time & Labor, PS Query, SQL
Full Time
Depends on Experience
Work from home available

Job Description

Reporting to the TL Manager, HRPC Data Integrity, the incumbent runs audit reports (daily, weekly, monthly etc.) and corrects/updates data accordingly.  S/he analyzes daily workflow issues, provides periodic status reports, and reports pertinent findings and recommends solutions.  The TL Analyst, HRPC Data Integrity, is responsible for the direct day-to-day maintenance, review and validation of the data, including but not limited to: supporting all activities related to Time and Labor processing and operations, including scheduling and monitoring the Time and Labor Administration process;  Time and Labor timesheets, absence management information, electronic hire/rehire data elements and position management information. 

Under direction of the TL Manager, HRPC Data Integrity, s/he troubleshoots Time and Labor and support activities, including resolving time exceptions; resolving discrepancies to ensure timeliness of payroll processing; supporting Departmental Time Administrators, Supervisors, and Managers in troubleshooting process issues.  Works with Payroll, Benefits and other HRPC Managers as part of a team to direct/assist the HR Service Center Analysts, provide appropriate information so that accurate/timely responses can be delivered. Collaborates with all units internal and external to HRPC to ensure accurate data is ready in the system for processing of payrolls (weekly, bi-weekly and monthly) and ensures/maintains an even (regular) workflow to effectively meet all payroll deadlines. 


  • The TL Analyst reviews all payroll information related to the Time and Labor module of PeopleSoft, including analysis of timesheet and absence data to ensure accuracy so that system configurations work as expected. Executes time administration processes and reports; responds to employee inquiries relating to timekeeping, payroll and HRIS issues; monitors manager/time reporter compliance by performing periodic system and time audits; and assures timely and accurate data entry of individual employee profiles and time approval groups.

  • Creates and/or updates work schedules, reviewing accruals and takes, and correcting other data as needed. Creates and runs ad hoc queries and prepares Time and Labor reports for Senior Leaders and Departmental Time Administrators; reviews and prepares payline adjustments; analyzes and assists in the resolution of cross-functional exceptions errors associated with the Time Administration process within the PeopleSoft Human Capital Management (HCM) System.

  • Working with the TL Manager, tracks, corrects and documents defects identified during system testing.  Performs fit/gap analysis and analysis on new and/or corrected features. Collaborates with HRIS and CUIT teams as well as other functional and technical subject-matter experts University-wide to develop and test specifications of and functionality of TLAM specifically but also other new programs including but not limited to additional components of HCM, interfaces, updates or fixes to existing programs generally.  Contributes to the development and testing of changes/enhancements requests; assists with implementation of these and other systematic resolutions to production and other environments.
  • Performs daily, weekly, and monthly audits on time and labor as well as bio-demo, salary, job and position data. Updates/corrects information in the system to ensure accuracy for payroll runs. Verifies and corrects when necessary, any union information that does not adhere to the language of the Collective Bargaining Agreements (CBA), especially as it relates to TLAM.
  • Analyzes and reviews trends and works with the HRPC TLAM team to assist in the development of new TLAM and/or other data audits as needed.

    Reviews issues escalated by the HR Service Center Analysts to Tier 2, conducts analysis and research to resolve issues or provide answers to the Analysts to resolve at Tier 1.

    Processes Faculty and/or Administrative position requests and/or organizational changes.
  • Performs related duties and responsibilities as assigned or requested.

Minimum Qualifications

Minimum Qualifications: Bachelor's degree and/or equivalent required. Two years of related experience, preferably in an HRIS or Payroll environment that includes management of multiple processes. Strong computer skills and experience with PeopleSoft required. Experience with PS Query required.
Additional Requirements: Demonstrated ability to work in a high pressured, fast-paced environment. Demonstrated excellence in a variety of competencies including: teamwork, analytical thinking, and client/customer awareness. Ability to work with changing priorities and with multiple projects. Requires excellent oral and written communication skills and strong interpersonal skills. Ability to be precise and attention to detail is essential.

Preferred Qualifications

Experience with process management/improvement preferred. Experience with SQL preferred.

Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.

Dice Id : 10115520
Position Id : 513399
Originally Posted : 4 weeks ago
Have a Job? Post it