Database Analyst jobs in Rockford, IL

POSITION SUMMARY:

Under the general direction of the HR Director, the HRIS Analyst participates in the support of HR systems and process design, HR systems configuration, data standards, reporting and analytics.  This position assists the HR Director in partnering with Information Services and Finance in analyzing, configuring and testing for system enhancements and upgrade projects. 

The HRIS Analyst requires an understanding of current HR business processes and will work with others to identify process improvements and translate customer needs and requirements into technical and functional specifications.   

This position prepares reporting solutions, analytics and ad hoc or recurring reports from multiple HR data sources using Meditech, OHM, Oracle OTBI, Oracle BI Publisher, SQL, Excel, etc. 

EDUCATION/TRAINING:

Bachelor’s Degree in Business or IT (or equivalent work experience)

LICENSURE/CERTIFICATION:

N/A

EXPERIENCE/SKILLS/ABILITIES:

MINIMUM EXPERIENCE

• 1 Year of work experience in SQL query writing, data interpretation, and report creation to include working with subject matter experts to identify functional requirements and translating those in conjunction with ITS into clear and actionable technical specifications.

PREFERRED EXPERIENCE

• Experience working with Oracle Cloud, Meditech, OHM, other HRMS systems

REQUIRED SKILLS, KNOWLEDGE, AND ABILITIES

• Report writing/interpretation
• SQL preferred and should be mastered within one year.
• Project Management concepts
• System documentation
• End user training
• Data analysis
• HRIS/database management
• Skills in Microsoft Word, Excel, and Access
• Customer service
• Requirements gathering

ESSENTIAL FUNCTIONS:

1. Prepares ad hoc and recurring reports for employee data contained in the HRIS and/or other HR data sources in response to requests from users within Human Resources and from users in other departments within UW Health and works with requestors to refine reporting requirements to ensure the underlying business needs are met.

1. Provides end user support on HRIS supported systems.

1. Participates and provides support for HRIS projects in conjunction with HR, IS and departmental leaders to provide solutions to a variety of UW Health business operation and HRIS needs.

1. Works on problems of various scopes where analysis of issues or data requires a review of identifiable factors; exercises significant judgment within defined procedures and practices to determine appropriate action; recommends changes to existing procedures and practices based on analysis of data.

1. Understands HR systems/database relationships, data flow and dependencies, query and reporting concepts and development.

1. Cross trains with others on the team to provide maximum flexibility within the team and facilitating optimal customer service to end users.

1. Maintains OHM Associate Health System, Meditech and Oracle Cloud HCM data tables, structures, files and interface requirements. Ensures the integrity of the HR system data.

1. Applies data integrity protocols between HR and departments internal to the HR module

as well as protocols between Meditech, Oracle Cloud HCM, other HR systems, and external business partners.

1. Participates on HRIS/IS teams, interdepartmental committees/subcommittees, focus groups and meetings.

1. Responds to requests for surveys and labor statistics to other colleges, government agencies, and professional associations.

1. Develops HR data analytics and statistics, utilizing a variety of reporting tools, dashboard tools, and data sources to deliver actionable data to UW Health leadership.

1. Develop materials for user training and education, partner with SME on user support materials.