Josselyn

Business and Financial Analyst

Josselyn Northbrook, Illinois, United States · $70K–$85K/yr

Mental Health Care · 201-500 employees

Oct 21
Senior (5-10 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The analyst will create sophisticated financial and statistical models to drive data-driven decision-making regarding healthcare revenue cycle and financial KPIs. They will also partner with the accounting team to support month-end close processes and maintain automated dashboards for operational reporting.

What they look for

Financial Analysis Statistical Analysis Revenue Cycle Management KPI Tracking Dashboard Creation Power BI Microsoft Excel Financial Modeling NetSuite SmartCare Variance Analysis Revenue Recognition Accounts Receivable Data Modeling Healthcare Billing

Requirements

Candidates must hold a bachelor's degree in accounting or finance and possess at least 5 years of experience in financial or business analysis. Proficiency in MS Excel and Power BI is required, with preference given to those with healthcare industry experience.

Full description

Job Details: Job Location: Northbrook Office - Northbrook, IL, Position Type: Full Time, Education Level: 4 Year Degree, Salary Range: $70000.00 - $85000.00Salary, Job Category: Finance, 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. Qualifications: 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.