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 benefits here.
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.
Equal Employment Opportunity
The University of Missouri is an Equal Opportunity Employer.
