Senior Reporting QA & Data Validation Analyst (RCM)

The Auctus Group; Asturias; Remote; EUR 40,000 - 52,000; Full time

Job summary

The Auctus Group LLC in Spain is seeking a Senior Reporting Quality Assurance & Data Validation Analyst to ensure accuracy and consistency across healthcare reporting systems. You will work with the Reporting & BI team, operations, and technical staff to validate outputs, reconcile data, and strengthen quality controls in a remote, fast-paced environment.

Responsibilities include validating reports, performing reconciliations, and developing testing procedures, while ensuring compliance with

Qualifications

• 3+ years in data analysis, reporting QA, data validation, or similar analytical role.
• Advanced Excel skills: pivot tables, XLOOKUP, SUMIFS, etc.
• Strong SQL skills for querying, comparing, aggregating, reconciling data.
• Experience investigating discrepancies across reports, databases, or systems.
• Ability to interpret complex business rules and translate to validation scenarios.
• Strong written communication and documentation skills, with attention to detail.
• Reliable remote work setup and internet connection.

Responsibilities

• Independently validate reports, dashboards, and datasets before sharing with clients or leadership.
• Reconcile figures against source systems including EHRs, PM platforms, billing apps, and internal databases.
• Perform record- and aggregate-level checks to identify missing, duplicate, or inconsistent data.
• Verify calculations, business rules, and metric definitions across financial and operational 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 and validation checklists for recurring reports.
• Create exception reports and opportunities to automate validation activities.
• Document testing results, supporting evidence, business impact, and resolutions for audit readiness.
• Collaborate with stakeholders to clarify requirements and escalate material inaccuracies.
• Track recurring defects and propose improvements to data quality and reliability.
• Follow HIPAA and secure handling of healthcare information.

Skills

Advanced Excel

SQL

Data validation

Data analysis

Attention to detail

Remote work setup

Tools

Power BI

Tableau

Job description

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:

• you like a fast-paced environment,
• you thrive with change and development,
• you like giving feedback,
• you’re a team player,
• you love learning/sleuthing,
• you’re big on accountability.

About The Role

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

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