This role will support the student account team within the School of Medicine Business Office. Performs comprehensive analysis and projections, relating to business or research trends to improve Departmental operational and financial effectiveness. The ideal candidate will perform analysis of financial reports and data, and prepare subsequent narrative analysis for management inclusive of recommendations. S/he will develop detailed financial models to help reduce cycle times for annual budgeting, projections and reporting. S/he will utilize knowledge of the university's financial accounting systems.This individual should have the ability to work independently to achieve departmental goals, deadlines, and desired outcomes/results. In addition, expected to collaborate and engage key stakeholders of the Registrar's Office, affiliated institutions, the University Controllers Office, and the central university student account shared service.
Specific duties & responsibilities:
Maintains the medical insurance database
Transition database into the student information system (SIS)
Housestaff, Post Doc, and PhD student insurance premiums
Prepares monthly accounting close entries
Reconcile the premiums between the database, SIS and SAP
Manages the international medical student population
Process escrow/refund requests
Create escrow process and financial obligation letters
Reconcile escrow to SIS to SAP
Responsible for student revenue and expenses with Johns Hopkins affiliates
Continuing Medical Education (CME), Kennedy Krieger Institute (KKI), Howard Hughes Medical Institution (HHMI) and Lieber Institute
Provides analysis around monthly variances to budget
Responsible for the Post Doc Fringe Rate, the Housestaff reconciliations and Departmental Graduate Aid (DGA)
Reconciles student account receivables with SAP and SIS
Works with treasury to reconcile student accounts with SAP
Processes entries to correct differences
Monitors and triages the central student email boxes by effectively communicating with students and stakeholders in a timely manner
Works with management on projects and initiatives related to student accounts
Plans and conducts simple to moderately complex analysis to determine cost of business activities
Recommends budget adjustments, and other cost improvement measures
Analyzes simple to moderately complex financial data and extracts and defines relevant information; interprets data for the purpose of determining past financial performance and/or to project a financial probability
Develops simple to moderately complex financial models and reports for forecasting, trending, and results analysis
Interprets financial data and transactions of discretionary spending for management making economic or business decisions
Reviews and evaluates current internal/external processes and makes recommendations for improvements for automating and streamlining routine tasks
As assigned, generates and distributes monthly reports and create new reports to improve monitoring of revenues/expenses within the School of Medicine
Uses various software applications, such as spreadsheets, relational databases, and presentations/graphics packages to assemble, manipulate and/or format data and/or reports
Records, classifies, and summarizes financial transactions and events in accordance with generally accepted accounting principles as well as fund accounting
Documents processes and procedures as needed
Functions as a team player and works to maintain harmonious working relationships with coworkers, peers and supervisors
Supports Annual Budget Process; Monthly and annual close process
Supports development of Five and Ten Year Strategic Plans
Supports Johns Hopkins Medicine/Johns Hopkins University Dowry Report and AAMC (Association of American Medical Colleges) Reporting
Performs various Account Reconciliations
Compute and project expenses and departmental chargeouts
Oversight of Various Non-Departmental Programs
Recognizes where coworkers need assistance and take initiative to help
Minimum Qualifications (Mandatory):
Bachelor's degree in accounting, finance, business or related field
One year progressively responsible related financial experience
Advanced knowledge in the use of spreadsheets, presentations and word processing
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.
JHU Formula: 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for the 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.
Special knowledge, skills, and abilities:
Knowledge of financial software applications and database utilization/management preferred
Knowledge of SAP accounting system practices and implementation within the Hopkins environment desirable
MS EXCEL – Advanced, with demonstrated knowledge of macros, formulas and other advanced Excel tools and functions required
Additional Microsoft Suite (PowerPoint, Word, Access strongly desired)
REPORTING TOOLS – Business Objects or similar tools
Classified Title: Budget Analyst Working Title: Budget Analyst Role/Level/Range: ATP/03/PB Starting Salary Range: $43,530 - $59,795; Commensurate with Experience Employee group: Full Time Schedule: Monday through Friday 8:30-5:00 Exempt Status: Non-Exempt Location: 45-MD:JH at Keswick Department name: 10002567-SOM Admin Finance Business Services 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 firstname.lastname@example.org. 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.