Financial Analyst/Modeler for US-based healthcare company

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Gig

SALARY

$5/hour

HOURS PER WEEK

10

DATE UPDATED

Oct 23, 2026

JOB OVERVIEW

We’re a ~20-person US-based outpatient mental health group practice that is growing fast. We’re looking for a skilled financial modeler to help us turn our operating data into clear, decision-ready models. This will initially be a Gig opportunity with the option to move to part-time as needs develop

What you’ll do
* Build and maintain a driver-based profitability model in Excel or Google Sheets, linking clinician headcount, caseloads, session volume, payer mix and reimbursement rates to revenue and margin
* Model payroll as a percentage of revenue under different compensation structures (salaried vs. fee-for-service clinicians)
* Run scenarios for hiring decisions, such as the break-even point for a new clinician or supervisor
* Produce a simple monthly dashboard P&L exports
* Document your assumptions so the leadership team can understand and validate the model
* Potentially manage and update our quickbooks account

What we need
* 3+ years building three-statement or operating models (please share an anonymized sample)
* Advanced Excel or Google Sheets: scenario tables, lookups, clean structure with no hard-coded numbers in formulas
* Written & spoken English good enough to explain your model to a non-finance reader
* At least 2 hours of daily overlap with US Eastern time (9am to 5pm ET)

Nice to have
* Experience with US healthcare or professional services businesses (insurance billing, utilization, provider productivity)
* Familiarity with franchise royalty structures
* Experience working with QuickBooks or similar accounting exports

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0007
Controller Execution Time ( Jobseekers / Job )  0.0103
Total Execution Time  0.0115
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,474,992 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Financial-AnalystModeler-for-US-based-healthcare-company-1755151
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0048 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
= 'USD-PHP' 
0.0003   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1755151
 LIMIT 1 
0.0003   SELECT *
FROM `employers`
WHERE `employer_id` = 868832
 LIMIT 1 
0.0003   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1755151
AND `misc`.`id` IS NULL 
0.0004   SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-10-25',ej.date_added) duration_days, DATEDIFF('2026-10-25',e.rebill_date) duration_rebill, ej.*, e.deactivate FROM employers e, employer_jobs ej WHERE e.employer_id = ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id = '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-10-25',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1755151' 
0.0002   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1755151 
0.0006   UPDATE employer_jobs SET hit_counts = '***Oct-23-2026=446***Oct-24-2026=58***Oct-25-2026=10' WHERE job_id= '1755151'  
0.0006   UPDATE employer_jobs SET monthly_hits = '***Oct-2026=514' WHERE job_id= '1755151'  
0.0003   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1755151' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1755151 
0.0003   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '868832'
AND `date_added` >= '2022-06-08' 
0.0003   select * from teasers 
0.0003   SELECT * FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)