Payroll Systems and Data Analyst

University of Oklahoma • Oklahoma City, OK

5d

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.

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

• Timekeeping - Troubleshoot/test/track and work with the vendors/IT/HR for OU timekeeping systems Ecotime and Workforce.
• PeopleSoft Maintenance Support - 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level