Sr. Financial Analyst
IT@JH Administration and Finance is seeking a Sr. Financial Analyst who will be responsible for managing, with a high degree of accuracy, multiple financial budgets and reporting. This position will report directly to the Director of Budget and Financial Planning for IT@JH.
Specific Duties & Responsibilities
Financial Management Responsibilities.
- Manage multiple financial budgets. Submit the monthly financial transactions, such as KB15N’s, journal entries, and non-payroll cost transfers, on a timely basis (before deadlines). Ensure transactions have correctly posted.
- Forecast budgets including future revenues, depreciation schedules and related documentation from analysis of historical data trends and/or with input from IT Directors on a regular and ad-hoc basis, prepare tracking budget expenditures versus projections.
- Coordinate, consolidate and analyze departmental information for preparation of the monthly/quarterly and annual operating/capital budgets and five-year to ten-year plans.
- Prepare internal financial statements, and review and assess materials prepared by the directors within the IT organization.
- Prepare written comments on variances from budgeted monthly and at year end close.
- Maintain broad understanding of the financial positions/conditions of the various cost centers throughout the department.
- Meet with and serve as a go-to resource for cost center managers and IT directors.
Financial Analysis Responsibilities
- Monitor and analyze the current and projected operations of numerous budgets.
- Assimilate information from various sources to draw conclusions, to effect change in processes, procedures, and reporting, and/or theorize downstream impacts.
- Define problems, collect data, establish facts and draw conclusions with direction (as necessary) from others. Must be able to interpret technical and detailed guidelines, policies and procedures, as well as explain or describe moderately complex information and presentation materials.
- Plan and conduct complex studies to determine the cost of business for various levels of departmental operations.
- Analyze complex financial data, extracting and defining relevant information using various accounting systems, communicating necessary information to applicable members of the IT administration team.
Other Responsibilities
- Update existing procedures as needed, as well as creates new procedures as warranted.
- Responsible for accurate data entry.
- Demonstrate ability for self-direction and initiation, as well as ability to work independently and as part of a team, to address problems/tasks.
- Arrives at work on time and is prepared to assist coworkers, faculty and both internal and external customers at the beginning of his/her workday.
- Other responsibilities as assigned.
Special Knowledge, Skills & Abilities
- Extensive MS Excel experience (Pivot Tables/Advanced Formula development)
- Office Suite (Word/Excel/Access/Outlook)
- SAP ERP (Including ECC/R3)
- SAP Analysis BI tool
- SharePoint
- Proficient in the use of software applications, databases and spreadsheets.
- Strong communication skills.
- Ability to work independently and perform a high degree of accuracy.
- Superior math aptitude.
- High level of self-organization and able to appropriately prioritize responsibilities in a fast-paced environment.
- Ability to handle/manage and organize a heavy workload.
- Ability to establish and meet work schedules within limited time frames and under tight deadlines.
- Able to coordinate the work of a diversified staff in various environments.
Minimum Qualifications
- Bachelor's Degree in Finance, Accounting, Business or related field.
- Five years progressively responsible related financial/accounting experience.
- 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.
Preferred Qualifications
- Experience developing dashboards in Tableau, Power BI, or other business intelligence tools.
- Experience using Robotic Process Automation (RPA) software.
- Experience writing SQL queries.
- Knowledge of Johns Hopkins policies and procedures.
- Experience working in an IT Financial Management capacity.
- Experience in a large and complex finance department.
Classified Title: Sr. Financial Analyst
Role/Level/Range: ATP/04/PD
Starting Salary Range: $62,900 - $110,100 Annually (Commensurate with experience)
Employee group: Full Time
Schedule: Mon-Fri, 8:30am-5pm
Exempt Status: Exempt
Location: Hybrid/Mount Washington Campus
Department name: IT@JH Administration and Finance
Personnel area: University Administration