Classified Title: [[Financial Analyst]] Working Title: [[Financial Analyst]] Role/Level/Range: ATP/03/PC Starting Salary Range: [[$50,200 - $69,089]] Employee group: Full Time Schedule: [[Monday - Friday, 8:30a - 5:00p / 37.5 hours per wk]] Exempt Status: Exempt Location: 45-MD:JH at Keswick Department name: 10002568-SOM Admin Finance Budget and Accounting Personnel area: School of Medicine
This role will support the team to be the liaison between the University administration and the School of Medicine Business Office. Performs comprehensive analysis and projections, relating to business or financial trends to improve Departmental operational and financial effectiveness. Perform analysis of financial reports and data, and prepare subsequent narrative analysis for management inclusive of recommendations. Develop detailed financial models to help reduce cycle times for annual budgeting, projections and reporting. 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.
Specific Duties & Responsibilities
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, generate and distribute 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.
Function as a team player and works to maintain harmonious working relationships with coworkers, peers and supervisors.
Recognize where coworkers need assistance and take initiative to help.
Analyses and reconciles the Post Doc Fringe Pool for Johns Hopkins University
Assists manager create yearly rates
Processes monthly entries to the fringe pool
Preforms monthly reconciliations
Maintains housestaff budgets
Reviews yearly budgets
Processes monthly entries
Reconciles actuals with budgets
Responsible for tuition revenue line on GAAP financial statements
CME, KKI, HHMI and Lieber
Develops GAAP budget for tuition revenue
Provides analysis around monthly variances to budget
Reconciles student account receivables with SAP and student information system
Works with treasury to reconcile student accounts with SAP
Processes entries to correct differences
Analyses and reconciles the Student Health Plan, Dental Insurance and University Health Service accounts
Scope of Responsibility:
On a regular and continuing basis, develops knowledge of the formal and informal departmental goals, standards, policies and procedures which may include some familiarity of other departments within the school/division. Exhibits sensitivity to the interrelationship of both people and functions within and outside the department. Have an insatiable desire to solve business puzzles/challenges.
On a regular and continuous basis, exercises administrative judgment and assumes responsibility for decisions, consequences, and results having an impact on people, costs, and/or quality of service within the functional area.
May direct the activities of a function and/or represent the function at meetings.
Exchanges non-routine information using tact and persuasion as appropriate requiring excellent oral and written communication skills. Strong customer service orientation with internal stakeholders.
Bachelor's degree in finance, accounting, or other related field. 3 years progressively responsible related financial/accounting 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: 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. *
Master's Degree, and may substitute for some experience, to the extent permitted by the JHU equivalency formula.
Minimum of three years progressively responsible related financial experience required.
Advanced knowledge in the use of spreadsheets, presentations and word processing required. Knowledge of financial software applications and database utilization/management preferred.
Special Knowledge, Skills, and Abilities
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
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
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.