The payment received after query pulls claims that have received a payment after the claim had been written off. When is the Query Worked? Collections receives the payment received after query every ...
The payment received after query pulls claims that have received a payment after the claim had been written off. When is the Query Worked? Collections receives the payment received after query every ...
C#/.Net Production Support Engineer
Manhattan, NY · On-site
$46.25 - $60.25/hr
... query writing. Monitor and assess incoming support tickets, prioritizing as necessary. Troubleshoot and resolve complex issues independently. Develop and implement permanent solutions after ...
C#/.Net Production Support Engineer
Manhattan, NY · On-site
$46.25 - $60.25/hr
... query writing. Monitor and assess incoming support tickets, prioritizing as necessary. Troubleshoot and resolve complex issues independently. Develop and implement permanent solutions after ...
Senior Software Engineer
Sunnyvale, CA · Hybrid
$143K - $189K/yr
Collaborating closely with cross-functional teams across query, platform, and cloud, you will help ... visa petitions filed after September 21, 2025 for new hires. We are still able to consider ...
Senior Software Engineer
Sunnyvale, CA · Hybrid
$143K - $189K/yr
Collaborating closely with cross-functional teams across query, platform, and cloud, you will help ... visa petitions filed after September 21, 2025 for new hires. We are still able to consider ...
C#/.Net Production Support Engineer
$100K - $110K/yr
The position requires expertise in a general programming language and database query writing. Key ... Develop and implement permanent solutions after identifying root causes. Identify opportunities for ...
New
C#/.Net Production Support Engineer
$100K - $110K/yr
The position requires expertise in a general programming language and database query writing. Key ... Develop and implement permanent solutions after identifying root causes. Identify opportunities for ...
New
Power BI Developer
Plano, TX · On-site
You should have experience in Developing Power BI reports & effective dashboards after gathering ... You should have Hands on Query writing and query performance optimization
Power BI Developer
Plano, TX · On-site
You should have experience in Developing Power BI reports & effective dashboards after gathering ... You should have Hands on Query writing and query performance optimization
After a major architectural upgrade and the launch of TraceQL metrics, we are shifting from ... Push performance further: faster query latency at hundreds of MB/s ingestion and performant 30-day ...
After a major architectural upgrade and the launch of TraceQL metrics, we are shifting from ... Push performance further: faster query latency at hundreds of MB/s ingestion and performant 30-day ...
Software Engineer, Storage
New York, NY · On-site
Building query attribution and guardrails: instrumenting every database query by service, catching ... After, we'll schedule an onsite in our office, where you'll work on a small project, discuss ideas ...
Software Engineer, Storage
New York, NY · On-site
Building query attribution and guardrails: instrumenting every database query by service, catching ... After, we'll schedule an onsite in our office, where you'll work on a small project, discuss ideas ...
IT - Programmer Analyst
Lewisville, TX · On-site
$32 - $41.50/hr
Requires participating in the on-call rotation to provide assistance during after-hours to support ... Proficient with structured query language (SQL) through query writing and/or ad hoc reporting is ...
IT - Programmer Analyst
Lewisville, TX · On-site
$32 - $41.50/hr
Requires participating in the on-call rotation to provide assistance during after-hours to support ... Proficient with structured query language (SQL) through query writing and/or ad hoc reporting is ...
Senior Revenue Accountant (Remote | Charlotte, NC)
Charlotte, NC · Remote
$60 - $65/hr
Drive process automation initiatives, including advanced use of Power Query. * Participate in ... Benefits (After Waiting Period) * Weekly pay * Dental and Vision coverage * Health Savings Account ...
Quick apply
Senior Revenue Accountant (Remote | Charlotte, NC)
Charlotte, NC · Remote
$60 - $65/hr
Drive process automation initiatives, including advanced use of Power Query. * Participate in ... Benefits (After Waiting Period) * Weekly pay * Dental and Vision coverage * Health Savings Account ...
IT - Programmer Analyst
Lewisville, TX · On-site
$32 - $41.50/hr
Requires participating in the on-call rotation to provide assistance during after-hours to support ... Proficient with structured query language (SQL) through query writing and/or ad hoc reporting is ...
IT - Programmer Analyst
Lewisville, TX · On-site
$32 - $41.50/hr
Requires participating in the on-call rotation to provide assistance during after-hours to support ... Proficient with structured query language (SQL) through query writing and/or ad hoc reporting is ...
Senior SQL Server Database Administrator - TS required to apply - Wash DC + Hybrid
Washington, DC · On-site
$175K - $190K/yr
... query optimization • Develop and manage backup and recovery strategies • Enforce database ... for after-hours support • Install and support Oracle databases Required Qualifications: • ...
Senior SQL Server Database Administrator - TS required to apply - Wash DC + Hybrid
Washington, DC · On-site
$175K - $190K/yr
... query optimization • Develop and manage backup and recovery strategies • Enforce database ... for after-hours support • Install and support Oracle databases Required Qualifications: • ...
Senior SQL Server Database Administrator - TS required to apply - Wash DC + Hybrid
Washington, DC · Hybrid
... query optimization • Develop and manage backup and recovery strategies • Enforce database ... for after-hours support • Install and support Oracle databases Required Qualifications: • ...
Senior SQL Server Database Administrator - TS required to apply - Wash DC + Hybrid
Washington, DC · Hybrid
... query optimization • Develop and manage backup and recovery strategies • Enforce database ... for after-hours support • Install and support Oracle databases Required Qualifications: • ...
Radiology - Breast Physician
$318K - $398K/yr
EPIC/PowerScribe/PACS Number of Radiologist in Practice: 8 on team - 2 leaving = 6 total after ... Self-Query NPDB
Radiology - Breast Physician
$318K - $398K/yr
EPIC/PowerScribe/PACS Number of Radiologist in Practice: 8 on team - 2 leaving = 6 total after ... Self-Query NPDB
Senior SQL Server Database Administrator - TS required to apply - Wash DC + Hybrid
Washington, DC · On-site
$175K - $190K/yr
... query optimization • Develop and manage backup and recovery strategies • Enforce database ... for after-hours support • Install and support Oracle databases Required Qualifications: • ...
Quick apply
Senior SQL Server Database Administrator - TS required to apply - Wash DC + Hybrid
Washington, DC · On-site
$175K - $190K/yr
... query optimization • Develop and manage backup and recovery strategies • Enforce database ... for after-hours support • Install and support Oracle databases Required Qualifications: • ...
Physician Radiology-Breast - Competitive Salary
$318K - $398K/yr
EPIC/PowerScribe/PACS Number of Radiologist in Practice: 8 on team - 2 leaving = 6 total after ... Self-Query NPDB
Physician Radiology-Breast - Competitive Salary
$318K - $398K/yr
EPIC/PowerScribe/PACS Number of Radiologist in Practice: 8 on team - 2 leaving = 6 total after ... Self-Query NPDB
Locum to Perm - Mammography Radiologist Needed in Springfield, MA - No Weekends or Call!
Springfield, MA · On-site
$318K - $398K/yr
EPIC/PowerScribe/PACS Number of Radiologist in Practice: 8 on team - 2 leaving = 6 total after ... Self-Query NPDB
Locum to Perm - Mammography Radiologist Needed in Springfield, MA - No Weekends or Call!
Springfield, MA · On-site
$318K - $398K/yr
EPIC/PowerScribe/PACS Number of Radiologist in Practice: 8 on team - 2 leaving = 6 total after ... Self-Query NPDB
NoSql DBA
Charlotte, NC · On-site
Support application teams in query tuning, schema design, and data modeling * Maintain high ... Experience supporting production environments during and after patching * Strong knowledge of ...
NoSql DBA
Charlotte, NC · On-site
Support application teams in query tuning, schema design, and data modeling * Maintain high ... Experience supporting production environments during and after patching * Strong knowledge of ...
... a query they wrote against CIAT's datalake After lunch you might pair with a Data Engineer on the data model behind a new WBR metric, draft the narrative for that week's review, and review another ...
... a query they wrote against CIAT's datalake After lunch you might pair with a Data Engineer on the data model behind a new WBR metric, draft the narrative for that week's review, and review another ...
Cyber Security Incident and Event Management/Elastic Specialist with Security Clearance
Washington, DC · On-site
... query language • Track the health of the Elastic environment and optimize its performance ... after-action reports (AAR) post-incident • In addition, the role may include assistance with ...
Cyber Security Incident and Event Management/Elastic Specialist with Security Clearance
Washington, DC · On-site
... query language • Track the health of the Elastic environment and optimize its performance ... after-action reports (AAR) post-incident • In addition, the role may include assistance with ...
Business Intelligence Engineer II, AWS DC Central Operations
Seattle, WA · On-site
$58 - $75.50/hr
... a query they wrote against CIAT's datalake After lunch you might pair with a Data Engineer on the data model behind a new WBR metric, draft the narrative for that week's review, and review another ...
Business Intelligence Engineer II, AWS DC Central Operations
Seattle, WA · On-site
$58 - $75.50/hr
... a query they wrote against CIAT's datalake After lunch you might pair with a Data Engineer on the data model behind a new WBR metric, draft the narrative for that week's review, and review another ...
After Query information
See salary details
$5.29 - $10.66
0% of jobs
$10.66 - $16.04
14% of jobs
$16.04 - $21.42
0% of jobs
$21.42 - $26.79
0% of jobs
$31.24 is the 25th percentile. Wages below this are outliers.
$26.79 - $32.17
14% of jobs
$32.17 - $37.54
6% of jobs
$37.54 - $42.92
7% of jobs
The median wage is $46.43 / hr.
$42.92 - $48.30
14% of jobs
$52.13 is the 75th percentile. Wages above this are outliers.
$48.30 - $53.67
28% of jobs
$53.67 - $59.05
8% of jobs
$59.05 - $64.42
8% of jobs
$5
$42
$64
How much do after query jobs pay per hour?
What is the difference between After Query vs Data Analyst?
| Aspect | After Query | Data Analyst |
|---|---|---|
| Required Credentials | Typically requires a basic understanding of database querying, often with certifications like SQL certification | Requires strong analytical skills, proficiency in SQL, Excel, and data visualization tools, often with a degree in data science, statistics, or related fields |
| Work Environment | Primarily works in database environments, often within IT or database teams | Works across departments, analyzing data to support business decisions in various industries |
| Employer & Industry Usage | Used mainly in IT, database management, and software companies | Common in finance, marketing, healthcare, and consulting firms |
While both roles involve working with data, After Query focuses on executing database queries to retrieve information, whereas Data Analysts interpret and analyze data to provide insights for decision-making.
What are the key skills and qualifications needed to thrive as an After Query, and why are they important?
What job makes 10,000 a month without a degree?
What does AfterQuery do?
What are some common challenges faced by professionals in After Query roles, and how can they be addressed?
What are After Query jobs?
Which 3 jobs will survive AI?
What jobs pay 2000 a day?

