RCM MIS & Reporting Analyst

Location: Gurugram, Haryana, India

• Build and maintain daily, weekly, and monthly MIS reports and dashboards for RCM operations (AR, denials, payment posting, charge posting).
• Consolidate and integrate data from multiple trackers and sources into clean, unified reports.
• Track key RCM metrics — AR aging, denial rates, collections, productivity — and highlight trends and exceptions.
• Prepare and present performance data to operations leads and stakeholders in a clear, decision-ready format.

• Clean, validate, and reconcile operational data to ensure accuracy before reporting.
• Run data exports from EHR / practice-management systems (Advanced MD, athenahealth, eCW, or similar) and build the data feeds/pipelines that power reporting.
• Use advanced Excel (pivot tables, lookups, formulas, and macros where needed) to structure and analyze large datasets.
• Build and maintain dashboards and visuals in Power BI (or similar) for management visibility.
• Support ad-hoc data requests and analysis from operations and leadership.

• Work closely with RCM operations teams (AR, denials, posting) to understand reporting needs and data sources.
• Help standardize reporting formats, templates, and refresh routines.
• Flag data-quality issues and suggest ways to make recurring reporting faster and cleaner.

• 1–3 years in an MIS, reporting, or analyst role within Revenue Cycle Management (RCM) or a healthcare BPO/KPO.
• Solid understanding of RCM processes — AR, denials, payment posting, charge posting — and the key metrics that matter.
• Advanced Excel skills (pivot tables, VLOOKUP / XLOOKUP, formulas, data cleanup). This is essential.
• Familiarity with EHR / practice-management systems (e.g., Advanced MD, athenahealth, eCW) to run data exports and pull reporting data.
• Ability to consolidate, structure, and present data clearly to operational stakeholders.
• Strong attention to detail and a validation mindset — making sure numbers are accurate before they go out.
• Good written and verbal communication skills.

• Working knowledge of Power BI (or a similar BI tool) for dashboards and visualization.
• Exposure to basic SQL for pulling and querying data.

• Knowledge of Python is a plus (for automating reports or data preparation).
• Experience with RCM platforms or practice-management systems.
• Familiarity with automating or streamlining recurring reports.