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.