Other
Posted 16 days ago
Job description
ATB
What is an ATB?
ATB stands for aged trial balance and includes all claims for a specific time period that do not have a zero balance.
Why do we do the ATB:
ATB is done as an effort to improve collection rates, reduce bad debt and assist in meeting quarterly reserve risk goals.
ATB Process Details:
- Collections supervisor receives correspondence and EOB's from Cash team.
- Denials are distributed to plan owners who then log them on a spreadsheet, including the denial code, denial reason, and action code and action reason.
- Run ATB query for specific time period. Standard is working 60 days back for the preceding four months.
- V-lookup denials and action codes from denial log spreadsheet.
- Run query to pull in batch and check numbers associated with claims. Research in Filebound for additional denials.
- Research credits to determine whether there are two payments applied to the claim or if there is an overpayment. Determine whether a refund is due to insurance or member. If there is a refund due, complete refund request. If there are two payments applied and one belongs to a different invoice, complete redirect.
- Open claims with no payment, nor denial, see resubmit instructions.
- If a claim has already been resubmitted and still neither payment, nor denial has been received, contact payer to check status of the claim and work towards a resolution.
- Once all actions have been determined, send write offs for approval to supervisor. For all write offs over $1000, they must be approved by finance manager.
- Identify trends within payers to find issues. If there is an issue within plan set up, forward it to be corrected. Work with payer relations and/or payer directly to resolve outstanding issues affecting payment.
- Complete all actions: write offs, resubmits, calls, e-mails and post to K: Drive for auditing.
How does this relate to claims?
- Effective claims processes to ensure claim accuracy and workarounds increase likelihood of prompt payment, reducing the ATB and improving collection rates.
- Processes for bill actual plans can affect over/short write offs on the ATB.
Resubs (Part 2 of 2)
Collections process for resubmitting a claim:
A claim will be resubmitted if:
- There was no payment or denial received
- We received a denial instructing a correction to be made
Collections resubmits the claim and waits for Claims to work and deliver to Plan owner. The plan owner would make any necessary corrections to the claim and mail to the Payer. For 837 plans, corrections need to be made in the 400 prior to the claim being resubmitted.
Challenges to resubmitting a claim
- There are no ways to track a resubmitted claim in our system.
- Collections relies on the claims team to make sure they receive the resubmitted claims in order to make proper corrections.
Payment Received After
What is the Payment Received After Query?
The payment received after query pulls claims that have received a payment after the claim had been written off.
When is the Query Worked?
Collections receives the payment received after query every Wednesday from their supervisor. Each team member researches their plans' claims to determine if the payment belongs on the claim. If payment is misapplied, the owner redirects to correct invoice or unapplies payment if correct invoice cannot be determined.
About Real Soft
Sourced by ZipRecruiter
Industry
It services
Company size
501 - 1,000 Employees
Headquarters location
Monmouth Junction, NJ, US
Year founded
1991