Medical Billing, Data Analyst

Role Overview

• Analyze billing, claims, and payment data using Excel to identify trends, errors, and irregularities
• Build and maintain reports and dashboards to support revenue recovery and operational decision-making
• Use pivot tables, formulas, and lookup functions (VLOOKUP/XLOOKUP) to manipulate and interpret data
• Research denied or underpaid claims to identify root causes
• Assist in tracking payer trends and identifying recurring billing issues
• Support cross-functional teams (billing, coding, reimbursement) with data insights
• Recommend process improvements based on data findings
• Maintain accuracy and quality standards across reporting and billing workflows

Requirements

• Advanced Excel skills required (pivot tables, VLOOKUP/XLOOKUP, formulas, data analysis tools)
• Strong analytical and problem-solving skills
• Comfortable working with large datasets and identifying patterns
• Detail-oriented with a quality assurance mindset
• Strong written and verbal communication skills
• Self-motivated and able to work independently
• Preferred (Not Required) Internship or coursework in finance, healthcare administration, accounting, or analytics
• Exposure to medical billing or revenue cycle processes
• Experience working with claims, payments, or insurance data
• DME or healthcare-related billing exposure