HRIS DATABASE AND ANALYTICS SPECIALIST II

University of Missouri Health Care • Columbia, MO

91d • $59,322 - $96,762 • Onsite

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level