Senior Reporting Healthcare Analyst (Expert Excel Skills & dashboard skills required with good communication skills)

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

TYPE OF WORK

Part Time

SALARY

6.00 hourly

HOURS PER WEEK

12

DATE UPDATED

Jul 10, 2026

JOB OVERVIEW

Overview:
We are seeking a detail-oriented, technically skilled analyst to build and maintain advanced reporting systems supporting referral tracking, clinician productivity, utilization review, and revenue metrics. This role also involves direct communication with clinicians regarding their quality and productivity metrics. This is a strategic analytics role — not an administrative or data-entry position — ideal for someone who thrives in Excel at an expert level, has a strong foundation in healthcare data, and communicates comfortably with clinical staff.
Responsibilities:

Design, build, and maintain complex Excel-based reporting systems (dashboards, automated trackers, linked workbooks)
Pull, clean, and analyze data from EHR/practice management systems
Develop monthly analytics on referral trends, clinician productivity, utilization review outcomes, and revenue performance
Track authorization statuses, session limits, and concurrent review deadlines to support timely utilization review submissions
Communicate directly with clinicians regarding their productivity and quality metrics, following up as needed to address gaps or trends
Identify data inconsistencies and recommend process improvements
Present findings in clear, digestible formats for clinical and administrative leadership
Maintain data integrity and confidentiality in accordance with HIPAA

Required Qualifications:

Expert-level Excel skills (VBA, Power Query, advanced formulas, dashboard design)
Demonstrated experience building complex, automated Excel systems (not just basic spreadsheets)
Strong SQL skills or equivalent database querying experience
Prior data analysis experience within a healthcare setting
Familiarity with utilization review workflows (authorizations, medical necessity criteria, payer review cycles)
Strong written and verbal communication skills, with experience relaying performance metrics to staff
Understanding of behavioral health billing/claims data a strong plus

Preferred Qualifications:

Experience with Python or R for data processing
Familiarity with AdvancedMD or similar healthcare practice management platforms
Background in revenue cycle, clinical operations, or utilization management analytics
Prior experience in a clinician-facing or supervisory-adjacent role

Please reply with resume and indicate that you have complete the PDF linked survey and email back ---------- ----------

Part-time, remote

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0007
Controller Execution Time ( Jobseekers / Job )  0.0214
Total Execution Time  0.0227
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,501,312 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Senior-Reporting-Healthcare-Analyst-Expert-Excel-Skills-dashboard-skills-required-with-good-communication-skills-1686746
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0141 seconds)  (Hide)
0.0009   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0009   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1686746
 LIMIT 1 
0.0009   SELECT *
FROM `employers`
WHERE `employer_id` = 746149
 LIMIT 1 
0.0009   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1686746
AND `misc`.`idIS NULL 
0.0010   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-07-16',ej.date_added) duration_daysDATEDIFF('2026-07-16',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_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-07-16',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1686746' 
0.0008   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1686746 
0.0015   UPDATE employer_jobs SET hit_counts '***Jul-10-2026=327***Jul-11-2026=140***Jul-16-2026=1' WHERE job_id'1686746'  
0.0011   UPDATE employer_jobs SET monthly_hits '***Jul-2026=468' WHERE job_id'1686746'  
0.0015   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1686746' AND status LIKE 'sent%' ORDER BY id DESC  
0.0009   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1686746 
0.0019   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '746149'
AND `date_added` >= '2022-06-08' 
0.0009   select from teasers 
0.0008   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)