Job Number:

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 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.

Required Education and Experience: 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.

Skills:

• 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

Certifications: None.

Advertised Physical Requirements:

• Physical:
  • Sitting for prolonged periods.
  • Engage in repetitive motion.
  • Manual dexterity.
  • Able to communicate effectively.
• Environmental:
  • Standard office environment.

Departmental Preferences:

• 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

Why You Belong at the University of Oklahoma: The University of Oklahoma values our community's unique talents, perspectives, and experiences. At OU, we aspire to harness our innovation, creativity, and collaboration for the advancement of people everywhere. You Belong Here!

Equal Employment Opportunity Statement: The University, in compliance with all applicable federal and state laws and regulations, does not discriminate on the basis of race, color, national origin, sex, sexual orientation, marital status, genetic information, gender identity/expression (consistent with applicable law), age (40 or older), religion, disability, political beliefs, or status as a veteran in any of its policies, practices, or procedures. This includes but is not limited to admissions, employment, housing, financial aid, and educational services.