Senior Financial Analyst - Pediatrics

UIOWA • Iowa City, IA

11d • Remote

About The Position

The Senior Financial Analyst supports the Stead Family Department of Pediatrics with operating budget development, submission, and implementation. The position oversees monthly accounting workflows, reporting, variance analysis, and reconciliations, and conducts financial analysis and pro forma development for business and strategic initiatives. The role supports incentive plan administration, faculty funding and salary reporting, budgeting, financial tracking, formula-order processes, bill area and allowed-services reviews, and AAAP surveys and benchmarking. It also develops and maintains operational and financial dashboards and reports, tracks departmental performance indicators, identifies trends and risks, and presents findings and recommendations to leadership and committees. The analyst advises on financial controls and accounting processes, provides best-practice training, and supports strategic planning and department business plan development. The position is eligible for remote work within Iowa, subject to applicable work arrangement and remote-work policies.

Requirements

• Bachelor's degree in Finance, Accounting, Business Administration, Healthcare Administration, Data Analytics, Management Information Systems, or an equivalent combination of education and experience.
• At least 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.
• 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 for extracting and manipulating data.
• Strong analytical and problem-solving skills, including the ability to identify trends, variances, and opportunities.
• Excellent verbal and written communication and interpersonal skills.

Nice To Haves

• 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.

Responsibilities

• Assist with operating budget development, submission, and implementation.
• Oversee monthly accounting, workflow, reporting, variance analysis, and reconciliation processes.
• Create, validate, and distribute incentive plan reports; track provider RVUs and calculate and track applicable penalties.
• Update the monthly faculty funding report and respond to ad hoc reporting requests from providers and executive leadership.
• Assist the Finance Manager with annual budget preparation and salary posting.
• Complete required reconciliations and reporting activities, and assess revenue, expense, and statistical variance reports.
• Prepare specialized financial, operational, and statistical reports and analyses.
• Develop pro formas and business analyses using decision support and data warehouse systems to support operational and strategic initiatives.
• Maintain and update the Formula Orders Spreadsheet, including pricing and documentation accuracy, and 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, including routine and ad hoc surveys, annual benchmark data verification and analysis, and faculty salary setting file updates.
• Develop, maintain, and analyze operational and financial dashboards and reports using Power BI, Excel, and other reporting tools.
• Track and report key performance indicators, including revenue and collections, work RVUs, patient volumes, clinic utilization, patient satisfaction, access and scheduling, inpatient volumes, average daily census, and faculty and provider productivity.
• Identify trends, risks, and opportunities through data analysis and benchmarking, and present findings and recommendations to leadership and committee groups.
• Deliver best-practice training and recommend or help develop training to improve the accuracy, efficiency, and effectiveness of financial transactions.
• Advise departmental leadership on financial controls, transactions, and accounting processes.
• May provide functional and/or administrative supervision, including direction, assignments, feedback, coaching, and counseling.
• Assist with analysis for strategic plans in support of the DEO/administrator and support development and preparation of the department business plan.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior