Finance Analyst

About The Job

As a thought partner for the organization, the Financial Analyst will provide ongoing cross-functional analysis, identifying optimal decisions and processes and consulting with clinic leadership on potential business impacts. This would include creating proformas for new and expanded services and care delivery, ongoing financial reporting, and contributing insights into the forecasting process based on trend analysis within an outpatient clinical setting. This position will also provide support to leadership throughout the budget development cycle, including model development and ensuring stakeholder engagement throughout the development and approval process. As part of the Accounting and Finance Team, the Financial Analyst will support other duties within the department including monthly cash and accounts receivable reconciliations to EFS, developing pre-award budgets, post award management and regulatory reporting. Strong communication and interpersonal skills, attention to detail and advanced proficiency with Excel and other data management tools are required for this position.

This is a hybrid position requiring 1-2 days per week on site. This position reports to the Finance Director at the Community-University Health Care Center (CUHCC).

Essential Functions

Financial Analyst (55%)

• Track clinical operations performance related to provider productivity, clinic visits, net patient revenue, staffing, dashboard indicators, and other measures identified within organizational planning and provide timely reporting to senior leadership related to results, trends, and variances to targets.
• Coordinate the analysis of target vs. actual variances on a monthly basis and partner with leadership to review analyses and recommend improvement plans. Track improvements to goals and provide feedback loops to leadership on progress. Prepare monthly expense variance to budget narrative report for senior leadership and Board.
• Support the annual budget process including developing and maintaining budget model, accuracy of data and related assumptions, adherence to deadlines, facilitating communication with operational leaders regarding budget process, status updates, and finalizing the budget.
• Prepare and submit (input) annual PeopleSoft budget based on the final budget approved by the Board of Directors of CUHCC.
• Assist Financial Officer with financial forecasting model development and reporting based upon trend analysis, timing adjustments and operational performance to budget.
• Provide senior management with ongoing FTE reporting that would include FTE to budget and overtime tracking and reporting. Review bi-weekly payroll abstracts and facilitate approval.
• Support revenue cycle management with AR valuation, charge analysis, fee schedule analysis, contract performance and other analysis as needed. Provide ongoing support for net patient revenue determination by service area and visit type for financial reporting and analysis.
• Support Financial Officer with the process of FQHC rate setting and validation of rates.

Departmental Support, Grants/Reconciliations (15%)

• Cross train and provide departmental support, as needed, in the following areas: balance all bank statements, lockbox, batch statuses, payment information, and physical deposits to ensure all items are clearing correctly and identify any errors for correction.
• Reconcile the multiple fund accounts used by CUHCC including expense allocation, revenue recognition, and draw requests.
• Serve as back up support for sponsored project activity including pre-award budget development, post award management, effort certification, and communication with the office of Sponsored Projects Administration (SPA).
• Other support as needed.

Financial Reporting/Regulatory Compliance (20%)

• Support the month-end close process to include extracting data from the practice management system (electronic health record) into data warehouse and developing reports for the month end period. Ensure data integrity and accuracy of period and historic data at all times. Use practice management system data reporting and query tools for ongoing validation of financial data.
• Reconcile cash and accounts receivable monthly from Epic Ochin to UMN EFS to ensure complete, accurate and timely reporting from EFS. Support Finance Team with the accurate and timely preparation of regulatory reports to include Uniform Data System (UDS) report, Medicare Cost report (CMS-224-14), Medical Education Research Cost Reporting (MERC), Provider Tax Return, HRSA Budget Period Progress Reports and Federal Financial Reports, and HRSA Service Area Competition budget development.

Other Duties as Assigned (10%)

Qualifications

Required Qualifications

• BA/BS degree in business, finance or related field.
• Six plus years of experience in finance or related position.
• Experience with financial reporting and analysis within a health care setting.
• Advanced to Expert experience with Excel including the development of data models, use of pivot tables, joining and consolidating data, charting data and formatting charts, and the use and creation of complex formulas.
• Time management skills with demonstrated ability to be self-directed and meeting job responsibilities.

Preferred Qualifications

• Experience with PeopleSoft.
• Database management experience.
• Degree in accounting.
• Strong interpersonal and communication skills.
• Practice Management (electronic health record) familiarity.

About The Department

At CUHCC, we're transforming urban health care and educating the next generation of healthcare professionals. CUHCC offers a full range of dental and mental health services that are typically not offered at a community health center, such as prosthodontic services and psychiatry. CUHCC has pharmacists, psychiatric nurse practitioners, dentists, dental hygienists, nurses, family nurse practitioners, family practice physicians, internal medicine physicians, internal medicine-pediatric physicians, licensed social workers and psychologists among other disciplines on staff. CUHCC's interprofessional care model uses a collaborative, team-based approach to deliver education and patient care, integrating these services. Students and residents at CUHCC have the opportunity to work with other students and preceptors in other fields to best serve the complex needs of the patients. Over half of CUHCC's mental health patients also receive medical services at CUHCC, allowing CUHCC providers to work collaboratively to provide patient centered care. As a founding member in the country's first accountable care organization (ACO) for federally qualified health centers, CUHCC is leading change in urban health and improving patient outcomes to meet the Institute for Healthcare Improvement's Triple Aim: improve the patient experience, improve patient health, and reduce the cost of patient care.

Pay And Benefits

Pay Range: $90,930-$110,000 annually; depending on education/qualifications/experience

Time Appointment: 100% Appointment

Position Type: P&A Staff

The University offers a comprehensive benefits package that includes:

• Competitive wages, paid holidays, and generous time off
• Continuous learning opportunities through professional training and degree-seeking programs supported by the Regents Tuition Benefit Program
• Low-cost medical, dental, and pharmacy plans
• Healthcare and dependent care flexible spending accounts
• University HSA contributions
• Disability and employer-paid life insurance
• Employee wellbeing program
• Excellent retirement plans with employer contribution
• Public Service Loan Forgiveness (PSLF) opportunity
• Financial counseling services
• Employee Assistance Program with eight sessions of counseling at no cost
• Employee Transit Pass with free or reduced rates in the Twin Cities metro area

Please visit the Office of Human Resources website for more information regarding benefit eligibility.