Supp Lead Office Assistant, REMOTE, Central Staffing

Memorial Hermann Health System•Salt Lake City, UT

2d•Remote

About The Position

At Memorial Hermann, we pursue a common goal of delivering high quality, efficient care while creating exceptional experiences for every member of our community. When we say every member of our community, that includes our employees. We know that when our employees feel cared for, heard and valued, they are inspired to create moments that exceed expectations, while prioritizing safety, compassion, personalization and efficiency. If you want to advance your career and contribute to our vision of creating healthier communities, now and for generations to come, we want you to be a part of our team. Job Summary Duties include regular reporting (pulling data from multiple systems and combining in excel), third party platform support including ticket submission, UX testing and regular follow up to ensure timely resolution. Support would include intake call/meeting with end user, securing screenshots or recordings of platform issues/questions and submitting support tickets via the platform portal. Attending a weekly ticketing support call and gathering additional information and testing suggested solutions is expected. Excel skills, specifically the following: 1. Data review and clean up a. Be able to identify and remove duplicate rows or redundant data b. Format data as a Table c. Add data to the Data Model (in order to use more advanced Count or Sum functions) d. Be able to use Conditional Formatting to organize or review the data 2. Pivot Tables a. Be able to create and manipulate variables on a PivotTable b. Be able to create and manipulate variables on a PivotChart c. Be able to create slicers/dynamic filters for Pivot Charts 3. Functions – be able to fluently use the following functions: a. CONCATENATE (ability to join the data in two cells together) b. TRIM (function used to remove erroneous spaces found in data) c. VLOOKUP (used to bring data from one table to another using a common identifier, by the column) d. HLOOKUP (used to bring data from one table to another using a common identifier, by the row) e. INDEX MATCH (similar to VLOOKUP and HLOOKUP but able to use both rows and columns to bring data from one table to another using a common identifier) f. SUMIF (sums a set of data only if it meets a criteria, for example, we want to sum of candidate’s clinical years of experience who are Nursing only) g. COUNTIF (Counts a set of data only if it meets a certain criteria. For example, headcount of employees who are Nursing and working at MH Southwest) Position is responsible for managing an administrative function of a department or general office. Also, responsible for performing complex and diversified administrative duties for a department or general office.

Requirements

At least eight (8) years current clerical experience
Advanced computer skills, supervisory skills and ability to manage a function
Must have ability to perform complex and diverse administrative duties that involve application of procedures, independent analysis, interpretation of data and demonstrated appropriate judgment
Excel skills, specifically the following: 1. Data review and clean up a. Be able to identify and remove duplicate rows or redundant data b. Format data as a Table c. Add data to the Data Model (in order to use more advanced Count or Sum functions) d. Be able to use Conditional Formatting to organize or review the data 2. Pivot Tables a. Be able to create and manipulate variables on a PivotTable b. Be able to create and manipulate variables on a PivotChart c. Be able to create slicers/dynamic filters for Pivot Charts 3. Functions – be able to fluently use the following functions: a. CONCATENATE (ability to join the data in two cells together) b. TRIM (function used to remove erroneous spaces found in data) c. VLOOKUP (used to bring data from one table to another using a common identifier, by the column) d. HLOOKUP (used to bring data from one table to another using a common identifier, by the row) e. INDEX MATCH (similar to VLOOKUP and HLOOKUP but able to use both rows and columns to bring data from one table to another using a common identifier) f. SUMIF (sums a set of data only if it meets a criteria, for example, we want to sum of candidate’s clinical years of experience who are Nursing only) g. COUNTIF (Counts a set of data only if it meets a certain criteria. For example, headcount of employees who are Nursing and working at MH Southwest)
Outlook, MS calendar and zoom experience preferred.

Nice To Haves

Familiarity with recruitment processes is preferred but not required.
Experience with recruitment related platforms is preferred, but not required.

Responsibilities

Manages a primary function for a department or general office.
Orients and trains employees regarding system and hospital policies and procedures.
May be responsible for directing and reviewing work of lower level office clerks.
Develops and produces reports, letters, memorandum, minutes and other departmental correspondence.
Maintains and updates files for area of responsibility.
Identifies and responds to problems with appropriate action and follow-up.
Reviews departmental process to seek improvement.
Ensures safe care to patients, staff and visitors; adheres to all Memorial Hermann policies, procedures, and standards within budgetary specifications including time management, supply management, productivity and quality of service
Promotes individual professional growth and development by meeting requirements for mandatory/continuing education, skills competency, supports department-based goals which contribute to the success of the organization; serves as preceptor, mentor, and resource to less experienced staff.
Demonstrates commitment to caring for every member of our community by creating compassionate and personalized experiences.
Models Memorial Hermann’s service standards by providing safe, caring, personalized and efficient experiences to patients and colleagues.
Other duties as assigned.