Financial Analyst

The financial Analyst will provide analytical support for the financial and budget activities of the Office of the Vice President (OVP). Prepare financial projections for all Cancer Prevention departments. Responsible for the preparation, distribution, and analysis of financial and variance reports.

The ideal candidate will possess a Bachelor's degree in Business Administration or a related business specialty and have experience in budgeting, forecasting, actual-to-budget variance analysis, data analysis, accounting, or project management. Prior expereince with familiarity with Smart View is a plus.

Minimum $32.93/hr – Midpoint $41.11/hr – Maximum $49.28/hr
Work Location\: Texas Medical Center
The typical work schedule is Hybrid.

Responsibilities
Maintain Financial Projections & Departmental Forecasting
• Utilize advanced Excel skills, including Smart View, filtering, and VLOOKUP functions, to combine and format expense, revenue, and FTE data into departmental projection spreadsheets
• Prepare and maintain ongoing financial projections for all Cancer Prevention departments
• Project individual CFS balances for applicable fund stewards across the Division
• Manage projections for FG 10 (E&G), FG 30 (Designated), FG 40 (PRS), FG 80 (Restricted Donor), and FG 90 (Grants & Contracts) funding groups
• Include all funding under stewardship by Division employees in projection analyses
• Incorporate Other Operating Revenue, including service center activity, and Grants & Contracts revenue from new awards
• Include budget amounts for hard funds and gifts and allocations for Designated and Restricted Donor funds
• Account for all personnel paid on Division funds, including employees external to Cancer Prevention
• Incorporate additional pay, fringe benefits, and future-dated myHR actions into projections
• Project personnel expenses to fiscal year-end for hard funds and at least 12 months for other funding sources

Financial Reporting & Variance Analysis
• Prepare, distribute, and analyze monthly financial and operational reports for management review
• Build, run, and evaluate Epic, Resource One (OBIEE), and other system queries to generate reporting data
• Prepare Income Statement Margin Variance reporting
• Prepare Professional Activity reporting
• Support limited Epic/OneConnect reporting requirements
• Identify financial variances and funding concerns requiring departmental review or resolution
• Communicate findings and recommendations to departmental leadership
• Follow up with departments regarding information requests and variance explanations

Budgeting & Forecast Support
• Participate in annual budget development and monthly forecast processes
• Maintain clinical activity projections by provider
• Maintain, update, and analyze patient revenue forecasts and professional activity forecasts
• Prepare and enter expense budget data directly into Planning systems
• Run and analyze budget reports for management review
• Identify variances relative to established budget targets
• Support ad hoc financial updates and analyses requested by leadership

Internal Controls, Compliance & Audits
• Assist with the design, execution, and monitoring of internal controls and procedures
• Support divisional oversight and monitoring of funds and projects for compliance with institutional policies and federal regulations
• Conduct recurring audits and reviews of departmental processes and procedures
• Perform STAT sample reviews and Status of Department Funds reconciliations
• Collaborate with management and departmental staff to identify corrective actions
• Track implementation and completion of approved corrective action plans

Other Duties
• Perform additional responsibilities and special projects as assigned