Accounting Data Analyst – Agency Temp
SCAN
full-time
Posted on:
Location Type: Office
Location: California • California • 🇺🇸 United States
Visit company websiteJob Level
JuniorMid-Level
Tech Stack
SQLVBA
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
- 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!
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