Senior Reporting QA & Data Validation Analyst (RCM)

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.

• 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 escalate 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.

• 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.