Manager, RCM Reporting & Analytics

Aspen Dental•Chicago, IL

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

About The Position

The Manager, RCM Reporting & Analytics is a critical leadership role within Aspen Dental Management, Inc. (ADMI), one of the largest and fastest-growing dental service organizations in the country. This position is responsible for building, maintaining, and evolving an analytics function that drives operational excellence and financial performance across the revenue cycle — with a primary focus on denials management, accounts receivable aging, collections performance, and claim analytics specific to the dental DSO environment. Reporting to the Director, Payer Strategy & RCM Analytics, this manager will serve as the primary analytics resource for the RCM organization, translating complex billing and collections data into clear, actionable business intelligence. The ideal candidate combines deep dental or medical revenue cycle expertise with advanced data analytics capabilities and a passion for turning complex data into decisions that directly impact revenue recovery and operational efficiency.

Requirements

Bachelor’s degree in Healthcare Administration, Finance, Business, Health Information Management, Data Science, or a related field required; Master’s degree preferred.
Minimum 5–7 years of progressive experience in healthcare revenue cycle management, with 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; demonstrated ability to build complex, interactive dashboards with calculated fields, LOD expressions, and performance optimization.
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

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 — from frontline billing staff to C-suite executives.
Identify opportunities to automate recurring reports and analyses, reducing manual effort and improving data delivery timelines.
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 across all reporting environments.
Produce detailed AR aging reports segmented by payer, practice, region, and bucket (0-30, 31-60, 61-90, 90+ days); identify accounts at risk and escalate accordingly.
Conduct in-depth analysis of AR aging, bad debt reserves, write-offs, and payer-specific collection trends to identify financial risks and opportunities.
Develop and maintain financial models to forecast AR performance, cash collections, and revenue realization under various operational scenarios.
Analyze bad debt patterns by payer, service line, and practice segment; recommend mitigation strategies to reduce financial exposure.
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 for timely follow-up and recovery.
Monitor and analyze denial trends by payer, denial reason code, and service type; identify root causes and surface actionable recommendations for denial prevention and appeals.
Analyze end-to-end claims processing workflows to identify bottlenecks, denial patterns, and root causes of revenue leakage specific to dental billing (CDT codes, dental benefits, coordination of benefits).
Develop scorecards and performance metrics for RCM operational teams (billing, coding, authorization, follow-up) and support productivity benchmarking across practices.
Monitor charge capture, coding accuracy, and charge integrity to identify compliance risks and revenue optimization opportunities.
Track collections rates, net collection rates, first-pass resolution rates, and other core RCM metrics; deliver regular performance updates to operational leadership.
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 in a clear, concise, and compelling manner.
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.