Accounting Data Analyst (Agency Temp)

SCAN Group is a not-for-profit organization dedicated to tackling the most pressing issues facing older adults in the United States. SCAN Group is the sole corporate member of SCAN Health Plan, one of the nation's leading not-for-profit Medicare Advantage plans, serving more than 277,000 members in California, Arizona, Nevada, Texas and New Mexico. SCAN has been a mission-driven organization dedicated to keeping seniors healthy and independent for more than 45 years and is known throughout the healthcare industry and nationally as a leading expert in senior healthcare.

SCAN employees are a group of talented, passionate professionals who are committed to supporting older adults on their aging journey, while also innovating healthcare for seniors everywhere. Employees are provided in-depth training and access to state-of-the-art tools necessary to do their jobs, as well as development and growth opportunities. SCAN takes great pride in recognizing our team members as experts in their fields and rewarding them for their efforts. If you are interested in becoming part of an organization that is innovating senior healthcare visit www.thescangroup.org, www.scanhealthplan.com, or follow us on LinkedIn, Facebook, and Twitter.

Job Description:

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

Qualifications:

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

What's in it for you:

• An opportunity to become part of a team that makes a difference to our members and our community every day!

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)