Manager, RCM Reporting & Analytics

TAG - The Aspen Group•Chicago, IL

13d•$120,000 - $140,000

About The Position

The Manager, RCM Reporting & Analytics is a critical leadership role within Aspen Dental Management, Inc. (ADMI), responsible for building, maintaining, and evolving an analytics function that drives operational excellence and financial performance across the revenue cycle. This role focuses on denials management, accounts receivable aging, collections performance, and claim analytics within the dental DSO environment. Reporting to the Director, Payer Strategy & RCM Analytics, the manager will be the primary analytics resource for the RCM organization, translating complex billing and collections data into actionable business intelligence. The ideal candidate possesses deep revenue cycle expertise, advanced data analytics capabilities, and a passion for using data to improve revenue recovery and operational efficiency.

Requirements

Bachelor’s degree in Healthcare Administration, Finance, Business, Health Information Management, Data Science, or a related field required.
Minimum 5–7 years of progressive experience in healthcare revenue cycle management.
At least 2 years in an analytics or reporting leadership role.
Experience in a dental DSO, group dental practice, or multi-site dental environment strongly preferred; broader healthcare (physician group, health system) experience considered.
Demonstrated experience with dental claims processing, CDT coding, dental benefits coordination, and payer reimbursement in a high-volume environment.
Advanced proficiency in Tableau required.
Strong SQL skills; ability to write complex queries across large relational databases and data warehouses (SQL Server or Google BigQuery preferred).
Advanced Microsoft Excel skills (pivot tables, Power Query, financial modeling).
PowerPoint proficiency for executive-level presentations.
Familiarity with healthcare data standards including CDT/CPT codes and EDI 837/835 electronic claim formats.
Exceptional analytical and critical thinking skills with a proven ability to work with large, complex, and disparate data sets to derive meaningful insights.
Strong problem-solving orientation; ability to structure ambiguous business problems, develop analytical approaches, and drive to actionable conclusions.
High attention to detail and commitment to data accuracy and integrity.
Excellent written and verbal communication skills; comfortable translating complex data narratives for non-technical audiences and presenting to senior leadership.
Ability to manage multiple priorities in a fast-paced, high-growth DSO environment and deliver against competing deadlines.

Nice To Haves

Master’s degree preferred.
Familiarity with dental practice management systems (Dentrix, Eaglesoft, Dentrix Ascend, or similar) and/or RCM platforms (Waystar, Navicure, athenahealth) is a strong plus.
Experience with Python or R for statistical analysis is a plus.

Responsibilities

Design, develop, and maintain enterprise-grade Tableau dashboards and reporting solutions to monitor RCM operational performance, including clean claim rate, denial rate, days in AR, first-pass resolution rate, and net collection rate.
Own and deliver weekly, monthly, and ad hoc RCM reporting packages covering denials, AR aging, collections performance, and payer mix across dental practices and regions.
Translate complex operational and financial data into clear, actionable visualizations for diverse audiences.
Identify opportunities to automate recurring reports and analyses.
Partner with IT and data engineering teams to optimize data pipelines, warehouse structures, and source system integrations supporting RCM analytics.
Establish and enforce data governance standards, ensuring dashboard accuracy, consistency, and reliability.
Produce detailed AR aging reports segmented by payer, practice, region, and bucket; identify accounts at risk and escalate accordingly.
Conduct in-depth analysis of AR aging, bad debt reserves, write-offs, and payer-specific collection trends.
Develop and maintain financial models to forecast AR performance, cash collections, and revenue realization.
Analyze bad debt patterns by payer, service line, and practice segment; recommend mitigation strategies.
Support month-end and quarter-end financial close processes by providing accurate AR reconciliation data and variance commentary.
Monitor contractual adjustments, underpayments, and payer contract compliance; escalate discrepancies.
Monitor and analyze denial trends by payer, denial reason code, and service type; identify root causes and surface actionable recommendations.
Analyze end-to-end claims processing workflows to identify bottlenecks, denial patterns, and root causes of revenue leakage specific to dental billing.
Develop scorecards and performance metrics for RCM operational teams and support productivity benchmarking.
Monitor charge capture, coding accuracy, and charge integrity.
Track collections rates, net collection rates, first-pass resolution rates, and other core RCM metrics; deliver regular performance updates.
Support ad hoc analyses related to payer mix shifts, new service line launches, contract negotiations, and system implementations.
Manage and mentor a team of analysts, fostering a culture of analytical rigor, curiosity, and continuous improvement.
Serve as a trusted analytics partner to RCM operational leaders, translating business questions into analytical frameworks and actionable recommendations.
Collaborate cross-functionally with Billing, Coding, Payer Analytics, Finance, and IT teams to improve data quality, reporting infrastructure, and RCM outcomes.
Present findings, insights, and recommendations to senior leadership.
Stay current with dental industry trends, payer policy changes, and best practices in RCM analytics and dental practice management.
Provide light support to the FP&A team on RCM-related budget variance analysis and forecasting as needed.
Assist with ad hoc financial modeling or analysis requests related to revenue cycle performance.