Required Skills

phppower bisqltableau

Job Description

We are seeking an experienced RCM Analytics Representative to support a multi\-entity

behavioral health and substance use disorder treatment portfolio. This role transforms raw

revenue cycle data — claims, payments, denials, and AR — into clear, actionable dashboards

and reports that drive operational and financial decision\-making. The ideal candidate is fluent in

healthcare RCM concepts and is a strong hands\-on builder in modern BI tools, capable of

turning large, messy datasets into reliable, automated reporting that leadership can trust.

Design, build, and maintain interactive dashboards and reports in Power BI (and Sisense
or comparable BI platforms) covering the full revenue cycle.
Develop and automate recurring reporting: claims billed, AR aging, payments and
collections, denial trends, and net collection rate across multiple entities.
Build expected\-reimbursement and payer\-rate models by level of care (PHP, IOP, OP) and
service line to surface underpayments and variance.
Source, clean, and reconcile data from billing/EHR systems (e.g., CollaborateMD, Kipu)
and payer remittance files (835/ERA, EOBs).
Create KPI scorecards for RCM functions including VOB turnaround time (TAT), clean
claim rate, days in AR, denial rate, and collector/team productivity.
Partner with billing, collections, and VOB teams to translate operational needs into
reporting requirements.
Identify data\-quality issues and reconciliation discrepancies (e.g., adjustment mismatches)

BI / Dashboarding: Demonstrated, hands\-on experience building dashboards in Power
BI; experience with Sisense (or a comparable platform such as Tableau, Sigma, or
Looker) strongly preferred.
RCM Knowledge: Solid understanding of the healthcare revenue cycle — claims,
payments, denials, AR aging, adjustments, and net collections.
Data Skills: Strong Excel (pivot tables, advanced formulas) and SQL for data extraction,
transformation, and reconciliation.
Data Modeling: Experience with DAX, Power Query, and building clean data models from
multiple, imperfect source systems.
Accuracy: Meticulous attention to detail with a track record of producing reliable,
reconciled, audit\-ready reporting.
Communication: Able to present data clearly to non\-technical stakeholders and work
fluently in English with a US\-based leadership team.

Reporting delivered accurately and on schedule for monthly end\-of\-month close and

weekly operational reviews.

Dashboards are reliable, reconciled to source, and require minimal manual rework.
Data discrepancies are proactively flagged and resolved.

Pay: ₹15,000\.00 \- ₹45,000\.00 per month

Work Location: Remote