Accounting Data Analyst

About the position Founded in 1977 as the Senior Care Action Network, SCAN began with a simple but radical idea: that older adults deserve to stay healthy and independent. That belief was championed by a group of community activists we still honor today as the “12 Angry Seniors.” Their mission continues to guide everything we do. Today, SCAN is a nonprofit health organization serving more than 500,000 people across Arizona, California, Nevada, New Mexico, Texas, and Washington, with over $8 billion in annual revenue. With nearly five decades of experience, we have built a distinctive, values-driven platform dedicated to improving care for older adults. Our work spans Medicare Advantage, fully integrated care models, primary care, care for the most medically and socially complex populations, and next-generation care delivery models. Across all of this, we are united by a shared commitment: combining compassion with discipline, innovation with stewardship, and growth with integrity. At SCAN, we believe scale should strengthen—not dilute—our mission. We are building the future of care for older adults, grounded in purpose, accountability, and respect for the people and communities we serve. The Accounting Data Analyst is responsible for managing financial records, preparing financial reports, analyzing financial data, and ensuring compliance with accounting regulations. They may also assist with budgeting, forecasting, and financial analysis tasks to support the organization's financial goals and objectives. Additionally, they may collaborate with internal and external stakeholders to provide financial information and support decision-making processes. 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. • All other duties as assigned. 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 • Base Pay Range: $92,400 to $140,000 annually • Work Mode: Mostly Remote • 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 • An opportunity to become part of a team that makes a difference to our members and our community every day • A competitive compensation and benefits program; • An annual employee bonus program; • Generous paid-time-off (PTO); • Eleven paid holidays per year; • Excellent Retirement Savings program; • A work-life balance; • An opportunity to become part of a team that makes a difference to our members and our community every day! Apply tot his job