Reporting to the Finance Manager, the Financial Analyst participates in studies to improve the operational and financial effectiveness of Johns Hopkins Technology Ventures (JHTV). The Financial Analyst extracts financial data from various accounting and information systems, performs financial and cost accounting analysis of data, and utilizes knowledge of the university's financial accounting systems.
Special Note: This position is not eligible for visa sponsorship.
Specific duties & responsibilities:
Assists in the analysis of financial data and extracts and defines relevant information; interprets data to determine past financial performance and/or to project financial probability.
Reviews expenditures and performs cost benefit analysis related to projects and/or programs.
Performs statistical, and financial analysis of data reported across various financial systems.
Reconciles revenue between SAP and JHTV's internal Inteum database to ensure all income is accounted for and recognized.
Manages project activity for various quarterly and annual reporting deliverables- assigns sections and deadlines, reviews reports, and meets with management for final review.
Develops financial reports for forecasting, trending, and results analysis.
Develops analytical tools to facilitate the management of JHTV's portfolio, staff, and operations.
Based on analytical findings, provides recommendations to JHTV senior staff.
Regularly prepares presentations -for senior management team meetings.
Designs and administers complex analytical tools in BI platforms such as Tableau, PowerBI, and Qlik.
Extracts, manipulates, and performs quantitative analysis on large data sets.
In collaboration with IT, leads the development and maintenance of proprietary data systems necessary for office operations.
Analyzes the structure of intellectual property landscapes to develop an understanding of important organizations and trends in specific industries. Over time, this position will develop an understanding of certain key industries relevant to the commercialization of major IP portfolios managed by JHTV.
Identifies obligations incurred through funding sources, material transfer agreements, and other agreements that may impact the ability of JHTV to license the technology.
Accounts for and summarizes JHTV's financial activity in accordance with generally accepted accounting principles.
Assists with the compilation of revenue and expenditure data related to license agreements and, following JHU and Inter-Institutional IP policy, calculates and processes royalty distributions to other institutions, inventors, inventors' lab(s), inventors' department(s), inventors' school(s), JHTT, and JHU.
Develops narrative and statistical reports and charts in response to management requests regarding overall licensee compliance, specific agreement compliance, and technology portfolio analysis.
Updates the stock escrow/equity holdings in the JHTT information system; generates appropriate documents to transmit stock to the Treasurer's Office and provides reports from the database as needed.
Interprets and performs financial transactions and events for users who must make economic or business decisions.
Uses various software applications, such as spreadsheets, relational databases, statistical packages, and graphics packages to assemble, manipulate and/or format data and/or reports.
Prepares detailed and summarized written analyses for JHTV and University management.
Supports pre- and post-award administration of JHTV's sponsored research activity.
Minimum qualifications (mandatory):
Bachelor's degree in accounting, business, or related field
Three years' related financial 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.
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.
Proficiency in the use of software applications, databases, spreadsheets, and/or word processing
Special knowledge, skills, and abilities:
US Citizen or Legal Permanent Resident required due to Federal Export Controls
Advanced knowledge of financial software applications, databases, spreadsheets, and/or word processing to assemble, manipulate and/or format data and/or reports
Specific experience with Microsoft products: Excel, Powerpoint, Word and Access
Work experience in a research, academic or university environment, and strong knowledge of SAP and BW reporting
Proficiency in COEUS and JAWS systems
Strong project management skills, including the ability to develop and meet deadlines and to multi-task under pressure
Good oral and written communication skills including the ability to draft emails and letters, budget narratives, and other reports using excellent form, style, grammar, and spelling
Great interpersonal skills and strong solution-focused customer service orientation with a proven ability to promptly deal professionally, tactfully, and effectively with all types of customers
Skill in planning, preparation, and analysis of financial statements, budgets, and financial trends, to include GAAP operating and cash activity
Experience with financial analysis techniques, including financial evaluation of performance metrics and scenario modeling
Demonstrated skill in financial and budget analysis; ability to develop financial models
Strong attention to detail
A team player who collaborates well and able to work with diverse audiences
Classified Title: Financial Analyst Working Title: Financial Analyst Role/Level/Range: ATP/03/PC Starting Salary Range: Commensurate with Experience Employee group: Full Time Schedule: M-F, 8:30am-5pm Exempt Status: Exempt Location: 04-MD:School of Medicine Campus Department name: 60006028-Finance and Administration Personnel area: Academic and Business Centers
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 firstname.lastname@example.org. 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.