Senior Reporting QA & Data Validation Analyst (RCM)
Core
Ensure accuracy, consistency, and reliability of healthcare reporting across multiple systems by validating data, reconciling figures, and investigating discrepancies to support business decisions.
Role type
Senior IC reporting QA & data validation analyst
Builds
Dependable financial, operational, productivity, and revenue cycle reports for business decisions
Domain
Healthcare revenue cycle management (RCM) and data quality
Deliverable
dashboards & analysis
Required skills
SQL, Advanced Excel, Data reconciliation, Root cause analysis, Business rule interpretation, Data quality monitoring, Documentation, Regression testing
Preferred skills
Healthcare RCM domain knowledge, EHR/Practice management platforms, Power BI/Tableau, Python/Power Query, ETL/ELT pipeline validation, HIPAA compliance
Technologies
SQL, Microsoft Excel, EHRs, Practice management platforms, Power BI, Tableau, Python, Power Query
Responsibilities
Independently validate reports, dashboards, and datasets before distribution; Reconcile reported figures against source systems including EHRs and billing applications; Perform record-level and aggregate-level checks to identify data issues; Verify calculations, business rules, filters, and metric definitions; Investigate discrepancies related to posting dates, transactions, and adjustments; Trace reporting issues through data extraction and transformation processes; Conduct regression testing when reporting logic or pipelines are updated; Develop repeatable testing procedures and validation checklists; Create exception reports and identify automation opportunities; Document testing results and support audit readiness; Monitor recurring reporting defects and recommend improvements.
Seniority
Senior, hands-on IC