RCM Analytics Representative at vArida-Tech — Remote | Apply 2026 | 3rangaV
RCM Analytics Representative
RemoteFull-timevia indeed 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)
- *Required Qualifications**
- 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.
- Primary BI tools: Power BI, Sisense
- Data: SQL, Excel, payer remittance files (835/ERA)
- Source systems: CollaborateMD, Kipu (behavioral health RCM)
- Compliance: HIPAA / PHI security protocols (BAA required prior to PHI access)
- *Performance Expectations**
- 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
Job Overview
- Job type
- Full-time
- Work mode
- Remote
- Location
- Anywhere in India
- Posted
- 1d ago
- Source
- Indeed
and drive them to resolution.Ensure all reporting and data handling complies with HIPAA and organizational PHIsecurity standards.Deliver ad hoc analyses and executive\-ready summaries on tight timelines.Preferred QualificationsDirect experience in behavioral health or substance use disorder (SUD) billing andreporting.Familiarity with behavioral health levels of care and codes (PHP / H0035, IOP / S9480,detox, residential) and associated per\-diem and per\-unit reimbursement.Experience working with payer remittance data (835/ERA) and EOB analysis.Working knowledge of CollaborateMD, Kipu, or similar behavioral health EHR/billingplatforms.Experience supporting multi\-entity or multi\-facility healthcare organizations.Exposure to automated/scheduled reporting pipelines and data refresh management.