SCAN

Accounting Data Analyst

SCAN

full-time

Posted on:

Location Type: Remote

Location: CaliforniaUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $92,400 - $140,000 per year

Tech Stack

About the role

  • Conducts monthly and quarterly financial reconciliations, reviewing account activity and resolving discrepancies to maintain accurate financial records.
  • Reconciles data across financial, billing, and operational systems to ensure completeness, consistency, and alignment of key datasets.
  • Maintains and enhances the billing module by updating logic, troubleshooting issues, and supporting automation using Alteryx, SQL, and advanced Excel/VBA.
  • Completes daily and monthly cash reconciliations by matching bank activity to system postings and resolving unapplied or unidentified payments.
  • Performs detailed revenue reconciliations, validating billed, recognized, and collected revenue and supporting month-end close activities.
  • Monitors data quality across financial processes by implementing reconciliation controls, documenting workflows, and ensuring audit readiness.
  • Collaborates with Finance, RCM, IT, and Operations to resolve issues, validate system changes, and improve end-to-end financial and billing workflows.

Requirements

  • Bachelor's Degree or equivalent experience in accounting or other finance related environments
  • Minimum of 2 years of experience in accounting, with strong preference in healthcare
  • Strong analytical skills with the ability to interpret complex financial and operational data
  • Working knowledge of SQL to write and interpret SQL queries for data extraction, validation, and transformation
  • Proficiency in reconciliation methods, variance investigation, and root-cause analysis
  • Ability to build, maintain, and troubleshoot data workflows in Alteryx
  • Solid understanding of financial statements, general ledger structure, and revenue-cycle processes
  • Ability to analyze large, complex financial datasets and identify variances or discrepancies
  • Advanced Excel skills, including pivot tables, formulas, power queries, and VBA automation.
Benefits
  • An annual employee bonus program
  • Robust Wellness Program
  • Generous paid-time-off (PTO)
  • 11 paid holidays per year
  • 1 floating holiday, birthday off, and 2 volunteer days
  • Excellent 401(k) Retirement Saving Plan with employer match
  • Robust employee recognition program
  • Tuition reimbursement

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
financial reconciliationdata validationvariance investigationroot-cause analysisSQLAlteryxadvanced ExcelVBArevenue reconciliationcash reconciliation
Soft skills
analytical skillsproblem-solvingcollaborationattention to detailcommunication
Certifications
Bachelor's Degree in Accountingequivalent experience in finance