This role will support student operations with a focus on financial aid. The ideal candidate will perform comprehensive analysis and projections, relating to business or financial trends to support student and learner needs and requirements. S/he 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 financial aid budgeting, projections and reporting. S/he will utilize knowledge of the university's financial accounting systems including SAP, Student Information System (SIS), EPSI and PowerFAIDS.This individual should have the ability to work independently to achieve departmental goals, deadlines, and desired outcomes/results.
Duties and Responsibilities:
Provide dedicated Divisional Business Office (DBO) assistance in support of SOM Financial Aid and JHU student financial reporting
Develop intricate business models that clearly identify and project appropriate support levels for sources and uses that align to financial aid strategic priorities and programs for the learner groups within the SOM
Develop the annual Financial Aid budget scenarios required to support the level of aid determined through the sources & uses modeling scenarios, and recommends budget adjustments, and other cost improvement measures
Collaborate with Office of the Vice Dean of Education (OVDE), Central University Administration and The Fund for Johns Hopkins Medicine (FJHM) on philanthropic strategic initiatives in support of the learner's financial aid needs and incorporate into the financial modeling
Work closely with the SOM Financial Aid office, SOM Admissions office and JHU General Accounting
Ensure effective internal controls, compliance to financial policies and procedures, analyzing and maintaining statistical data and timely reconciliation practices of sources & uses
Utilize SAP, PowerFAIDS, SIS and financial modeling tools to complete routine analysis of the financial aid landscape ensuring strict financial controls are monitored and data integrity is accurate as data moves between the various systems for reporting
Utilize EPSI system for financial aid budget related activity and reporting
Develop and or build-upon existing standardized management reporting of captured data in SAP and PowerFAIDS to measure accuracy through routine auditing practices to ensure data integrity
Perform routine analysis and reporting to key stakeholders and Financial Aid Advisory Committee Members for providing a clear understanding of the financial strength of the Schools Financial Aid programs and distributions
Working knowledge of financial aid business practices, Title IV programs, and new initiatives/programs
Perform strict quality review of key financial data, statistics, practices and programs ensuring the highest level of data integrity, reliability and accuracy when reporting to all internal and external stakeholders by JHUSOM to include all survey requests
Plan and conduct simple to moderately complex analysis to determine cost of business activities
Analyze 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
Interpret financial data and transactions of discretionary spending for management making economic or business decisions
Review and evaluate 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 sources/uses within the School of Medicine
Use various software applications, such as spreadsheets, relational databases, and presentations/graphics packages to assemble, manipulate and/or format data and/or reports
Record, classify, and summarize financial transactions and events in accordance with generally accepted accounting principles as well as fund accounting
Document processes and procedures as needed
Function as a team player and works to maintain harmonious working relationships with coworkers, peers and supervisors
Minimum Qualification (Mandatory):
Bachelor's degree in finance, accounting, or other related field. Three years progressively responsible related financial/accounting experience. One year of exposure to financial aid in a higher education 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: 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.
Special knowledge, skills, and abilities:
Advanced knowledge in the use of spreadsheets, presentations and word processing required
Knowledge of SAP accounting system practices and implementation within the Hopkins environment desirable
MS EXCEL – Advanced, with demonstrated knowledge of Pivot tables, formulas and other advanced Excel tools and functions required
Additional Microsoft Suite (PowerPoint, Word, Access-strongly desired)
REPORTING TOOLS – Business Objects, Tableau or similar tools
Exchanges non-routine information using tact and persuasion as appropriate requiring excellent verbal and written communication skills
Strong customer service orientation with internal and external stakeholders
Exhibits sensitivity to the interrelationship of both people and functions within and outside the department
On a regular and continuous basis, exercises administrative judgment and assumes progressively increasing responsibility for decisions, consequences, and results having an impact on people, costs, and/or quality of service within the functional area
Classified Title: Financial Analyst Working Title: Financial Analyst Role/Level/Range: ATP/03/PC Starting Salary Range: $51,714-$71,176 ; commensurate with experience. Employee group: Full Time Schedule: Monday - Friday 8:30 - 5:00 Exempt Status: 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 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.