Payroll Systems and Data Analyst
Share
Job Location:
Oklahoma City, OK - USA
Monthly Salary:
Not Disclosed
Posted on:
18 hours ago
Vacancies:
1 Vacancy
Job Summary
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 organizations 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: Bachelors 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 Bachelors 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 communitys 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.
Required Attachments
Documents required for this position are listed under the Required Attachments section of this job listing. You will be required to upload and attach these documents in the application process.
Required Experience:
IC
Key Skills
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Data Visualization
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
