Financial Analyst - Baltimore, United States - Johns Hopkins University

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.

HR/Payroll

• 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 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.

General

• 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.).

• 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.

• 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.

Classified Title: Financial Analyst
Job Posting Title (Working Title):Financial Analyst
Role/Level/Range: ATP/03/PC
Starting Salary Range: Min $53,300 - Max $93,500 Annually (Commensurate with experience)
Employee group: Full Time
Schedule: Monday - Friday / 8:30 a.m. to 5 p.m.
Exempt Status:Exempt
Location:Hybrid/Homewood Campus
Department name: SNF Agora Institute
Personnel area: School of Arts & Sciences

Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines:
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.

**Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.

The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate's conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.

The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion.

Johns Hopkins has mandated COVID-19 and influenza vaccines, as applicable. The COVID-19 vaccine does not apply to positions located in the State of Florida. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry. For additional information,applicants for SOM positions should and all other JHU applicants should

The following additional provisions may apply, depending on campus.Your recruiter will advise accordingly.

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.

Note: Job Postings are updated daily and remain online until filled.