Budget and Data Analyst V

Department:

Location:

Health Sciences Center

Time Type:

Full time

Worker Type:

Regular

Job Req ID:

R106231

Minimum Requirements:

Bachelor's degree in Public Administration, Economics or a related field and eight (8) years of relevant experience or an equivalent combination of education and experience. Grade 9 (Salaried)

Position Description:

The Budget and Data Analyst V in the Health Science Center Office of Financial Affairs is a senior level budget decision support and financial analyst that is responsible for maintaining (on a daily basis) the integrity of the in-house financial reporting system along with providing detailed assistance to unit financial representatives. This position will also interact with University budget staff and University of Louisville Physicians (ULP) to resolve data, reporting and technical issues between the HSC and Belknap campuses in addition to our University of Louisville Health stakeholders.

Essential Duties and Responsibilities

• Support the accounting/finance function by performing complex financial analysis of the financial and non-financial data and generating Microsoft Excel/Power BI models to help track the progress of unit goals and identify vital trends and patterns.

• Based on provided direction, define and format monthly HSC management and ad hoc financial reports.  Assist with distribution and education of management report formats and content;   Maintain management reports, update reporting requirements, format, changes in account codes, changes in cost centers, etc.

• Collaborate with assigned departments and schools across the HSC to determine/identify challenge areas pertaining to profitable operational efficiencies and develop a plan of action to correct issues;  Monitor the implementation of the correction plans to ascertain that corrective action has been taken and operating challenges have decreased.

• Contribute to the training and educational needs of business partners within organizational unit(s) and assist in the coordination of the annual budget process, expense and/or staffing forecasts and statistical reporting; Prepare budgets and financial reports, including cash flow reports; Evaluate and analyze financial and operating reports and forecasts.

• Advise and assist various administrators across HSC campus, as required, to refine consolidation of departmental budget and financial reporting to reflect a comprehensive view of department activities.

• Assist with monthly review and analysis of reports to identify trends, comparisons, evaluate performance, etc.; Advise leadership as to the trends/variances and collaborate with departments and schools regarding strategies to meet budgetary goals.

• Work with assigned departments and schools on strategies for budgetary deficit reduction and other special projects as required. Prepare monthly and/or quarterly forecast, variance reports, and executive summaries for multiple groups.

• Lead and facilitate discussions with department and school leadership to identify management reporting areas and determine return on investment.  Develop and implement plan to track and monitor return-on-investment and impact analysis for department programs to determine feasibility and alignment with HSC and University goals.

• Other duties as assigned.

Preferred Qualifications

• Degree in Accounting and/or Finance

• 5-7 years of experience in complex Financial Analysis & Reporting, including 2+ years of advanced use of Microsoft Excel, preferably in higher education and/or academic medicine

• CPA certificate or MBA.

• Knowledge of PeopleSoft and WorkDay applications.

Competencies

• Financial Planning and Forecasting - Utilizes financial forecast data to provide forward looking projections to facilitate decision making; partners with stakeholders to analyze trends and validate assumptions to provide a forecast that aligns to the organization's goals and strategies.

• Financial Analysis - Interprets financial data by analyzing trends, variances, opportunities, and risks to provide insight to stakeholders regarding financial impact to drive business improvement; evaluates financial results against targets to communicate conclusions to all stakeholders; ensures integrity of financial data by investigating variances and determining corrective actions to resolve identified high level of analytical and problem-solving capabilities.

• Communicates effectively - Develops and delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences (must be an articulate and effective communicator)

• Financi