PBS Reporting Analyst

MemorialCare; Colonia Juarez (CA); Remote; USD 42,000 - 61,000; Full time

Benefits offered by this job

Health insurance

Bonus opportunities

Remote work options

Job summary

MemorialCare is seeking a PBS Reporting Analyst to analyze patient billing, claims, and revenue cycle performance. You will develop dashboards and reports to drive leadership decisions, monitor KPIs, and identify revenue leakage.

The role collaborates with billing, coding, finance, IT, and clinical teams to ensure data accuracy and compliant reporting. The ideal candidate has 10+ years in patient account billing with strong Excel/SQL and BI tool experience, plus Epic/NextGen/QNXT knowledge.

Qualifications

• Ten years of experience in patient account billing and collections, with at least five years in analytics/reporting in healthcare revenue cycle.
• Strong understanding of healthcare revenue cycle operations, payer requirements, and regulatory guidelines.
• Advanced proficiency with Excel, SQL, databases, billing systems, EHRs, and BI tools; Python preferred.
• Experience designing queries and transforming revenue cycle data into reports and dashboards.
• Experience with Epic/NextGen/QNXT or similar systems and data extraction from Epic Clarity/Resolute.
• Lean or Six Sigma experience is a plus.
• Excellent written and verbal communication; able to present to leadership.
• Proactive, able to manage multiple projects in a dynamic environment.

Responsibilities

• Provide professional and courteous service to customers and communicate effectively.
• Maintain HIPAA-compliant confidentiality for patient and employer data.
• Collaborate with cross-functional teams and attend mandatory meetings.
• Prioritize and multitask; adapt to workload changes and deadlines.
• Inform leadership promptly if problems affect timely completion of work.
• Maintain a clean, organized, secure work area.
• Adhere to remote or hybrid work agreements when applicable.
• Follow company policies and procedures.
• Translate complex data into clear insights for stakeholders.

Skills

Excel

SQL

Power BI

Tableau

Python

Data visualization

Communication

Analytical thinking

Education

Bachelor’s degree in healthcare administration/Health Informatics/Finance/Data Analytics/BI

Data analytics or BI certifications

Tools

Epic

NextGen

QNXT

Epic Clarity/Resolute

Job description

Title: PBS Reporting Analyst

Location: Fountain Valley

Department: Physician Billing

Status: Full-time

Shift: DAYS (Predominantly Remote)

Pay Range: $30.65/hr - $44.45/hr

MemorialCare is a nonprofit integrated health system that includes four leading hospitals, award-winning medical groups - consisting of over 200 sites of care, and more than 2,000 physicians throughout Orange and Los Angeles Counties. We are committed to increasing access to patient-centric, affordable, and high-quality healthcare; your personal contributions are integral to MemorialCare's recognition as a market leader and innovator in value-based and other care models.

Across our family of medical centers, we support each one of our bright, talented employees in reaching the highest levels of professional development, contribution, collaboration, and accountability.Whatever your role and whatever expertise you bring, we are dedicated to helping you achieve your full potential in an environment of respect, innovation, and teamwork.

Purpose Statement / Position Summary

The PBS Reporting Analyst plays a vital role in analyzing and interpreting patient billing, claims, reimbursement, and revenue cycle performance data to provide insights that support informed decision-making and enhance strategic initiatives. This position develops and maintains financial reports, dashboards, scorecards, data visualizations, and actionable insights to effectively present findings to leadership and key stakeholders. The role monitors key performance indicators, identifies revenue trends, variances, denials, underpayments, workflow errors, and potential revenue leakage, and recommends data-driven process improvements to support timely reimbursement, revenue integrity, compliance, and operational performance. The position ensures data accuracy and integrity across reporting processes, utilizes business intelligence tools to streamline data analysis and reporting, and remains current on industry best practices and emerging trends in data analysis and visualization. The position collaborates closely with billing, coding, finance, IT, clinical operations, and application teams to support reporting accuracy, system optimization, and alignment with payer requirements and regulatory standards.

Essential Functions and Responsibilities of the Job

1. Provide professional and courteous service to all customers, communicate effectively in written and verbal form, and interact in a positive and constructive manner.
2. Maintain complete patient and employer confidentiality at all times in accordance with company and HIPAA requirements. Perform job functions in accordance with current departmental and company standards, policies, procedures, and directives.
3. Demonstrate teamwork by assisting coworkers with tasks and training as directed, and attend and participate in mandatory meetings.
4. Accommodate changes in departmental workload, prioritize responsibilities, multitask effectively, and use initiative to resolve problems with appropriate action and follow-through.
5. Keep the Director informed when problems may interfere with timely completion of work.
6. Maintain a clean, well-organized, properly stocked, and secure work area.
7. Be at work and be on time.
8. If approved for remote or hybrid work, adhere to all remote work agreement requirements, including maintaining productivity, responsiveness, confidentiality, secure handling of organizational and patient information, availability during scheduled work hours, and compliance with departmental expectations and applicable policies.
9. Follow company policies, procedures and directives
10. Interact in a positive and constructive manner
11. Prioritize and multitask

Placement in the pay range is based on multiple factors including, but not limited to, relevant years of experience and qualifications. In addition to base pay, there may be additional compensation available for this role, including but not limited to, shift differentials, extra shift incentives, and bonus opportunities. Health and wellness is our passion at MemorialCare-that includes taking good care of employees and their dependents. We offer high quality health insurance plan options, so you can select the best choice for your family. And there’s more… Check out our MemorialCare Benefits for more information about our Benefits and Rewards.

Experience

1. Minimum ten (10) years of experience in patient account billing and collections, including at least five (5) years of analytical and reporting experience in healthcare revenue cycle billing, claims processing, reimbursement, medical billing, healthcare financial analytics, or related business services.
2. Strong understanding of healthcare revenue cycle operations, including patient billing, collections, claims submission, payment posting, denials, accounts receivable, reimbursement, charge capture, insurance clearinghouses, HCFA-1500 forms, 835/837 EDI files, CPT/ICD-10 coding, payer requirements, regulatory requirements, contract terms, and healthcare audit guidelines.
3. Advanced proficiency with Microsoft Excel, SQL, database management tools, billing systems, EHR systems, and business intelligence tools such as Power BI or Tableau; experience with Python or other data manipulation tools preferred.
4. Experience designing queries, manipulating large volumes of data, validating data accuracy, and transforming complex revenue cycle information into clear reports, dashboards, visualizations, and leadership presentations.
5. Knowledge of EHR and billing applications such as Epic, NextGen, QNXT, or comparable healthcare information systems preferred, including experience extracting and analyzing data from Epic Clarity, Resolute, Cogito, or equivalent reporting environments.
6. Demonstrated ability to analyze trends, identify root causes, recommend corrective actions, and support workflow optimization or process improvement initiatives; Lean or Six Sigma experience is a plus.
7. Strong analytical, problem-solving, and trend identification skills, with exceptional attention to detail and accuracy in data analysis, reporting, validation, and presentation of findings.
8. Excellent written and verbal communication skills, including good listening skills and the ability to translate complex technical, financial, and cross-platform data into clear, actionable insights for technical and non-technical audiences, leadership, and cross-functional stakeholders.
9. Proactive mindset with the ability to manage multiple projects effectively and work collaboratively in a dynamic environment.

Education

1. Bachelor’s degree in healthcare administration, Health Informatics, Finance, Data Analytics, or Business Intelligence, Statistics, or a related field preferred.
2. Relevant certifications in data analytics or business intelligence, preferred.