Accounting Data Analyst (Agency Temp)

SCAN Health Insurance • Yountville, CA

5d

About The Position

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.

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.

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.

Benefits

• 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!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level