HRIS DATABASE AND ANALYTICS SPECIALIST II

Shift:Monday - Friday, 8:00am - 5:00pm

Department: HR Information Systems

Compensation:

* Base Pay Range: $59,322 - $96,762 per year, based on experience

ABOUT THE JOB

The HRIS Database and Analytics Specialist II is responsible for monitoring, maintenance, and operational support of HR data resources. Maintain reliability, stability, and data integrity of databases and other data sources. Provide support in the administration, backup, integrity, and security of various databases, automated systems, and enterprise software. Responsible for weekly, monthly, quarterly, annual, and ad-hoc report design and distribution. Continually assess, improve, and optimize our current data environment.

ABOUT MU HEALTH CARE

At MU Health Care, we have an inspired, hard-working and collaborative environment driven by our mission to save and improve lives. We believe anything is possible and rally around solutions. We celebrate innovation and offer opportunities to be a part of something bigger - to have a voice and role in the work that is serving our community and changing the field of medicine.

Our academic health system - the only in mid-Missouri - is home to multiple hospitals, including the region's only Level 1 Trauma Center and region's only Children's Hospital as well as over 90 specialty clinics. Here, you can define your career among our many clinical and nonclinical positions - with growth, opportunity and support every step of the way.

Learn more about MU Health Care.

Learn more about living in mid-Missouri.

EMPLOYEE BENEFITS

* Health, vision and dental insurance coverage starting day one

* Generous paid leave and paid time off, including nine holidays

* Multiple retirement options, including 100% matching up to 8%and full vesting in three years

* Tuition assistance for employees (75%) and immediate family members (50%)

* Discounts on cell phone plans, rental cars, gyms, hotels and more

* See a comprehensive list of benefitshere.

DETAILED JOB DESCRIPTION

Designs, implements, and maintains databases, reports, and scripts used to manage the enterprise HR systems.

Identifies, designs, implements, and disseminates data and reports as necessary to support the organization's goals.

Collects, analyzes, and reports data from multiple data sources to create actionable reports and knowledge for peers and leadership.

Manages and designs reports and benchmarking results in a clear and concise manner, as well as aggregating, processing, and interpreting report data for decision making in an effective and efficient manner.

Performs programming and analysis work to automate/improve user-determined data analyses and reports under the direction of the Database and Analytics Administrator.

Monitors and administers the regulatory and statutory requirements for MU Health Care, ensuring all requirements are met, monitors and implements new standards, and serves on regulatory committees to ensure all HR documentation, records, and processes meet all above requirements.

Designs, implements, and maintains dashboards (including, but not limited to turnover, vacancy, average time to fill, cost per FTE, etc.).

Identifies, extracts, and analyzes HR trends and patterns to improve operational efficiencies in HR as well as the organization.

Works with SharePoint to provide data to customers via lists, document libraries, key performance indicators, etc.

Utilizes Human Resources databases and other reporting tools for both ongoing and ad-hoc reports for management and Human Resources staff.

Provides administrator support on various HR Tools as needed.

May complete unit/department-specific duties and expectations as outlined in department documents.

KNOWLEDGE, SKILLS AND ABILITIES

Knowledge and skills in the following applications:

Advanced MS Access SQL/Query development Visual Basic for applications

Microsoft SQL and/or Oracle SQL development

JavaScript, CSS, JQuery

PeopleSoft and general knowledge of PeopleSoft table structure

Microsoft PowerBI

Microsoft Power Platform (Apps, Teams, Automate)

Automation and batch control tools

Knowledge of Service Management tools

REQUIRED QUALIFICATIONS

Bachelor's degree in information technology, informatics, or a related area, or an equivalent combination of education and experience from which comparable knowledge, skills and abilities can be acquired.

Three (3) years of experience working in a data enterprise environment, including designing, building, and managing multiple databases, transformation of data, customer reporting, and creation of dashboards and online reporting.

PREFERRED QUALIFICATIONS

Bachelor's degree in informatics, information technology, or a related area is strongly preferred.

Strong front-end and back-end web application development using HTML, CSS3, C#, AJAX, and RESTful API, within a Microsoft-based development environment.

Additional license/certification requirements as determined by the hiring department.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met with or without reasonable accommodation. The performance of these physical demands is an essential function of the job. The employee may be required ambulate, remain in a stationary position and position self to reach and/or move objects above the shoulders and below the knees. The employee may be required to move objects up to 10 lbs.

The University of Missouri is an Equal Opportunity Employer.