SENIOR HRIS DATABASE AND ANALYTICS SPECIALIST

LOCATION: Columbia, Missouri

ABOUT THE JOB

Responsible for designing, programming, maintaining and automating the organization's human resources data resources, specific to healthcare. Develop, implement and monitor multiple databases, both housed internally and externally, to ensure efficient processing, up-to-date tools, and improved efficiencies. Serves as the data custodian in support of Human Resource activities and processes. Responsible for researching HR IT needs for related development of automated systems, enterprise software applications, enhancements, and report generation. Responsible for weekly, monthly, quarterly, annual and ad-hoc report design and distribution.

SALARY RANGE $68,266 - $111,426

ABOUT US

MU Health Care is a growing academic health system in mid-Missouri comprised of multiple hospitals - including the region's only Level 1 Trauma Center and region's only Children's Hospital - and over 50 specialty clinics located throughout the region.

As an MU Health Care employee, you will be part of an exceptional team committed to our mission of saving and improving lives and supporting our team members to achieve their personal and professional goals. Our core values of inclusion, respect, service, discovery, responsibility, and excellence foster a collaborative work environment where you can grow your career.

Learn more about MU Health Care. Learn more about living in Columbia, MO.

EMPLOYEE BENEFITS

• Health, vision, and dental insurance coverage starting day one
• Generous paid leave and paid time off, including 9 paid holidays
• Multiple retirement options, including 100% match 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.

ESSENTIAL FUNCTIONS

• Design, implement, and maintain databases, reports and scripts used to manage the enterprise HR systems.
• Identify needs, design, implement and disseminate data and reports as necessary to support the organization's goals.
• Responsible for the collection, analysis and reporting of data from multiple data sources to create actionable reports and knowledge for peers and leadership.
• Manage and design 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.
• Independently perform programming and analysis work to automate/improve user determined data analyses and reports. Perform work assignments while staying within the capacity and limitations of the equipment, operating time and form of desired results. Work closely with operating/production staff in establishing report generation schedules and required job setup procedures.
• Monitor and administer the regulatory and statutory requirements for MU Health Care ensuring all requirements are met, new standards monitored and implemented, and serve on regulatory committees to ensure all HR documentation, records, and processes meet all above requirements.
• Design, implement, and maintain dashboards (including, but not limited to turnover, vacancy, average time to fill, cost per FTE, etc.).
• Identify, extract, and analyze HR trends and patterns to improve operational efficiencies in HR as well as the organization.
• Work with SharePoint and SharePoint Designer to provide data to customers via lists, document libraries, key performance indicators, etc. Use SharePoint Designer to create data views that aggregate data from various data sources into usable data presentations for the command.
• Evaluate existing human resources processes and procedures against healthcare industry benchmarks to identify "best in class" methods.
• Identify and recommend new processes/procedures to improve human resource service levels at MUHC. Once recommendations are approved, implements changes.
• Utilize Human Resources databases and other reporting tools for both ongoing and ad-hoc reports for management and Human Resources staff.
• May complete unit/department specific duties and expectations as outlined in department documents.

REQUIRED QUALIFICATIONS

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

Five (5) 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

Desired knowledge and skill sets include:

* 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 Platfrom (Apps, Teams, Automate)

* Automation and batch control tools * Knowledge of Service Management tools

Equal Opportunity Employer

The University of Missouri System is an Equal Opportunity Employer. Equal Opportunity is and shall be provided for all employees and applicants for employment on the basis of their demonstrated ability and competence without unlawful discrimination on the basis of their race, color, national origin, ancestry, religion, sex, pregnancy, sexual orientation, gender identity, gender expression, age, disability, or protected veteran status, or any other status protected by applicable state or federal law. This policy applies to all employment decisions including, but not limited to, recruiting, hiring, training, promotions, pay practices, benefits, disciplinary actions and terminations. For more information, visit https://www.umsystem.edu/ums/hr/eeo.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, religion, sex, pregnancy, sexual orientation, gender identity, gender expression, age, disability, or protected veteran status, or any other status protected by applicable state or federal law.