Accounting Data Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

SCAN · 15 hours ago

Accounting Data Analyst

SCAN is a nonprofit health organization dedicated to improving care for older adults. The Accounting Data Analyst is responsible for managing financial records, preparing financial reports, and ensuring compliance with accounting regulations while collaborating with various stakeholders to support financial goals and objectives.

Elder CareHealth CareHome Health CareMedical
check
Comp. & Benefits

Responsibilities

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
We seek Rebels who are curious about AI and its power to transform how we operate and serve our members
All other duties as assigned

Qualification

SQLAlteryxAdvanced ExcelFinancial analysisReconciliation methodsAnalytical skillsHealthcare experienceGeneral ledger understanding

Required

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
Required: 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
Required: 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

Company

SCAN

twittertwittertwitter
company-logo
About SCAN Keeping Seniors Healthy and Independent–that’s been our mission for more than 40 years.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Lyn Amor Macaraeg
CVP Chief of Staff & Strategic Advisor to the CEO
linkedin
leader-logo
Sachin H. Jain, MD, MBA
President and CEO, Board Director
linkedin
Company data provided by crunchbase