Business Analyst

The Department of Anesthesiology and Critical Care Medicine (ACCM) Business Analyst is responsible for overseeing and managing the daily and strategic operations of CRNA Clinical Staffing in collaboration with the Vice Chair of Clinical Operations, Director of Manpower, Clinical Staffing Team, Chief Nurse Anesthetist and Administrative Manager.

This position will report directly to the Administrative Manager of Clinical Scheduling and will collaborate with department leadership in the administrative management of department-wide clinical operations as needed.

For this role, you need to have a strong understanding of Excel, with expert proficiency in VLOOKUP, conditional formatting, VBA, forecast & trend tools.

Specific Duties & Responsibilities

• Provide direct management and oversight of the CRNA daily schedule and scheduling system (Qgenda) for Johns Hopkins Hospital.
• Responsible for the nurse anesthetist scheduling functions according to the policies and procedures of the Department of Anesthesiology & Critical Care Medicine and based on an understanding of the complex environment.
• and the clinical staffing needs of the ORs.
• Will plan and ensure clinical coverage and recordkeeping for administrative and financial accounting.
• Assists the Administrative Manager with physician scheduling tasks as needed and serves as the backup.
• Meets with new hires to provide tutorials on Qgenda.
• Partners with HR / Credentialing team and divisional contacts to add and remove providers from the scheduling system.
• Recommends and implements best practices to encourage optimal staffing which also positively impacts staffing budgets.
• Participate in monthly Clinical Staffing meeting to include Vice Chair, Manpower Directors, Resident Director, CRNA Division Chief, and Division Chiefs.
• Serves as primary contact to work closely with the Chief Nurse Anesthetist to implement best practices for clinical staffing optimization.
• Daily management and updating of schedule to include callouts, add-ons, shift swaps, etc.
• Daily management of inquiries, schedule requests, and approvals, via e-mail from 85 providers as the schedule is constantly fluid.
• Identifies areas of increased clinical need and works with the Chief Nurse Anesthetist to identify CRNAs to serve in these roles and collaborate with the CRNA Lead in charge of orientation for the onboarding schedule.
• Weekly generation of schedule to include specifically assigning CRNAs to the specific 75 anesthetizing locations per day per one site.
• Scheduling 85 CRNAs at 75 anesthetizing locations per day per one hospital which is done on quarterly generation.
• Reconciles between the timekeeping system (Kronos), scheduling system (Qgenda), and University E210 system, supplemental, agency, and per diem shifts that require payment.
• Prepares invoices for payment for staff and per diem and reviews for accuracy of agency invoices.
• Monitors the process of supplemental time submission, approval, and management for 85 CRNAs.
• Approves and monitors all sick, vacation, holiday, professional development, leave of absence, FMLA, etc. as requested by CRNAs.
• In conjunction with the Chief Nurse Anesthetist identify any potential progressive disciplinary attendance issues as outlined under the JHU SOM clinical operations work rule.
• Assists the Administrative Manager with data collection to identify strategic and operational opportunities, monitor project outcomes, and close projects with after-action reviews.
• Partners with HR / Credentialing team and Chief Nurse Anesthetist to add and remove providers from the scheduling system, and orient new providers to the department and their scheduling responsibilities.

Minimum Qualifications

• Bachelor's Degree in related field.
• Three years of related experience.
• Additional education may substitute for required experience and additional related experience may substitute for required education, to the extent permitted by the JHU equivalency formula.

Preferred Qualifications

Proficiency in Microsoft Excel

Being able to add and subtract numbers in different cells, change cell styles, and insert graphs.

Classified Title : Business Analyst

Role / Level / Range : ATP / 04 / PD

Starting Salary Range : Min $62,300 - Max $109,000 Annually ($65,000 Targeted; Commensurate with experience)

Employee group : Full Time

Schedule : Mon.-Fri.

Exempt Status : Exempt

Location : School of Medicine Campus

Department name : SOM Ane General Administration

Personnel area : School of Medicine

Total Rewards

The referenced salary range is based on Johns Hopkins University’s good faith belief at the time of posting. Actual compensation may vary based on factors such as geographic location, work experience, market conditions, education / training and skill level.

Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here : https : / / hr.

jhu.edu / benefits-worklife /

Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines :

JHU Equivalency Formula : 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience.

Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education / experience required for the respective job.

Applicants who do not meet the posted requirements but are completing their final academic semester / quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.

The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice.

A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate’s conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.

The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion .

Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

EEO is the Law

Learn more :

https : / / www.eeoc.gov / sites / default / files / 2023-06 / 22-088 EEOC KnowYourRights6.12ScreenRdr.pdf

Accommodation Information

If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the Talent Acquisition Office at jhurecruitment@jhu.

edu . For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit accessibility.jhu.edu .

Johns Hopkins has mandated COVID-19 and influenza vaccines, as applicable. The COVID-19 vaccine does not apply to positions located in the State of Florida.

Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons.

Requests for an exception must be submitted to the JHU vaccination registry. For additional information, applicants for SOM positions should visit https : / / www.

hopkinsmedicine.org / coronavirus / covid-19-vaccine / and all other JHU applicants should visit https : / / covidinfo.jhu.

edu / health-safety / covid-vaccination-information / .

The following additional provisions may apply, depending on campus. Your recruiter will advise accordingly.

The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination.

This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing.

Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers.

Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.

Note : Job Postings are updated daily and remain online until filled.