Job Summary
We are looking for a detail-oriented and analytical RCM MIS Analyst to support healthcare Revenue Cycle Management (RCM) operations through accurate reporting, data analysis, dashboard development and performance monitoring.
The candidate will be responsible for preparing daily, weekly and monthly MIS reports, analyzing operational KPIs, identifying performance gaps and providing actionable insights to management to improve productivity, quality, collections and operational efficiency.
Key Responsibilities
1. MIS Reporting & Analysis
-
Prepare and publish daily, weekly and monthly MIS reports for RCM operations.
-
Consolidate data from multiple sources and maintain accurate reporting trackers.
-
Analyze operational performance across teams, processes and business units.
-
Develop management dashboards and performance reports.
2. RCM Metrics & KPI Analysis
-
Track and analyze key RCM metrics, including:
-
Gross Collection Rate (GCR)
-
Net Collection Rate (NCR%)
-
Accounts Receivable (AR) Aging
-
Denial Rate and Denial Management
-
First Pass Resolution Rate (FPRR)
-
Clean Claim Rate (CCR)
-
Days in AR (DAR)
-
Productivity and Quality %
-
Timely Filing (TFL)
-
Accounts Receivable Follow-up (AFL)
-
Monitor daily targets versus actual performance.
-
Identify trends, variances and operational improvement opportunities.
3. Advanced Excel & Data Management
-
Work extensively with Advanced Excel functions such as XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, Pivot Tables and Power Query.
-
Perform data validation, reconciliation, data cleaning and consolidation.
-
Automate recurring MIS reports wherever possible.
-
Maintain data accuracy and reporting integrity.
4. Dashboard & Business Intelligence
-
Develop and maintain interactive dashboards using Power BI.
-
Create DAX measures, calculated columns and performance KPIs.
-
Analyze historical trends and provide actionable insights.
-
Support automation of reporting processes using Power Automate and Python.
5. Stakeholder Management
-
Coordinate with Operations Managers, Team Leaders and Quality teams.
-
Understand reporting requirements and provide customized analytical reports.
-
Highlight performance gaps and escalate critical business trends.
-
Present analytical findings to management through structured reports and dashboards.
Required Skills & Qualifications
-
Bachelor’s degree in commerce, Business Administration, Statistics, IT or a related field.
-
3–6 years of experience in MIS reporting, preferably in healthcare RCM.
-
Strong knowledge of Advanced Excel and data analysis.
-
Good understanding of healthcare RCM processes and operational KPIs.
-
Working knowledge of Power BI and SQL.
-
Knowledge of Python and Power Automate will be an added advantage.
-
Strong analytical, problem-solving and communication skills.
Preferred Experience
-
Experience working with US healthcare RCM processes.
-
Knowledge of Medical Billing, AR Follow-up, Denial Management and Payment Posting.
-
Experience handling large datasets and multi-process operational reporting.
-
Ability to work with tight reporting deadlines and multiple stakeholders.
Key Competencies
-
Analytical thinking and attention to detail.
-
Ownership of reporting accuracy and timelines.
-
Problem-solving and data interpretation.
-
Stakeholder communication.
-
Process improvement and reporting automation