09 nov
|
The Auctus Group
|
Arcos de la Frontera
09 nov
The Auctus Group
Arcos de la Frontera
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 presente 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.
- Ex
📌 Senior Reporting Qa (Arcos de la Frontera)
🏢 The Auctus Group
📍 Arcos de la Frontera