Financial Planning & Analytics (FP&A) Manager

Clarity Clinic•Chicago, IL

7d•$95,000 - $120,000•Remote

About The Position

What You'll Own Forecasting & Budgeting Build and maintain the annual budget model — driver-based, dynamic, and tied to real operational assumptions including provider capacity, payer mix, ramp curves, and headcount plans Lead the rolling monthly forecast, updating revenue, expense, and cash projections and surfacing risks and opportunities 60–90 days ahead Own cash flow forecasting in partnership with the VP, with specific attention to hiring timing and spend pacing Data Extraction & Analysis Go into AdvancedMD, Rippling, and other systems to pull the right data and answer the right questions — you're not waiting for someone to hand you a clean dataset Identify what the data is saying, structure it into a clear analysis, and bring a point of view back to the VP — not just the numbers but what they mean and what should happen next Over time, surface questions and trends the business hasn't thought to ask yet — the best financial planning and analytics work anticipates problems before they're visible to everyone else Reporting & Variance Analysis Deliver monthly variance analysis with written narrative — not just numbers but the operational story behind them Build and maintain Power BI dashboards tracking provider productivity, payer mix, collections performance, no-show impact, CPT-level margin, and cost per visit Produce board and executive reporting packages that are forward-looking and decision-ready, not static financial statements Financial Modeling & Decision Support Build pro formas for new locations, new service lines, and provider compensation structures Model provider-level profitability — revenue, collections, utilization, and allocated costs — to identify what's working and what isn't Produce scenario models for payer reimbursement changes, capital decisions, and incentive plan design Data & Systems Extract, clean, and connect data from AdvancedMD, Rippling, and other sources into Power BI reporting Partner closely with our Data Scientist — take their demand forecasting and capacity outputs and translate them into financial projections and planning assumptions Maintain clear definitions for core KPIs across the organization so finance and operations are speaking the same language Other Duties The above job description is not intended to be an all-inclusive list of duties and standards of the position. Incumbents will follow any other instructions and perform related duties, as assigned by their supervisor. Core Competencies The following competencies are required for this position and will be assessed during the hiring process, during the 90-day onboarding period, and as part of ongoing performance evaluation in accordance with Clarity Clinic's standards and Joint Commission requirements. Technical & Functional Competencies Financial Planning & Forecasting Demonstrates the ability to build, maintain, and update driver-based financial models including annual budgets, rolling forecasts, and cash flow projections. Produces work that is accurate, documented, and defensible without requiring supervisory reconstruction. Data Extraction & Systems Proficiency Demonstrates proficiency in extracting, cleaning, and structuring data from source systems including AdvancedMD, Rippling, and Power BI. Operates independently in these systems without reliance on IT or data teams for routine pulls. Healthcare Revenue Cycle Knowledge Demonstrates working knowledge of CPT-driven revenue models, payer mix dynamics, reimbursement mechanics, provider ramp curves, and collections performance. Applies this knowledge directly to financial planning assumptions and variance analysis. Financial Modeling & Decision Support Demonstrates the ability to build pro formas, scenario models, and provider-level profitability analyses that support strategic decisions including new location evaluation, provider compensation design, and capital investment cases. Reporting & Data Visualization Demonstrates the ability to build and maintain Power BI dashboards and produce board-ready reporting packages that are forward-looking, narrative-driven, and accessible to non-financial stakeholders. Behavioral & Professional Competencies Analytical Rigor Produces accurate, assumption-tested models and draws defensible conclusions. Identifies the root cause of variances rather than reporting surface-level results. Validates drivers and stress-tests outputs before presenting findings. Strategic Thinking Connects financial insights to operational and growth strategy. Proactively models decisions before they become urgent and surfaces risks and opportunities ahead of the planning cycle. Executive Communication Communicates complex financial findings clearly and concisely in written and verbal form. Translates technical analysis into recommendations that non-financial stakeholders can act on. Accountability & Ownership Takes end-to-end responsibility for forecast quality, reporting accuracy, and follow-through. Initiates work without being prompted and delivers finished products rather than works in progress. Collaboration & Operational Partnership Works effectively across departments and functions to align metrics, definitions, and accountability. Maintains clear lane discipline when working alongside the Data Scientist and other functional partners. Adaptability & Problem Solving Operates effectively in environments with imperfect or evolving data. Builds through ambiguity rather than waiting for perfect information and improves processes and definitions over time. Professional & Ethical Conduct Maintains confidentiality of financial, operational, and patient-adjacent data in accordance with Clarity Clinic policy and applicable regulatory requirements. Demonstrates integrity in all financial reporting and modeling activities.

Requirements

3+ years in FP&A, strategic finance, or financial modeling with progressively increasing ownership
Personally built and maintained a full budget and rolling forecast cycle — not supported someone else who did it
Demonstrated ability to go into source systems, extract data, and structure it into meaningful analysis without being told exactly how
Advanced Excel modeling skills — driver-based models, scenario analysis, sensitivity tables
Hands-on Power BI experience preferred — you build and maintain dashboards, you don't request them
Strong written communication — you can explain what the numbers mean and what to do about it
Comfortable operating in environments where data is imperfect and processes are still being built
Someone who brings answers and a point of view, not just completed tasks
Experiences with data systems (PowerBi, Cognos, Tableau, Zoho), Power BI not required
Some experience with P&L/payroll/operational inputs

Nice To Haves

AdvancedMD experience (significant plus)
Multi-site outpatient healthcare, behavioral health, or medical group background
Familiarity with payer mix dynamics, CPT-driven revenue models, and reimbursement mechanics
Experience working alongside or translating outputs from data science or analytics teams
Rippling or comparable HRIS/payroll system experience

Responsibilities

Build and maintain the annual budget model — driver-based, dynamic, and tied to real operational assumptions including provider capacity, payer mix, ramp curves, and headcount plans
Lead the rolling monthly forecast, updating revenue, expense, and cash projections and surfacing risks and opportunities 60–90 days ahead
Own cash flow forecasting in partnership with the VP, with specific attention to hiring timing and spend pacing
Go into AdvancedMD, Rippling, and other systems to pull the right data and answer the right questions — you're not waiting for someone to hand you a clean dataset
Identify what the data is saying, structure it into a clear analysis, and bring a point of view back to the VP — not just the numbers but what they mean and what should happen next
Over time, surface questions and trends the business hasn't thought to ask yet — the best financial planning and analytics work anticipates problems before they're visible to everyone else
Deliver monthly variance analysis with written narrative — not just numbers but the operational story behind them
Build and maintain Power BI dashboards tracking provider productivity, payer mix, collections performance, no-show impact, CPT-level margin, and cost per visit
Produce board and executive reporting packages that are forward-looking and decision-ready, not static financial statements
Build pro formas for new locations, new service lines, and provider compensation structures
Model provider-level profitability — revenue, collections, utilization, and allocated costs — to identify what's working and what isn't
Produce scenario models for payer reimbursement changes, capital decisions, and incentive plan design
Extract, clean, and connect data from AdvancedMD, Rippling, and other sources into Power BI reporting
Partner closely with our Data Scientist — take their demand forecasting and capacity outputs and translate them into financial projections and planning assumptions
Maintain clear definitions for core KPIs across the organization so finance and operations are speaking the same language

Benefits

Full comprehensive benefits package including health, dental, vision, EAP services and more
Monthly Wellness Reimbursement to promote your self-care routine & well-being
401k match up to 4%
Opportunities for growth and professional development
15 days of accrued PTO and up to 5 sick/wellness days

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume