Senior Financial Analyst - Pediatrics

The University of Iowa; Iowa City (IA); Sur place; USD 65 000 - 90 000; Plein temps

Résumé du poste

The University of Iowa seeks a Finance Analyst in the Stead Family Department of Pediatrics to support operating budget development, monthly accounting, reporting, and variance analysis. You will build pro formas for strategic initiatives and manage incentive plan reporting to inform leadership decisions.

Responsibilities include AAAP benchmarking data, dashboard development in Power BI, and complex financial analyses using Excel and SQL.

Qualifications

• Bachelor's degree in Finance, Accounting, Business Administration, Healthcare Administration, Data Analytics, MIS or equivalent.
• Minimum of 4 years of progressively responsible finance, accounting or healthcare analytics experience.
• Advanced Excel skills with pivot tables and data analysis capability.
• Experience developing reports and dashboards using Power BI or similar tools.
• Working knowledge of SQL to extract and manipulate data; strong communication skills.

Responsabilités

• Assist with operating budget development, submission, and implementation.
• Oversee monthly accounting, workflow, reporting, variance analysis, and reconciliations.
• Develop pro formas for business and strategic initiatives.
• Create, validate, and disseminate incentive plan reports.
• Lead data analytics and performance reporting using Power BI and Excel.

Connaissances

Advanced Excel

Power BI

SQL

Analytical skills

Communication skills

Formation

Bachelor's degree in Finance, Accounting, Business Administration, Healthcare Administration, Data Analytics, MIS

Outils

Epic Systems

Data Warehouse

Decision Support

Description du poste

Within the Stead Family Department of Pediatrics, assist with Operating Budget development, submission and implementation. Oversee monthly accounting, workflow, reporting, variance analysis and reconciliation processes. Perform financial analysis and develop proforma for business and strategic initiatives.

Create, validate, and disseminate incentive plan reports.

Calculate and track penalties including Charge Lag, Documentation Deficiency, Bumped Clinic, Compliance, and DRG (CDI) Queries.

Update the monthly faculty funding report.

Respond to ad hoc report requests from providers and executive leadership.

Assist the Finance Manager with annual budget preparation and salary posting.

Complete required reconciliations and reporting activities in accordance with established procedures.

Assess variance reports on revenue, expense, and other statistical measures. Prepare highly specialized reports as requested.

Financial Analysis and Planning

Perform complex financial, operational, and statistical analyses utilizing financial, clinical, and decision support systems.

Utilize decision support and data warehouse systems to develop pro formas and business analyses supporting operational and strategic initiatives.

Maintain and update the Formula Orders Spreadsheet, including pricing and documentation accuracy. Serve as the primary contact for PCD/PFS questions related to metabolic formula processes and Charity Care considerations.

Manage new bill area setup, provider/APP bill area requests, and Allowed Services reviews.

Manage the department's AAAP survey and benchmarking process end-to-end — completing routine and ad-hoc AAAP surveys, downloading and verifying the annual AAAP benchmark data, and analyzing results to inform faculty compensation and departmental benchmarking decisions.

Refresh the faculty salary setting file against benchmark data.

Data Analytics and Performance Reporting

Develop, maintain, and analyze operational and financial dashboards and reports utilizing Power BI, Excel, and other reporting tools to support departmental leadership decision-making.

Generate routine and ad hoc reports to support departmental leadership decision making.

Track and report key performance indicators, including:

• Revenue and collections
• Access and scheduling indicators
• Average daily census (ADC)
• Faculty and provider productivity

Identify trends, risks, and opportunities through data analysis and benchmarking.

Present findings and recommendations to departmental leadership and committee groups.

Leadership and Training

Deliver best-practice training to others.

Recommend and assist in developing training solutions to increase accuracy, efficiency, and effectiveness of financial transactions.

Advise leadership within the department on appropriate financial controls, transactions, and accounting processes.

May provide functional and/or administrative supervision (direction, assignments, feedback, coaching, and counseling) to assure outcomes are achieved.

Strategic Planning

Assist in coordination/preparation of analysis for strategic plans in support of DEO/administrator.

Support development and preparation of the department business plan.

Educational Requirements

Bachelor's degree in Finance, Accounting, Business Administration, Healthcare Administration, Data Analytics, Management Information Systems, or an equivalent combination of education and experience.

Experience Requirements

Minimum of 4 years of progressively responsible experience in finance, accounting, business analysis, healthcare analytics, or a related field.

Experience preparing and analyzing financial, statistical, and operational reports.

Demonstrated proficiency with Microsoft Excel, including advanced functions, pivot tables, and data analysis.

Experience developing reports and dashboards using Power BI or similar business intelligence tools.

Working knowledge of SQL or similar query languages to extract and manipulate data.

Strong analytical and problem-solving skills with the ability to identify trends, variances, and opportunities.

Demonstrated excellent verbal and written communication and interpersonal skills.

Desired Qualifications

Experience in academic medicine, healthcare finance, physician practice management, or hospital operations.

Experience using Epic, decision support, data warehouse, and healthcare reporting systems.

Experience developing and maintaining Power BI dashboards for executive leadership.

Experience with budgeting, forecasting, reconciliations, and variance analysis.

Job openings are posted for a minimum of 7 calendar days and may be removed from posting and filled any time after the original posting period has ended.

Successful candidates will be required to self-disclose any conviction history and will be subject to a criminal background check and credential/education verification. Up to 5 professional references will be requested at a later step in the recruitment process.

For additional questions, please contact [e-mail]

This position is not eligible for University sponsorship for employment authorization.

Additional Information

• Appointment Type: Professional and Scientific
• Schedule: Full-time
• Work Modality Options: Remote within Iowa

Compensation

Contact Information

• Contact Email: [e-mail]

Equal opportunity employer

The University of Iowa is an equal opportunity employer. All qualified applicants are encouraged to apply and will receive consideration for employment free from discrimination on the basis of race, creed, color, religion, national origin, age, sex, pregnancy (including childbirth and related conditions), disability, genetic information, status as a U.S. veteran, service in the U.S. military, sexual orientation, or associational preferences.

Persons with disabilities who need assistance or accommodations with the application or interview process may contact University Human Resources/Faculty and Staff Disability Services, [phone] or [e-mail] . For jobs in UI Health care, please contact UI Health care Leave & Disability Administration at 319-356-7543 .

My Profile

Create and manage profiles for future opportunities.

Contact us to learn more about how to qualify for Veteran's Preference.