Job Information
Johns Hopkins University Budget Analyst in Baltimore, Maryland
Scheduling & Event Services within the division of Student Affairs at Johns Hopkins University on the Homewood Campus offers year-round space reservations with professional meeting services in addition to a comprehensive on-campus residential experience during the summer. Scheduling & Event Services provides a safe, professional and service-oriented environment for the campus community and guests to participate in successful meetings, conferences, camps and various programs. The department hosts over 6,500 events yearly with over 200,000 guests from internal and external organizations hosted year-round including the summer which offers a unique on-campus living experience showcasing Johns Hopkins University.
We are seeking a Budget Analyst who will serve as the primary financial position for Scheduling and Event Services performing financial transactions in the department in excess of $5M and preparing/analyzing budgets over the life cycle. This primary role is to maintain all financial transactions, tracking, best practices, reconciliations, and processing of funds using specialized conferencing software and SAP in compliance with university procedures. This position works and corresponds with various level administrators, faculty, staff, and external clients regarding financial questions and resolutions. This position requires strong analytical and assessment skills needed to forecast different financial scenarios based on changes in business practices with campus partners. This position is multifaceted and is responsible for report development, data analysis, and successfully transitioning and applying financial data procedures and processes to a new scheduling/billing system implementation in 2024.
This position must perform at an exceptional level of accuracy with all financial transactions, spreadsheets and documentation at all times while being able to communicate complex financial systems to key audiences.
Specific Duties & Responsibilities
Assists Director with estimating yearly revenue and expense budget projections.
Review and analyze proposed budget plans to confirm thorough and appropriate content and consistency with fiscal requirements, recommend alternatives as needed to ensure project results.
Work with Director to submit quarterly and final budgets.
Develops a profit and loss statement.
Track revenue, expenditures, and monthly budget reconciliation for four cost centers and make projections based on analysis and assumptions.
Prepare and process all invoices for deposits and services rendered for meetings and summer conferences through specialized conferencing software.
Work with Treasurer’s Office to claim and reconcile ACH payments.
Compiles data for various reports for the Director (i.e. summer residential projections, dining, parking, budget projections, rate increases, yearly room cost analysis, UBIT reports).
Assists Director with making independent assumptions and recommendations on updates to yearly revenue and expense budget projections.
Develop quotes in financial module to generate invoicing.
Extract monthly external organization tax data from system, verify accuracy, update comprehensive yearly tax spreadsheet, document and submit to the University Tax Office.
Maintain meticulous documentation on all financial transactions for auditing purposes.
Create all invoices for summer residential programs and meetings for deposits, final payments and post invoices within required timelines; correspond with clients, track, receive and record payments in system as well as in SAP.
Continually remain up to date with University financial policies, deadlines, and protocols throughout the year and during end of year closing requirements.
Responsible for collections in required timeline per contractual agreement.
Maintain financial reports.
Resolves budget discrepancies and processing refunds, on-line payment requests, travel advances, petty cash reimbursements, purchase orders, shopping carts, on-line check receipts, journals and non-payroll transfer requests.
Assists new vendors in getting setup in Payment Works.
Communicates with appropriate internal and external administrative offices and vendors to resolve any monetary discrepancies, collections, and all past due payments.
Work closely with the Assistant Director for summer residential billing, computing parking charges, verify meals and lodging for accuracy.
Develop Standard Operating Procedures for all financial transactions and reports.
Maintain calendars for all financial deadlines for processing and close out for end of fiscal year close out.
Appropriately code all invoices for processing to ensure all costs are directed to the appropriate areas.
Assist Assistant Directors with student staff yearly pay rates and financial forecasting for budget development.
Interpret policy and procedure for department based on understanding of university policy and/or sponsoring agency guidelines.
Maintain and update yearly pricing rates.
Participate in University and division committees.
Other duties and special projects as assigned.
Special Knowledge, Skills, & Abilities
Prior experience using SAP, including Analysis and/or BW Reports, highly preferred.
Requires excellent oral and written communication skills for tactful and effective interactions with students, parents, faculty, vendors and staff at all levels.
Proficient in various software applications, databases and financial spreadsheets.
Requires the ability to work independently with minimal supervision and excellent organizational skills to prioritize and manage multiple assignments in a diverse and frequently changing business environment.
Able to perform complex financial formulas, calculations, and analysis on data.
Able to make sound judgment and recommendations based on data analysis.
Able to develop complex yet streamlined data reports.
Accuracy and attention to detail is required.
Ability to handle confidential information responsibly.
Additional Information
- This is a hybrid position from 8:30am - 5pm Mon - Fri, with 3-4 in-person days after successful onboarding and training of systems and processes.
Minimum Qualifications
Bachelor’s Degree in Accounting, Finance, or other related field.
A minimum of one-year related progressively responsible 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
- Three to five years of related financial experience preferred along with working in SAP and a high transactional environment.
Classified Title: Budget Analyst
Role/Level/Range: ATP/03/PB
Starting Salary Range: Min $23.43 - Max $41.02 HRLY ($62,500 targeted; Commensurate with experience)
Employee group: Full Time
Schedule: Mon - Friday / 8:30am - 5:00pm
Exempt Status: Non-Exempt
Location: Hybrid/Homewood Campus
Department name: Scheduling & Event Services
Personnel area: University Student Services
Equal Opportunity Employer:
Johns Hopkins University is an equal opportunity employer and does not discriminate on the basis of race, color, gender, religion, age, sexual orientation, national or ethnic origin, disability, marital status, veteran status, or any other occupationally irrelevant criteria. The university promotes affirmative action for minorities, women, disabled persons, and veterans.