Senior Reporting QA & Data Validation Analyst (RCM)

Remote; San Francisco (CA); Remote; USD 90,000 - 140,000; Full time

Benefits offered by this job

Remote-first environment

Education and training support

Charitable donation matching

People-focused culture

Work-life balance

Remote team activities

Job summary

Partner Company is seeking a Senior Reporting QA & Data Validation Analyst (RCM) to ensure accuracy across healthcare reporting systems. You will validate reports, reconcile against source systems, and investigate discrepancies using SQL and advanced Excel.

This remote role involves collaboration with BI, operations, and engineering teams to strengthen data quality, automate validation tasks, and maintain audit-ready documentation while maintaining HIPAA compliance.

Qualifications

• 3+ years in data analysis, reporting quality assurance, data validation, or related analytics role.
• Experience validating healthcare data and reports is preferred.
• Strong SQL skills for data comparison, reconciliation, and validation.
• Advanced Excel skills: pivot tables, XLOOKUP, SUMIFS, large datasets.

Responsibilities

• Independently validate reports, dashboards, and datasets before distribution to stakeholders.
• Reconcile figures against source systems (EHRs, practice management, billing systems).
• Perform record- and aggregate-level checks for data accuracy.
• Verify calculations, business rules, filters, date ranges, and metric definitions.
• Investigate discrepancies and distinguish errors from legitimate differences.
• Trace issues through ETL processes with data engineers and developers.
• Conduct regression testing when data pipelines or source systems update.
• Develop repeatable testing procedures and validation checklists.
• Create exception reports and explore automation opportunities.
• Document testing results, evidence, business impact, and resolutions for audit readiness.
• Communicate requirements and validate results with stakeholders.
• Monitor recurring defects and advocate data quality improvements.
• Adhere to HIPAA and secure handling of health information.

Skills

Data analysis

Data validation

SQL

Advanced Excel

Power BI

Tableau

Healthcare domain knowledge

Documentation

Tools

Power BI

Tableau

ETL/ELT tools

SQL tooling

Job description

This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for a Senior Reporting QA & Data Validation Analyst (RCM) based in India.

As a Senior Reporting QA & Data Validation Analyst, you will play a key role in ensuring the accuracy, consistency, and reliability of healthcare reporting across multiple systems and platforms. You will work closely with reporting, business intelligence, operational, and technical teams to validate data, reconcile figures, and investigate discrepancies. Your work will help ensure that financial, operational, productivity, and revenue cycle reports provide dependable insights for business decisions. You will use SQL and advanced Excel to trace data issues, identify root causes, and support effective resolutions. In this remote role, you will also help strengthen quality controls, improve validation processes, and promote secure handling of sensitive healthcare information. This is an opportunity to contribute to a collaborative, learning-oriented environment where accountability, curiosity, and continuous improvement are valued.

Accountabilities:

• Independently validate reports, dashboards, and datasets before distribution to clients, leadership, and operational stakeholders.

• Reconcile reported figures against source systems, including electronic health records (EHRs), practice management platforms, billing applications, internal databases, and automated data extracts.

• Perform record-level and aggregate-level checks to identify missing, duplicate, inaccurate, or inconsistent data.

• Verify calculations, business rules, filters, date ranges, and metric definitions across financial, operational, productivity, and revenue cycle reports.

• Investigate discrepancies related to posting dates, transaction dates, adjustments, voids, refunds, and reporting cutoffs, distinguishing legitimate reporting differences from actual errors.

• Trace reporting issues through data extraction, transformation, and reporting processes, collaborating with analysts, developers, and data engineers to identify root causes and drive resolution.

• Conduct regression testing when reporting logic, data pipelines, or source systems are updated.

• Develop repeatable testing procedures, reconciliation templates, and validation checklists for recurring reports.

• Create exception reports and identify opportunities to automate repetitive validation activities.

• Document testing results, supporting evidence, business impact, recommended corrections, and resolutions to maintain clear records and support audit readiness.

• Work with operational stakeholders to clarify reporting requirements, confirm expected results, and elevate material inaccuracies promptly.

• Monitor recurring reporting defects and recommend improvements to strengthen data quality, accuracy, and reporting reliability.

• Follow applicable policies and procedures for patient confidentiality, HIPAA compliance, and secure handling of sensitive healthcare information.

Requirements:

• At least 3 years of experience in data analysis, reporting quality assurance, data validation, reconciliation, or a related analytical role.

• Advanced Microsoft Excel skills, including pivot tables, XLOOKUP, SUMIFS, conditional formulas, and large-dataset comparisons.

• Strong SQL skills, including the ability to query, compare, aggregate, reconcile, and validate data.

• Demonstrated experience investigating discrepancies across reports, databases, or business systems and identifying underlying causes.

• Ability to interpret complex business rules and translate them into practical data validation scenarios.

• Strong analytical thinking, troubleshooting, and problem-solving abilities, with consistent attention to detail and accuracy.

• Ability to independently investigate issues, follow through on findings, and manage multiple reporting validation assignments.

• Strong written communication and documentation skills, including the ability to explain technical findings and business impact clearly.

• Reliable computer access and a stable, high-speed internet connection suitable for remote work.

• Experience in healthcare revenue cycle management (RCM), medical billing, or healthcare reporting is preferred, particularly with knowledge of accounts receivable, charges, payments, adjustments, denials, collections, and financial reconciliation.

• Familiarity with EHR or practice management platforms such as ModMed, Tebra, Nextech, DrChrono, AdvancedMD, athenahealth, or OpenPM is an advantage.

• Experience with Power BI, Tableau, or similar business intelligence platforms is beneficial.

• Familiarity with Python, Power Query, automated data validation tools, data quality monitoring, or exception reporting is an advantage.

• Experience validating ETL/ELT pipelines, APIs, or database integrations is preferred.

• Knowledge of HIPAA requirements and experience handling sensitive healthcare information are beneficial.

• Strong ownership, curiosity, accountability, adaptability, and collaboration skills, with a willingness to ask questions, verify assumptions, welcome feedback, and pursue continuous learning.

Benefits:

• Remote-first working environment with an established work-from-home culture.

• Support for continuing education and professional development.

• Funding or reimbursement support for continuing education, as described in the original posting.

• Charitable donation matching.

• A people-focused culture that encourages collaboration, learning, and team connection.

• Emphasis on work-life balance and a healthy approach to professional and personal commitments.

• Opportunities to participate in remote team activities, including informal social events and a book club.