Revenue Cycle Data Analyst

Revenue Cycle Data Analyst

Columbus, OH

Pain Management Group is currently searching for a full-time Revenue Cycle Data Analyst to join their team!

Position Summary: This position is responsible for overseeing charge capture accuracy, billing reconciliation, payment integrity, and vendor performance across PMG’s revenue cycle within our hospital partnerships. Through advanced data modeling and variance analysis, this position transforms billing and reimbursement data into actionable insights that drive financial performance and reduce revenue leakage. This position partners closely with internal operations and PMG’s third-party billing company to ensure services rendered are billed, adjudicated, and reimbursed accurately while proactively identifying trends, variances, and process improvement opportunities through data analysis.

What we can offer YOU:

• Dental insurance
• Health insurance
• Vision insurance
• Life insurance
• Disability insurance
• Pay: $50,000 – $60,000/year, offer dependent on experience

Schedule:

• Monday to Friday
• Remote
• Minimal to no travel; any travel needed would be for job training, annual corporate events, and as needed meetings

Required Qualifications:

• 3 years of experience in healthcare data analysis
• Demonstrated experience working with large data sets and performing structured data analysis
• Advanced Excel skills (pivot tables, XLOOKUP/VLOOKUP, reconciliation logic, data modeling, financial analysis)
• Strong analytical, investigative, and problem-solving skills
• Ability to translate complex data findings into actionable operational recommendations for both operational and financial stakeholders

Preferred Qualifications:

• Experience working with a third-party billing company
• Experience in professional billing, hospital-based services, or specialty practices
• Familiarity with CPT, modifiers, and payer contract language
• Familiarity with EHR systems is preferred (Epic, Cerner, Meditech, etc.)
• Experience with BI tools (Power BI, Tableau) or SQLStrong understanding of the claim lifecycle, EOBs/ERAs, and payer adjudication
• Background in payment integrity, audit, or compliance analytics

Typical day in the life as a Revenue Cycle Data Analyst:

• Develop and maintain a comprehensive charge batch tracking system (Excel-based) by collaborating with operations to align provider schedules, encounters, and expected charges.
• Reconcile internal charge tracking with submissions and billing activity from the third-party billing company to ensure all services rendered are billed accurately and timely.
• Identify missing, delayed, or incorrectly billed charges and work with internal teams and the billing vendor to resolve discrepancies.
• Investigate and resolve variances between expected charges, billed charges, and adjudicated claims.
• Perform root cause analysis for recurring variances, including issues related to charge capture, coding, modifiers, payer processing, or billing workflows.
• Document findings and recommend process improvements to reduce future revenue leakage.
• Compare actual reimbursements against contracted payer fee schedules to validate payment accuracy.
• Identify underpayments, trend issues by payer or service line, and support recovery efforts.
• Maintain payer reimbursement benchmarks and assist with contract performance evaluations.
• Develop and maintain monthly revenue cycle KPI dashboards, including but not limited to: Charge lag, Charge capture completeness, Billing timeliness, High-dollar claim status, Payment variance and underpayment trends, Vendor performance metrics
• Present insights and trends to leadership with clear, actionable recommendations.
• Serve as a key point of contact for the third-party billing company regarding reconciliation, variances, and performance issues.
• Support vendor accountability through data transparency, issue tracking, and follow-up.

If you feel as though you would make a great fit for this position, please submit a current resume for review!

We partner with health systems and independent hospitals to provide safe and responsible pain management care in the communities they serve. Our partners are provided with the blueprint and ongoing program management resources to cultivate a robust, outpatient pain management service line through Balanced treatment approach, Hosital-based model, Program sustainability, Quantifiable outcomes and results.

Salary : $50,000 - $60,000