Payroll Systems and Data Analyst

The University of Oklahoma•Oklahoma City, OK

About The Position

This position would support both OU campuses. Manage ACA compliance data and ensure accurate and timely reporting. Act as a crucial link between payroll, HR, and IT departments, playing a key role in ensuring the accuracy, efficiency, and compliance of the organization's payroll and timekeeping systems and processes. Duties\: Timekeeping - Troubleshoot/test/track and work with the vendors/IT/HR for OU timekeeping systems Ecotime and Workforce. PeopleSoft Maintenance Suppor t - Lead system updates for the payroll teams to include, but not limited to, PeopleSoft quarterly tax system updates, annual Tools/Pum updates, troubleshoot/test/track PeopleSoft system issues/enhancements in Jira ticketing system, working with IT and HR. Responsible for ACA Compliance and Reporting for OU - Work with HR and IT to ensure the files feed to the University ACA vendor are accurate and timely. Analyze data and compliance requirements working with HR for law required actions. Verify year end data and reporting for all ACA requirements. Review/Publish 1095c forms. Payroll Statistics - Update and create payroll queries and reports to analyze trends and report to leadership. Other Duties - Performs various duties as needed to successfully fulfill the function of the position.

Requirements

Bachelor's degree in Computer science, Information technology, or related field, (e.g. Mathematics, Statistics, or Business Administration), AND : 24 months experience system/data analyst or related experience
Equivalency/Substitution : Will accept 48 months related experience in lieu of the Bachelor's degree for a total of 72 months related experience.
Knowledge of MS SQL Server
Advanced computer skills in accounting software and databases
Advanced Excel proficiency (including pivot tables, formulas, and data analysis)
The ability to analyze payroll data, identify trends, generate reports, and translate complex data into actionable insights is crucial for efficiency improvements and problem-solving.
Ability to interpret and comply with federal/state/local regulations
Excellent attention to detail
Ability to set priorities and meet deadlines
Excellent organizational, problem-solving, and multiple project management
Detail oriented for accuracy of data and information
Ability to effectively communicate verbally and in writing
Ability to build rapport with department colleagues and vendors
Ability to produce reports and complete work within deadlines
Strong initiative to solve problems in a timely manner

Nice To Haves

Advanced SQL and query report writing skills
Proven ability to gather requirements and create a functional specification that can be worked on by a developer
Proven ability to manage and execute system testing
ACA Compliance experience
PeopleSoft HCM experience
Timekeeping experience
Payroll experience
Project Management experience

Responsibilities

Manage ACA compliance data and ensure accurate and timely reporting
Act as a crucial link between payroll, HR, and IT departments
Troubleshoot/test/track and work with the vendors/IT/HR for OU timekeeping systems Ecotime and Workforce
Lead system updates for the payroll teams to include, but not limited to, PeopleSoft quarterly tax system updates, annual Tools/Pum updates
Troubleshoot/test/track PeopleSoft system issues/enhancements in Jira ticketing system, working with IT and HR
Work with HR and IT to ensure the files feed to the University ACA vendor are accurate and timely
Analyze data and compliance requirements working with HR for law required actions
Verify year end data and reporting for all ACA requirements
Review/Publish 1095c forms
Update and create payroll queries and reports to analyze trends and report to leadership
Performs various duties as needed to successfully fulfill the function of the position