The Sr. Financial Analyst will coordinate financial activities related to the clinical practice for the Department of Emergency Medicine. This position reports directly to the Assistant Director of Finance to ensure smooth and efficient functioning of all financial aspects related to the department’s clinical practice. Assists in budgeting and financial forecasting and reporting activities for JHU, including the development and maintenance of the annual faculty compensation model and salary budgets to sponsored and non-sponsored accounts. Performs technical and detailed quantitative tasks to manage large data sets relating to clinical hours and operations, faculty effort and salary allocations, clinical productivity, and profitability. This position will interact extensively with the Assistant Administrator, Grants & Contracts Manager, and faculty, as well as personnel within the SOM Business Office. This position may also be called upon to cross train and serve as a backup to the department’s Financial Analyst.
Specific duties & responsibilities:
Manages clinical hours tracking and reporting for Emergency Medicine clinical faculty and PAs at JHH, Bayview, and Howard County General Hospital/JHEMS. Maintain monthly clinical hours report, updating clinical commitment variances and departmental budgeted vs. actual hours worked variance. Perform complex calculations to process and manipulate large data sets including clinical hours for reporting and compensation purposes.
Troubleshoot and resolve clinical schedule data issues with Tangier and/or Tableau. Work with faculty and PA schedulers at multiple clinical sites to ensure integrity and proper allocation of clinical hour data for reporting.
Calculate quarterly clinical overage, shift differential, high needs pay, and incentive payments for faculty.
Consolidate and analyze data to complete physician and PA productivity and revenue reporting, including the quarterly PCAR report and bi-annual provider P&L statements. Produce quarterly and ad-hoc reports integrating clinical revenue collection, clinical effort, and internal and external salary support data from various sources.
Develop and produce integrated quarterly provider statements for faculty & PAs, detailing compensation earned, incentive supplements, and progress towards clinical commitment (YTD hours surplus/deficit).
Participate in the development of department’s $37M SOM expense budget in conjunction with the Assistant Director of Finance, Assistant Administrator, and Grants & Contracts Manager.
Assist in the development of financial reports related to clinical, joint agreement funds, general funds, and gift and discretionary funds budgets. Refine departmental All Funds reporting processes to provide more automated, understandable divisional/program reports (e.g. DSO, Residency, CEPAR, JHEMS clinical practice). Participate in SOM activities to improve and enhance budgeting and financial reporting via EPSi and other reporting tools including the Faculty Compensation Budget Tool.
In coordination with Grants & Contracts Manager, oversee timely funding allocations and eForm completion for faculty, including periodic review and maintenance of faculty salary support spreadsheets. Aid in the development of financial reports by faculty member on budgeted/salary grid vs actual salary support from sponsored, intra- and inter-entity, and external funds.
Assist in special projects, as needed, for sponsored awards, including complex reconciliations and salary budgets for large awards.
Develop budgets and financial forecasts and prepares volume and revenue projections. Monitors expenditures, volumes and revenues monthly against the budget. Prepares monthly reports comparing cost/case, volumes for budget vs. actual vs. PYTD. Submits operating budgets, volumes, and revenue projections.
Reviews monthly statements and compiles variance reports to highlight budget variances. Suggests and/or implements corrective actions on a monthly basis to ensure budget compliance.
Analyzes and interprets complex financial data for the purpose of determining past financial performance and projecting financial profitability to inform decision-making.
Plans and conducts complex studies to determine cost of business activities. Recommends budget adjustments and other cost improvement measures.
Use various software applications, such as spreadsheets, relational databases, cost-accounting systems, statistical packages to manipulate and/or format data and/or reports.
Integrate large data sets from various sources and programs into automated or semi-automated reports using Excel, Access or SQL, Tableau, and SAP.
Communicate with appropriate internal and external administrative offices to ensure that established procedures are followed.
Bachelor’s degree in finance, accounting, or other related field and five years progressively responsible experience in a related administrative/financial position, preferably in an academic or medical setting. Additional education (Master's in a related field) may substitute for required experience and additional related experience may substitute for required education, to the extent permitted by the JHU equivalency formula.
JHU Equivalency Formula: 18 graduate degree credits may substitute for one year of experience.
Salary: Commensurate with Experience Status: Full-Time
Department name: 10002842-SOM Em Med General Administration
Work Schedule/Hours: M-F; 8:30am-5:00pm Location: 02-MD:Mount Washington Campus Personnel area: School of Medicine
The successful candidate(s) for this position will be subject to a pre-employment background check.
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 HR Business Services Office at email@example.com. For TTY users, call via Maryland Relay or dial 711.
The following additional provisions may apply depending on which campus you will work. Your recruiter will advise accordingly.
During the Influenza ("the flu") season, as a condition of employment, The Johns Hopkins Institutions require all employees who provide ongoing services to patients or work in patient care or clinical care areas to have an annual influenza vaccination or possess an approved medical or religious exception. Failure to meet this requirement may result in termination of employment.
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.
Equal Opportunity Employer Note: Job Postings are updated daily and remain online until filled.
Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130 years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Bal...timore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.