Senior Reporting QA & Data Validation Analyst (RCM)

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:

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