Senior Reporting QA & Data Validation Analyst (RCM)

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

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.