Business Analyst
New England Life Care
SQL
Job Level
Mid-LevelSenior
Tech Stack
SQL
About the role
- Research unmatched bank deposits and identify corresponding insurance remittance checks by querying internal databases, analyzing payment data, and manually reviewing insurance portals
- Develop understanding of payer-specific remittance patterns to more efficiently match payments
- Escalate unusual or complex cases that deviate from known patterns to relevant team members
- Partner closely with the EOB/posting team to resolve mismatches that affect revenue recognition
- Assist in determining what portion of matched payments can be posted to patient encounters
- Ensure clean data handoff from reconciliation to posting workflows
- Ingest uploaded deposit slips and check PDFs into structured formats
- Maintain clean, complete, and auditable data for downstream posting or reconciliation processes
Requirements
- Must have: Strong proficiency in SQL
- Required: Proficiency in Microsoft Excel (VLOOKUPs, pivot tables, filters, formulas)
- Experience working with structured data; comfort with financial/RCM datasets
- Bachelor's degree in Information Systems, Computer Science, Mathematics, Healthcare Informatics, or related field
- Hands-on experience with RCM systems and billing automation rules is preferred
- Strong attention to detail with an investigative mindset
- Ability to work independently and follow SOPs with high accuracy
- Comfortable working with structured data and spreadsheets
- Prior experience in revenue cycle operations or EOB/835 reconciliation is a plus
- Strong written and verbal communication skills
- Adaptability to evolving business needs and a continuous improvement mindset
- Ability to thrive under pressure and efficiently handle multiple priorities
- A proactive approach to problem-solving and a strong sense of accountability
- Willingness to work night shift (10PM-7AM)
