Data Analyst - Revenue Cycle Management

The Data Analyst is responsible for analyzing, monitoring, and reporting on healthcare Revenue Cycle Management (RCM) performance to support operational efficiency, revenue optimization, and strategic decision-making. This role works closely with billing, coding, collections, denial management, credentialing, finance, operations, and executive leadership to identify trends, improve workflows, and maximize reimbursement outcomes., Revenue Cycle Analytics

• Analyze key RCM performance indicators including: Days in Accounts Receivable (A/R), Net Collection Rate, Gross Collection Rate, Denial Rates, First Pass Resolution Rate, Charge Lag, Payment Variances, Underpayment Trends, Aging Reports, and Client specific report requests, as identified by Director
• Monitor payor reimbursement trends and identify opportunities for revenue improvement.
• Perform root cause analysis related to denials, billing edits, coding trends, and payment delays.
• Identify revenue leakage and operational inefficiencies across the revenue cycle.

Reporting & Dashboard Development

• Develop and maintain recurring operational, financial, and executive-level reports.
• Build dashboards and scorecards utilizing tools such as Power BI, Tableau, Excel, or other business intelligence platforms.
• Automate reporting processes to improve accuracy and efficiency.
• Ensure data integrity through routine audits, reconciliation, and validation activities.

Data Management & Analysis

• Extract, manipulate, and analyze large datasets using SQL, Excel, and reporting tools.
• Combine data from practice management systems, clearinghouses, EHR/EMR platforms, and payor reports.
• Support ad hoc analysis requests from leadership and operational teams.
• Translate complex data findings into actionable business recommendations.

Operational Collaboration

• Collaborate with billing, coding, AR follow-up, patient access, and operational leadership to improve workflows and performance.
• Assist with payor audits, compliance initiatives, and process improvement projects.
• Participate in implementation and optimization of reporting tools and system enhancements.
• Support KPI tracking and operational performance management initiatives.

Do you have experience in SQL?, Do you have a Bachelor’s degree?, The ideal candidate possesses strong analytical skills, healthcare revenue cycle knowledge, and experience with reporting tools, dashboards, and healthcare data systems., * Advanced Microsoft Excel skills including Pivot Tables, VLOOKUP/XLOOKUP, formulas, and data modeling.

• Experience with SQL querying and database analysis.
• Proficiency with business intelligence tools such as Power BI or Tableau.
• Strong analytical, organizational, and problem-solving abilities.
• Ability to interpret large datasets and present findings clearly to both technical and nontechnical audiences., * Bachelor’s degree in Healthcare Administration, Finance, Business Analytics, Information Systems, or related field preferred.
• Minimum of 2-5 years of healthcare data analysis or RCM analytics experience preferred.
• Strong understanding of professional and/or hospital billing workflows.
• Knowledge of: Claims processing, Denial management, Payment posting, Coding and reimbursement methodologies, and Insurance payor processes

Preferred Skills

• Experience in emergency medicine, urgent care, physician services, or multi-specialty RCM environments.
• Experience with healthcare systems such as Epic, Athenahealth, NextGen, eClinicalWorks, or similar EMR/PM systems
• Familiarity with CPT, ICD-10, HCPCS, and payor reimbursement methodologies.
• Understanding of HIPAA compliance and healthcare data privacy regulations.
• Experience with predictive analytics, automation, or AI-assisted reporting tools preferred.
• Communication and presentation skills
• Process improvement mindset
• Ability to work independently and collaboratively in a fast-paced environment

$65,000 - $75,000 a year - Full-time, Pulled from the full job description

• 401(k)
• Health insurance
• Paid time off
• Vision insurance
• Health savings account
• Dental insurance, * 401(k)
• Dental insurance
• Health insurance
• Health savings account
• Paid time off
• Vision insurance