Business and Financial Analyst

Important Applicant Notice: Due to the onsite requirements of this role and the high volume of applications received, consideration will be limited to candidates currently located in Illinois who are able to perform the duties of the position in person in Northbrook, IL.

Position Overview

We are seeking a highly analytical and detail-oriented Business & Financial Analyst to drive data-driven decision-making across our financial, clinical operations, grants and revenue cycle operations. The primary responsibility will be creating sophisticated financial and statistical analysis around healthcare RCM and financial KPIs.

The ideal candidate will transform raw healthcare data into actionable insights through statistical analysis, trend reporting, KPI tracking, and interactive dashboard creation. The analyst will evaluate critical financial metrics—including gross margins, cost overruns, and liquidity—and directly support the monthly financial close process. 

Other analysis will include evaluating optimum efficiency of clinical operations to ensure a sustainable balance of revenue generation and cost management. 

Key Responsibilities

Financial & Statistical Analysis

• Develop and maintain statistical models to analyze healthcare RCM performance, identifying trends, bottlenecks, and optimization opportunities.
• Conduct comprehensive financial metric evaluations, including detailed gross margin analysis, tracking cost overruns, and evaluating organizational liquidity.
• Prepare regular variance analysis and trend reports to help leadership understand financial fluctuations.
• Analyze and prepare (when necessary) revenue recognition schedules
• Maintain accounts receivable model for accurate net AR capture and roll-forwards

KPI Tracking & Dashboard Creation

• Design, build, and maintain automated dashboards and visual reports in Power BI or other comparable packages to track key operational and financial healthcare metrics.
• Monitor and report on critical RCM KPIs (e.g., Days Sales Outstanding (DSO), Days Cash on Hand DCOH), clean claim rates, denial rates, and collection efficiency.
• Translate complex data sets into clear, scannable, and executive-ready visual presentations.

Month-End Close & Team Support

• Partner directly with the accounting team to assist with the month-end close process within NetSuite, ensuring accuracy in financial reporting.
• Support the RCM leadership team by preparing monthly operational packages, financial reports, and specialized data deep-dives utilizing records from SmartCare.
• Collaborate with cross-functional teams to investigate data anomalies, reconcile system discrepancies, and streamline financial reporting workflows.

Required Qualifications

• Bachelor’s degree in accounting or finance is strictly required.
• Minimum of 5 years of experience working as a financial and/or business analyst.
• Advanced knowledge of MS Excel (e.g., advanced formulas, Pivot Tables with query slicers, Power Query, macros, complex financial modeling).
• Proficient user of Power BI with a proven track record of building data models and production-level dashboards.

Preferred Qualifications

• Prior analytical experience within the healthcare industry (highly preferred).
• Hands-on experience working with NetSuite (ERP) and SmartCare (EHR/billing platform) is highly desirable.
• Strong working knowledge of healthcare insurance, billing workflows, and RCM concepts.
• Experience working within a Not-for-Profit (NFP) and/or grant-based organization is a major plus.