Financial Analyst

Johns Hopkins University

Baltimore, MD

ID: 7245696
Posted: May 17, 2024
Application Deadline: Open Until Filled

Job Description

The SNF Agora Institute at Johns Hopkins University is seeking a qualified Financial Analyst - SNF Agora to provide financial management and budgetary support under the direction of the Assistant Director of Finance. The SNF Agora Institute has a diverse funding portfolio that consists of a large $150M endowment and various grants, contracts and philanthropy that support the Institute’s research and mission. The Financial Analyst will assist the Assistant Director of Finance in managing this diverse portfolio and providing strong financial management and analysis.

Specific Duties & Responsibilities

Financial Management & Reporting

Monitor and track faculty lab start-up and research budgets and proactively provide status of available funds to faculty and the Assistant Director of Finance; create shadow reports in Excel that clearly presents account balances and financial summaries.
Review and approve SAP transactions to include, online payments, journal transfers, shopping carts, and purchase orders, while ensuring all costs are allowable, allocable and reasonable.
Review and approve expense reimbursements, procurement and corporate card transactions in Concur Expense, ensuring all costs are allocable, allowable and reasonable.
Process complex and non-routine journal transfers and oversee the institute’s faculty and student grants program.
Keep abreast of institutional policies and the evolving financial regulatory environment and advise institute faculty and staff on best practices.
Work with the institute’s Budget Analyst to ensure accounts are reconciled on a monthly basis for review and approval by the Assistant Director of Finance.
Perform cost benefit analysis; interpret and evaluate financial data and make recommendations based on results.
Generate ad-hoc BW/Analysis reports to assist with institute strategic planning; develop forecasting models and projections.
Identify and assist with resolutions to procurement and accounts payable issues.
Create tools and spreadsheets that clearly summarize complex financial results.
Assist with the development of presentation materials using the latest in graphic design tools, such as Canva, to illustrate salient financial results for the institute’s quarterly meetings with the Board of Overseers and the Stavros Niarchos Foundation.
Create forecasting models that optimize strategic decision making for financial leadership.
Assist with the annual budget planning process.


Process various HR related transactions in SAP including Employment Actions, ISRs and payroll cost transfers.
Maintain internal salary tracking spreadsheets to allocate personnel salaries across various budget lines.
Allocate salaries in SAP via payroll cost transfers (9027) ensuring e-forms are in compliance and processed within 90 days for sponsored funds.
Assist with effort reporting.
Manage the payroll process for hourly workers in TimesheetX.
Collect new hire personnel data for all new institute faculty, students, and fellows.
Assist with onboarding new institute faculty, students, and fellows.
Assist with offboarding institute faculty, students, and fellows.

Sponsored Projects

Submit grant proposals in Fibi for institute and institutional review and approval, ensuring proposals are submitted on-time and accurately.
Work with Principal Investigators to prepare budgets and budget justifications for grant submissions.
Submit JAWS and SWIFT records.
Allocate budgets in SAP for new awards.
In coordination with the Assistant Director of Finance, provide financial management for various faculty lab’s awards from the cradle to the grave, to include award set-up, post award management and closeout.
Prepare sponsored invoices as necessary and run cash collected reports to ensure all revenue is received; provide banking details to sponsors and work with Cash Accounting to post revenues to the proper cost centers and GLs.
Process subcontractor invoices and generate good receipts in SAP Central Receiving; conduct detailed invoice review and request supporting general ledger documentation as necessary following the appropriate risk rating for the sub-recipient.
Prepare monthly account reconciliation for review by the Assistant Director of Finance.
Monitor projects to ensure expenditures are timely, within project period, and in compliance with sponsor and university policy.


Recommend process improvements for better performance and efficiencies.
Keep abreast of university and sponsor policies to ensure up-to-date compliance.
Establish strong relationships with central offices that advances the institute’s mission and key priorities.
Work independently to manage multiple tasks/assignments simultaneously.
Provide backup support to finance team.
Carry out other related duties, as assigned.

Special Knowledge, Skills, & Abilities

Ability to perform at a high level in a fast-paced and contingent environment.
Strong attention to detail and analytical skills.
Must have working knowledge of MS Excel.
Knowledge of SAP financial systems.
Ability to manage multiple projects and establish priorities using independent judgement and ensuring deadlines are met.
Demonstrated interpersonal, organizational, and problem-solving skills.
Ability to work in a fast-paced environment and flexibly handle competing priorities and stakeholders.
Two or more years of related experience preferred.
Willingness to work independently with a team that works in hybrid mode.

Technical Qualifications or Specialized Certifications

MS Office suite of software applications (Word, PowerPoint, Excel, etc.).

Minimum Qualifications
Bachelor's Degree in Finance, Accounting, Business or related field.
Three 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.

Preferred Qualifications
Must be highly skilled in financial analysis and reporting.
Experience providing financial support at the executive level.
Knowledge of JHU institutional systems, policies and procedures.
Five years of experience, preferably in support of academic, business, research and/or development activities and operations, providing high-level administrative oversight, coordination, and advice.