Senior Reporting QA & Data Validation Analyst (RCM)

Auctus Group; Philippines; Remote; PHP 900,000 - 1,800,000; Full time

Job summary

The Auctus Group is seeking a Senior Reporting QA & Data Validation Analyst to ensure accuracy across healthcare reporting systems, EHRs, and billing platforms. You will validate outputs, reconcile data, and drive data quality improvements with strong SQL and Excel skills.

Collaborate with Reporting & BI teams, operations, and engineers to trace issues, conduct regression tests, and develop reusable validation processes. Remote work supported.

Qualifications

• 3+ years of experience in data analysis, reporting quality assurance, data validation, reconciliation, or a related analytical role.
• Advanced Excel skills with pivot tables, XLOOKUP, SUMIFS, and large data comparisons.
• Strong SQL skills for querying, comparing, aggregating, reconciling, and validating data.
• Experience investigating discrepancies across reports, databases, or business systems and identifying underlying causes.
• Ability to interpret complex business rules and translate them into practical validation scenarios.
• Strong analytical thinking, troubleshooting, and problem-solving skills with attention to detail.
• Ability to independently investigate issues, follow through on findings, and manage multiple validation assignments.
• Strong written communication and documentation skills for clear findings and impact.
• Reliable computer access and a stable, high-speed internet connection suitable for remote work.

Responsibilities

• Independently validate reports, dashboards, and datasets before sharing with clients or stakeholders.
• Reconcile figures against source systems including EHRs, practice management, and billing platforms.
• Perform record-level and aggregate checks to identify missing, duplicates, or inaccuracies.
• Verify calculations, business rules, filters, date ranges, and metric definitions across reports.
• Trace discrepancies through data extraction, transformation, and reporting processes to identify root causes.
• Conduct regression testing when reporting logic or data pipelines change.
• Develop repeatable testing procedures, reconciliation templates, and validation checklists.
• Create exception reports and identify opportunities to automate validation activities.
• Document testing results, supporting evidence, business impact, corrections, and resolutions.

Skills

SQL

Excel

Power BI

Tools

Power BI

Python

Job description

Senior Reporting QA & Data Validation Analyst (RCM)

The Senior Reporting Quality Assurance & Data Validation Analyst is responsible for ensuring the accuracy, completeness, and consistency of reports across healthcare practice management systems, electronic health records (EHRs), billing platforms, and internal reporting solutions.

This role works closely with the Reporting & Business Intelligence team, operations, and technical teams to validate reporting outputs, reconcile data across systems, investigate discrepancies, and strengthen reporting quality controls. Success requires strong SQL and Excel skills, sound analytical judgment, and the ability to trace reporting issues to their source and help drive them to resolution.

What You'll Do

• Independently validate reports, dashboards, and datasets before they are shared with clients, leadership, or operational stakeholders.
• Reconcile reported figures against source systems, including EHRs, practice management platforms, billing applications, internal databases, and automated 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 differences involving posting dates, transaction dates, adjustments, voids, refunds, and reporting cutoffs, distinguishing legitimate reporting differences from actual errors.
• Trace discrepancies through data extraction, transformation, and reporting processes, working with analysts, developers, and data engineers to identify root causes and resolve issues.
• Conduct regression testing when reporting logic, data pipelines, or source systems change.
• 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.
• Partner with operational stakeholders to clarify reporting requirements and expected results, and promptly elevate material inaccuracies.
• Track recurring reporting defects and recommend improvements that strengthen data quality and reporting reliability.
• Follow company policies for patient confidentiality, HIPAA compliance, and the secure handling of sensitive healthcare information.

Qualifications

• 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 comparisons of large datasets.
• Strong SQL skills for querying, comparing, aggregating, reconciling, and validating data.
• Demonstrated experience investigating discrepancies across reports, databases, or business systems and identifying their underlying causes.
• Ability to interpret complex business rules and translate them into practical validation scenarios.
• Strong analytical thinking, troubleshooting, and problem-solving skills, 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 findings and business impact clearly.
• Reliable computer access and a stable, high-speed internet connection suitable for remote work.

Preferred Qualifications

• Experience in healthcare revenue cycle management (RCM), medical billing, or healthcare reporting, with an understanding 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.
• Experience with Power BI, Tableau, or similar business intelligence platforms.
• Familiarity with Python, Power Query, automated data validation tools, or data quality monitoring and exception reporting.
• Experience validating ETL/ELT pipelines, APIs, or database integrations.
• Familiarity with HIPAA requirements and handling sensitive healthcare information.

Who We Are

At The Auctus Group, we help healthcare providers focus on patient care by supporting the revenue cycle operations behind their practices. We bring care, dependable service, and thoughtful problem-solving to our relationships with clients and teammates.

Our culture puts people first. We have long embraced remote work and make a deliberate effort to keep our team connected. We encourage continued learning, support community giving, and value a healthy balance between professional and personal life.

Who We’re Looking For

We’re looking for curious, dependable people who take ownership of their work and care about its impact on clients and colleagues. You’ll be a strong fit if you:

• Ask thoughtful questions and verify assumptions.
• Enjoy investigating complex problems and following the evidence.
• Take responsibility for issues and help bring them to resolution.
• Communicate openly and welcome constructive feedback.
• Collaborate well with others and adapt as systems and priorities evolve.
• Look for practical ways to improve accuracy, consistency, and efficiency.

If you enjoy finding the explanation behind the numbers and helping others make decisions with confidence, we’d like to hear from you.

About The Auctus Group LLC

Who we are: We’re big on people and culture at the Auctus Group. Our most important role as a company is to provide an amazing working environment for our team. We’ve been work-from-home-warriors since before it was cool. We support (like encourage and fund) continuing education. We match charitable donations. Our whole goal is: work to live not live to work . Oh and we’re weirdos too…we do remote happy hours and have a book club and goofy stuff like that.

Who we’re looking for: Smart, talented, tech-savvy, experienced, go-getter types. You’ll do well if: