About the Role

Supp Lead Office Assistant, REMOTE, Central Staffing

Location Houston, Texas, 77024 

Category Non-Licensed Patient Care 

Job Type Part time 

Job Id 100176959

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)

Familiarity with recruitment processes is preferred but not required.
Experience with recruitment related platforms is preferred, but not required.
Outlook, MS calendar and zoom experience preferred.

Remote position, 2 days/week with a third day added in occasionally. 8am-6pm CST

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.

Job Description

Minimum Qualifications

Education: High School Diploma preferred

Licenses/Certifications: (None)

Experience / Knowledge / Skills:

• 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

Principal Accountabilities

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